SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

maggie99
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!
Maggie

visakh16
Very Important crosS Applying yaK Herder

India
52325 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
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.04 seconds. Powered By: Snitz Forums 2000