August 22, 2013 at 4:07 am
Hi Folks,
I need to validate few parameters which get passed from any third party Portal to SSRS.
Basically The parameter values should be stored in a table in SQL server.
If that is the valid combination of parameters from portal then report should be executed and it displays the data to the end user else it will throw invalid request.
Can any one of give me some inputs on this functionality pl?
Thanks
August 22, 2013 at 4:36 am
Kindly let me know if any one of you need some additional information on this to understand?
August 23, 2013 at 5:30 am
I would pass the parameters and use the no data row message property to display a no data for passed parameter message.
August 23, 2013 at 6:29 am
Hi Scott,
Thanks for your reply.
I will explain again my query to you.
We have one report in portal --- Report 1.
When you clicked this report ----variable screen will appear - variables are Year Range.
in the back end when you clicked on that report and variable screen appear...some details will be stored backed on the database....
Now when you enter the report Year and executed the report..... ---- Here i Need to pass the details which are stored back in the database when you clicked on this report and also year parameters as well.
So my question how can i pass the parameters which are generated when you clicked on the report to the final output of the query.- Because my report will based on some sql query when you executed the report my SQL query also need to do some validation of the portal parameters(i.e. generation of information when you initially clicked on the report..i.e.stored in the same database in some table)
August 23, 2013 at 8:12 am
SSRS is not an input tool, but a reporting too...without some backend coding, I am not sure what you are intending, if I understand, is possible.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply