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

How to Pass a value from one report to other

Post Author: fusion

CA Forum: Crystal Reports

I have a requirement to create crystal reports where some fields gets it values from other report ( similar to referencing to another spreadsheet in Excel). How can i do this?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 06:25 PM

    Post Author: fusion

    CA Forum: Crystal Reports

    Is passing parameter the only way to do that? The user does not want any parameters.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 06:32 PM

    Post Author: kcheeb

    CA Forum: Crystal Reports

    Is one report a subreport of the other? If so, you can pass the values from the 'main' report to the subreport and reference them in the subreport, without user intervention.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 06:45 PM

    Post Author: fusion

    CA Forum: Crystal Reports

    I need the value from the subreport in the main report. How can I do referencing?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 06:55 PM

    Post Author: kcheeb

    CA Forum: Crystal Reports

    If the subreport consists of only the value you're interested in, you could place the subreport as a 'field' in the section you want on the 'main' report.

    If that's not the case, you have more values on the subreport. You could write another subreport that matches sql-wise the first subreport, but only has the value you want on the main report. Then place the second subreport on your main report where you want i t to show up.

    Other than that, you've tapped my knowledge of referencing values on the subreport in the main report.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 07:23 PM

    Post Author: fusion

    CA Forum: Crystal Reports

    Thank you for your effort to help me solve this problem. I have calculated fileds in my subreport. I need to show those fileds in my main report. I must be able to do calculation on the main report using that field. Inserting the subreport as a filed will not help me do calcuation (correct me if I am wrong).I found that I have the sureport using values from another report. What would be the best approach to solve this?

    Thanks again.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 07:34 PM

    Post Author: kcheeb

    CA Forum: Crystal Reports

    I've never accessed values from the subreport from the main report before. I have set up subreports that looked like they were part of the main report's detail or group rows. Ie. a one to one relationship with the section it is embedded in.

    Sorry I can't offer more.

    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.