Skip to Content
author's profile photo Former Member
Former Member

Record Selection in Main Report / Subreport Combinations

Post Author: Horizon57

CA Forum: General

I have a main report with a bunch of detail sections each containing multiple subreports. I am using an Access database with multiple tables. How do I control the record selection at the main report level so that individual record selection formulae do not need to be written for each subreport? I would like to use a dynamic pick list to prompt the user for 3 levels of record selection. I am not running Crystal Server, and do not have access to the Business Views features, unless there is a lite version included in CR XI.

Thanks for the help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 04:46 PM

    Post Author: V361

    CA Forum: General

    I have CR XI,

    right click the subreport, one of the options will be change subreport links, this should allow you to create a link in the subreport, to the main reports parameter, or field

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 04:55 PM

    Post Author: Don

    CA Forum: General

    Also, keep in mind that you only need a sub-report if your table joins are one to many records. If they are = joins then you don't need a sub-report if the tables are linked in Crystal correctly.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.