April 14, 2009 at 11:08 am
I am new to SQL Server and am trying to create an Ad Hoc report in which all the data comes form one table. I need to create parameters from the one table for the end user to choose from to generate the report (can not allow end user to use Report Builder)
Example: Table 50
Incident, Mode, Class, Area, Jurisdiction, Year
the user needs to be able to pick any where from 'blank' to 'Select All' from each column to create individual reports. (Table 50 is derived from an even larger table) Say; Incident 'blank'; Mode A, B, F; Class 4; Area W, H, D; Jurisdiction 'Select All'; Year 05, 08.
The pieces and parts are easy enough to build, but if I create a report and have a parameter for year with choices such as "05, 06, 07, 08", if I pick '08' everything comes out '05':crazy::unsure:
What am I missing? Any help would be great!
April 14, 2009 at 11:30 am
I am kind of lost, what is front-end for the End user?
April 14, 2009 at 11:31 am
There is nothing like creating parameters to the view/table. Based on the input you need to have WHERE conditions.
April 14, 2009 at 11:54 am
The end user will access the Reporting Server with preset premissions. From their folder/report group/home page they will pick "Report A", it opens and then they pick form each parameter and then click "veiw report" And "wahla" they have a report. Everything thing will be predefined (fonts, color, layout, etc), except for the contents actual end report.
ProdieGH
(aka Karen)
April 14, 2009 at 12:14 pm
Ok, I am not sure if I am following you here. I am using a shared data source. This is based off a table that has something like 20 columns and I am using only 7 columns. Then I create a smaller datasets based on 5 of those columns (2 columns are for filtering only).
Example: dataset A (fname, lname, postion, division, years_of_service, hire_date)
dataset A:1 (position)
dataset A:2 (division)
dataset A:3 (hire_date)
so now I can choose a 'position', 'division', and 'hire_date'
so I should have a report that saids something like:
Joe Smith / Manager / Division A / March 08
Maggie Jones / Manager / Division A / March 08
Jason Grant / Manager / Division A / March 08
April 14, 2009 at 12:16 pm
And 'Thank You, Vijaya" for your help!!!!!
Karen
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply