Posts Tagged ssrs
Missing Parameters in SSRS
Posted by Elizabeth James in Microsoft on June 25th, 2010
For you SSRS report developers out there, have you ever received the error “Must define scalar variable @<variable name>” and then drove yourself crazy trying to troubleshoot it? You probably even checked your Report Parameters a dozen more times to make sure you weren’t crazy or blind?
I have experienced this issue on several occasions while working in SQL Server Business Intelligence Development Studio. I have yet to zero in on exactly what causes this to happen, but it appears to happen during times when I am making several changes to a report in fairly quick succession, toggling between the Data, Layout, and Preview tabs.
In this example, I received the error “Must declare scalar variable @StartDate”
I looked at my input parameters (Report >> Report Parameters) and all parameters were defined. I looked at my SQL statement and all parameters were included in the query and had the correct names. Nothing seemed out of the ordinary. I then checked the Dataset settings and on the Parameters tab noticed that all of my parameters were missing. They just disappeared!
All you have to do is re-enter your parameters in this window, and your report should run just fine.
Displaying Email Text in a CRM Report
Posted by Cory Fellers in Dynamics CRM on August 28th, 2009
If you have ever built a custom report Dynamics CRM that references the Description field of the email entity, you probably realized that the body of an email is stored in the database in HTML format. Thus your report may have looked something like this:
In order to display an email correctly in an SSRS report you need to add a function into the code library of the report and then reference that function in your data field. To drop in the code, navigate to Report -> Report Properties -> Code. The following function can be used to strip HTML from an input field: Read the rest of this entry »


