SSRS report passes null value please help

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » SSRS report passes null value please help

SSRS report passes null value please help

Rate Topic

Display Mode

Topic Options

Author

Message

canasdaq_deals

Posted Wednesday, November 07, 2012 2:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 07, 2012 6:43 AM
Points: 1, Visits: 5

Hello,
I am totally new to SSRS and getting an error for more than a week and cant figure out how to fix it. Can someone please help me. I've some parameters already added to an existing report and i'm trying to view the report. Everytime i try to do it, i get and error saying

An error occured during local report processing.
An error has occured local report processing.
One or more parameters required to run the report have not been specified.

Looking at the last line of the error, i assumed that the values in the drop downs of the parameters need to be changed and selected values and then tried to view the report but i still get the same error. Then i tried using the profiler and ran the query which turned out that the parameters are returning only null values. Can anyone please help me what could be the reason and how can i fix it?

Thank you so much for all the help in advance

Thanks

Post #1381853

Daniel Bowlin

Posted Wednesday, November 07, 2012 8:53 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:10 PM
Points: 2,673, Visits: 2,418

Are you using a stored procedure? Maybe it has more parameter inputs than you are sending.

Post #1382031

« Prev Topic | Next Topic »

Permissions