Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple reports based on parameter fields

Status
Not open for further replies.

cashewsky

Technical User
Aug 22, 2006
5
US
I am trying to build a report that takes two date ranges from the user and builds two reports that I can show next to one another (this year's data and last year's data). I believe that my question is similar in nature to this one...but the solution does not explain:


Currently my "record selection" looks like this:

{groups.pargrp} = {?Parent Group} and
{claimlin.pidate} in {?Beginning Paid Date} to {?Ending Paid Date}

I have added the new parameter fields but do not understand how to pull these two ranges separately.

Using CR9.
 
Hi,
In order to show 2 reports ( sortof), one must be a subreport linked to the main report..
If the main report has the Current year's data ( based on the dates entered in the parameters), the link the subreport using those Dates minus 1 year ( use a formula in the Main report and link it to the date field in the sub- claimln.pidate maybe)
and place the data from it it next to the main report's data.






[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
I understand what you mean and I see how I can manipulate the user input date with a formula so that it can be used by the subreport. That is a perfect solution! My only question is how do I determine whether I am using a linked or an unlinked subreport? Is it linked because I am wanting to "borrow" this formula from the main report?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top