Filter report data before rendering

[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

[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.