URGENT - NEED BY 3PM - Conditional Page Headings

[waikeana]

**** PLEASE HELP -- I NEED THIS BY 3:00PM****

I have created 1 report with 2 subreports. This report displays YTD Totals, MTD Totals and QTD Totals.

Problem: I have one column heading that I need to be changed depending on which view the customer is trying to get -- if they are viewing the MTD Totals, I want them to see the label MTD - but if they are viewing YTD Totals - I want that to be displayed.

I do not want to create a parameter that asked whether the customer wants MTD,YTD or QTD --- I want to automatically provide them all views -- but I am simply unable to change the page heading for the subreports.

 

[synapsevampire]

Base the column heading on a formula, and just before each subreport executes, and in the main report, change the value:

-k

 

[Reebo99]

I've just read you previous posts to get a bit more information.....

Have you tried right clicking the sub-report, choosing edit sub report, then simply changing the headings? or adding text boxes for you headings?

Reebo
Scotland (Sunny with a Smile)

 

[Reebo99]

I'm re-reading your posts again, and I'm confused. Do you have 1 main report and 2 sub-reports, or do you have 1 main report and 1 sub-report, with the sub-report being run twice based on the group it's in?

If you have 1 main report and 2 sub-reports, these sub-reports are independent and you can edit the headings using my post above.

If it's 1 Main report and 1 Sub-Report, which is being run based on the Sub-Report link, you can create all the headings you would need in the sub-report then conditionally suppress the unwanted ones based on the sub-report link value.

Reebo
Scotland (Sunny with a Smile)

 

[waikeana]

hOW DO YOU CREATE HEADINGS IN A SUBREPORT?

 

[Reebo99]

right click on the sub-report, edit subreport, you should the goto a design window for the sub-report.

Choose insert, text object, place the object in the report header and type in the heading name.

PLEASE NOTE. This option is only if you have a DIFFERENT sub-report for each of your displays....

Reebo
Scotland (Sunny with a Smile)

 

[waikeana]

Reebo99 -- I did what you said and it works fine, for the first page, but how do I get it to repeat on subsequent pages? I am sorry to be so dumb, but I am really in a crunch. Any further help from anyone would be appreciated

 

[lbass]

If you have subreports that run for more than one page and you want a different title for each, you can insert a fake group that contains all records, e.g.:

if {ID} in 0 to 10000 then "all records" else ""

Place the subreport title in this group header section. Then go to report->change group expert and check "Repeat Group Header on Each Page." That should give you a title on each page of the subreport.

-LB