April 23, 2015 at 1:00 pm
Hello,
I am new to SSRS and SQL. I am attempting to provide a dynamic report on our intranet - sharepoint using SSRS.
I need to read a table -
CREATE TABLE [dbo].[Messages](
[PLCDate] [varchar](20) NOT NULL,
[Plant] [int] NOT NULL,
[Program] [int] NOT NULL,
[Line] [int] NOT NULL,
[Zone] [int] NOT NULL,
[Station] [int] NOT NULL,
[BadgeID] [int] NOT NULL,
[Message] [varchar](72) NOT NULL,
[Alarm] [int] NOT NULL,
[Archive] [int] NULL
) ON [PRIMARY]
and display a report based on users choice of selection -
Either date, Plant, Program, Line, Zone, Station, BadgeID, Message.
Sample rows in table are -
PLCDate PlantProgramLineZoneStationBadgeIDMessage
04/23/2015 09:58:50101309 859 9999 Test 1
04/23/2015 09:58:41091207 869 9999 Test 7
04/23/2015 09:58:39091204 869 9999 Test 6
04/23/2015 09:58:37081204 869 9999 Test 5
04/23/2015 09:58:35070611 869 9999 Test 4
04/23/2015 09:58:33110307 869 9999 Test 3
04/23/2015 09:58:30121303 869 9999 Test 2
04/23/2015 09:58:29011305 869 9999 Test 1
04/23/2015 09:58:22100104 869 9999 Test 2
Can anyone help me ?
Thanks,
Mohit.
April 27, 2015 at 9:43 pm
What are you trying to do? Filter the report so they only see the records they want? That's pretty easy.
Or are you trying to make the fields in your report dynamic?
April 27, 2015 at 10:50 pm
IN SSRS report, parameter enable users to specify values to customize the data in a report. For example, provide two parameters for the start date and end date for sales data.
So in your scenario, you can add date, Plant, Program, Line, Zone, Station, BadgeID, Message parameters to your report. Then end user can specify values to customize the data in a report by using those parameters. Please refer to the links below to see the details.
https://technet.microsoft.com/en-us/library/aa337432%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply