Hi my SSRS Report is query based now is there a way where i can print the report filter on my report
for ex : i run my report after entering PO no : AO/PO/01234 so how can i get to print "PO no : AO/PO/01234 " on my report.
if i do not enter Po no report will run with all PO , in that case NO PO no should be printed on report.
It is possible, switch to parameters node of your report in Visual studio and set the visibility property to “Visible” for the required parameter.
You can also specify expression for parameter, if you want to Show or hide based on an expression.
Thanks Raghav but how do i get to print it on my final report
You can take it from Expressions in SSRS.
Select from Parameters the required parameter and show it on the report.
simply goto that query which you are using for this report , goto purchtable datasource add the field purchid to the filter in that datasource and run the report, it will open the dialog and u can pass the purchid