May 21, 2009 at 9:27 pm
Hi All,
1. I need to know how to send only selected parameters out of all parameters to SSRS 2005 Report.
2. How to send null values to DateTime Type parameter. Currently i'm passing all values through a string array.
May 22, 2009 at 11:53 am
Can you post some examples? Are you using select list parameters or textboxes? By default SSRS passes the value in each parameter. You can use IIF to determine if you should use the parameter in your dataset. Something like:
="Select * from table " + IIF(Parameters!ParamName.Value = "", "", "Where column = '" + Parameters!ParamName.Value + "'")
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 25, 2009 at 5:15 am
Dear Jack Corbett,
I'm having 2 DateTime Type report parameters as "Delivery Date From" and "Delivery Date To". And also i have place a "@LogedUser" hidden parameter to pass the application user from my c# application. Based on the given user, some list boxes filled accordingly. So my requirement is only to pass value to @LogedUser paramter. But i can't pass NULL values to those 2 DateTime parameters. I ve tried to pass a '1/1/1900' to report, but those value displaying too and will disrupt interface too. please provide me a solution for this matter...
Thanks
May 26, 2009 at 12:09 pm
Can you post the C# code calling the report?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply