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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Please help on my SSRS project
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 08/15/2013 :  00:58:29  Show Profile  Reply with Quote
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!

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 08/16/2013 :  14:06:59  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000