Page 1 of 1

Filter report data before rendering

Posted: Mon Feb 07, 2011 5:48 am
by ROHIT GUPTA
Hello,

i wants to provide report all data and wants to filter data before rendering as per requirement with variables

i.e. Suppose i wants to get client list of India, and USA, but i wants to use "select * from client" query and wants to set variables in report to show records for required countries.

I am providing countries from visual studio.net

Please help me if it is possible.

Rohit Gupta

Filter report data before rendering

Posted: Mon Feb 07, 2011 7:54 am
by Alex K.
Hello,

f we have correctly understood your problem. You can add variables to the report, use them in the data filter and their values are passed from your application code as follows. If a report is not compiled then you can use the following code:

Code: Select all

report.Dictionary.Variables[MyVariable].Value = Value;
else

Code: Select all

report[MyVariable] = Value;
Thank you.