Skip to Content

Is showing both records in the page header possible?

I have a report that is used to return multiple variations of a combination of records. I could use the report to find the total for both product A and product B or both product C and product D and so on. The problem I'm having is that I want the page header to reflect both groups that are being displayed. I tried putting that parameter in the page header but it only shows one record or the other even if it's a page showing the totals of both records.

So what I'm getting is:

Page 1 Header: Product A

Page 1: Product A

Page 2 Header: Product B

Page 2: Product B

Page 3 Header: Product B

Page 3: Product A and B totals

What I want is the page header to be:

Page 1 Header: Product A + Product B

Page 1: Product A

Page 2 Header: Product A + Product B

Page 2: Product B

Page 3 Header: Product A + Product B

Page 3: Product A and B totals

Is there a way to do this or do I need to create and individual report for each possible combination of products?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 09, 2015 at 03:12 PM

    Hi Kurt,

    If it's just two products you could use:

    Minimum({Product}) & ' + ' & Maximum({Product})

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

    • Yes, using a subreport!

      You'd insert a subreport pointing to the table that has the salesperson's name and ID.

      You'd then link the prompt from the Main report to the Subreport's ID field. Inside the Subreport, drag and drop the Salesperson name field on the Report header and suppress all other sections.

      -Abhilash

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.