Link to home
Start Free TrialLog in
Avatar of Rodger Dill Jr
Rodger Dill JrFlag for United States of America

asked on

SSRS UI Question

Good Evening All - I am still learning SSRS and wanted to know how I can setup an page so the users can see all the reports they can request?  In the past I would create a form in Access with check boxes for my different reports and have some text boxes, combo boxes, and list boxes for variables to pass along to my report,  I would like to have something like that in SSRS.  Can i do this?  Or do I just create a web page that has all of my reports and a link to the report and then the users just file out the variables at the top of the page.  I would like to customize it more than this.  I do not like that I cannot format or show the control like I would like the to appear.  Seems like a step back.

TIA,
Rodger
Avatar of Arifhusen Ansari
Arifhusen Ansari
Flag of India image

May be i don't know exactly what you need.

What i have understood is you need to create something like , Where you can list all the reports and when user click on that you can simply open that.

If this is true. What you can do is, you can build one master ssrs reports ,where you can list all the reports with there accurate name.

You can store this detail in table in sql server and than display that on SSRS table. or you can get the details by using SSRS catelog table.


e.g.

ID       ReportName               ExactName
1         SalesByYear                SalesByYear.rdl
2         SalesByCustomer       SalesByCustomer.rdl

This information can be in table.  Now this can be bound to table in master ssrs report you can show only "Report Name" column there.

Now on the Action Property of Textbox where you have put "ReportName" in table. You can select "Go To report " option, go to expression property set is like "=Fields!ExactName.value" .

So run time it will pass the Exact Name for that report available and when user click on that it will be directed to that report. User can provide the appropriate parameters values. SSRS is not interactive so you can not provide the check box interaction or others.

Hope it will help.
Avatar of Rodger Dill Jr

ASKER

I think we are both talking about the same thing.  Here is what I would like to create see attached image.  the user would fill all of that out.  and then click on Run to execute the report.  The two checkboxes at the top would be all the different reports they might run.  It would look to see if it is checked and if it is it would run the report and pull in the parameters I have on the form such as date of Department.  Or the report only might pull the date range.  

Does that clear it up?
FilterExample.jpg
it's not possible to create User Interface in ssrs report.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.