0

I have just started to learn SSRS. I'm using Visual Studio 2008 and SQL Server 2008. I have done all the basic things to create a table. But I'm getting this error while previewing.

Error Message

This is my query:

SELECT        
    RegisterNumber, StudentName, CollegeName, CollegeCode, 
    DegreeName, YearSem, GroupName, SubGroupName, 
    SubjectName, SubjectCode, TheoryMarks, 
    TheoryMin, TheoryMax, TheoryTotal, 
    TheoryIAMarks, TheoryIAMin, TheoryIAMax, TheoryIATotal, 
    TheoryNetTotal, PracticalMarks, PracticalMin, PracticalMax, 
    PracticalTotal, PracticalIAMarks, PracticalIAMin, 
    PracticalIAMax, PracticalIATotal, PracticalNetTotal, 
    VivaVoice, VivaVoiceMin, VivaVoiceMax, SubjectTotal, 
    SubGroupTotal, GroupTotal, TotalMarks, SubjectMin, 
    SubjectMax, SubjectCredits, SubjectGPA, SubjectGPW, 
    MarksPercent, AlphaSign, SemesterTotal, 
    IsSemesterPass, Remarks
FROM
    UGFinalResultTable_Nov2015
WHERE        
   (RegisterNumber = @RegisterNumber)

While I run the query in the query designer pane, it works fine and shows up the correct report. But while preview it shows that error. Can anyone guide me with that? Thanks in advance. This are my Report Parameters:

Report Parameters

And here is the filter that I provided:

Filters

When I set the Parameter properties like this:

Available Values: None

and

Default values: No default value

than there is no error message. But neither the report is shown. Here is how the output looks like with this setting:

Preview without parameter setting

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
StackUseR
  • 884
  • 1
  • 11
  • 40

1 Answers1

1

The report parameter needs to have its own separate dataset and NOT the same as the main report. You may use the same SQL code but label this as dataset_param for example and use this as a dataset source for your parameter.

SuperSimmer 44
  • 964
  • 2
  • 7
  • 12