Please help on my SSRS project

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Please help on my SSRS project

Author

Topic

maggie99
Starting Member

1 Post

Posted - 2013-08-15 : 00:58:29

I need to generate a drill-down tabular report with the following requirements:
Here're the columns to be included in the main report:
Batch Barcode
status of batch
Number of samples
Location shipped from
Location shipped to
Date the batch created
Date the batch received
shipping username
receiving username
In the above columns Batch Barcode should be drilled down with a hyper-link to a sub-report which includes the following columns:
Sample Barcode
sample status
Batch Barcode
Receiving Username

In the meantime, the report should provide the ability to query by the following inputs:
a. Batch Barcode
b. Sample Barcode
c. Date range (user specified start date and end date )

A.The report shall return an error message to the user if the range between the user entered start date and entered end date of shipping exceeds one year.
B. If the user set a start date and end date is not set the report shall display data from start date to one year after the start date.
C. If the user set a end date but not a start date the report shall display data from one year before the end date
D. If neither a start date nor a end date is specified the report shall display data starting one year before the date of querying.

It's straightforward to create a main report with a drill-down sub-report, however I'm kind of stuck at how to implement the query based on the three criteria (Batch code shown both in main report and sub-report, Sample barcode shown only in sub-report and the tough one will be the date range)

Thank you a whole bunch!
Maggie

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-16 : 14:06:59

you need to pass the barcode value from main report to subreport. for that you'll have a parameter added to subreport. The daterange validation can be done by adding a hidden parameter and using the expression inside

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources