Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Passing date range formula from main report to sub report

Passing date range formula from main report to sub report

Passing date range formula from main report to sub report


I'm fairly new to CR. Ive been working on CR that has five sub reports. The program I use to run the report in (Enterprise Asset Management/Lucity) breaks the report when trying to run it due to each sub report having a date range located inside it. It says I need to pass the formula field from the main report to the sub reports and the sub reports can not have parameters. Could anyone help accomplish this? I've tried on my own with no luck. Ive included a current test copy of my report. Thank you for your time!

Replies continue below

Recommended for you

RE: Passing date range formula from main report to sub report

So why can't the sub-reports have parameters? Normally I set up date parameters the same as what is in the main report. Then link the parameters. I tried upload pictures, but it did not work. I would show you the modified report, but you are working on an older version of Crystal than I am. FYI: I work for the County of Tulare in the Central Valley.

RE: Passing date range formula from main report to sub report

You should set up Parameters {?Start Date} and {?End Date} parameters in each subreport and ditch the date range parameter. Be sure to change your selection formula within the subreports to use the start and end date parameters and remove the date range parameter BEFORE you try to do the linking. Then in the main report, go to edit subreport links and select the subreport and then move {?Start Date} to the right and in the bottom left of the screen, use the drop down to select {?Start Date} instead of the default {?pm-?Start Date}. Repeat for the end date. Repeat all for each subreport. You will then get one start date prompt and one end date prompt for the report as a whole. Note that all parameters must be of the same type.

I didn't look carefully to see why you needed to use all these subreports vs one report.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close