2 column report with footer

[GShen]

Hi,
I have a 2 column subreport which prints across and down. There is a grouping on the report which I need a total for.
If there is only 1 item on the report it prints to the right and it looks sort of stupid. I added a null record in my stored procedure for each grouping break. This null record always prints to the right and my 1st real record now prints under my Header grouping. The next problem is I have a footer total for this grouping. If there is only 1 record it prints the total on the right side. I ALWAYS want it to print on the left side. The only time it prints on the left is if the last detail record printed in column 2 (eg. the right).

Is there something in on format or on print that I can use which will always print these totals in column 1?

If I confused anyone please reply back.

THANKS

Remember when... everything worked and there was a reason for it?

 

[GShen]

Found my own answer. Posting here in case someone has the same problem. I performed AFTER SECTION in the new column/row footer. Everything printed perfectly.

Thanks anyway everyone.

Remember when... everything worked and there was a reason for it?

 

[dawnd3]

Hi there, I am having the same issue. Can you elaborate what you mean by "performed AFTER SECTION in the new column/row footer"? I think this might solve my issue, except that I am going down and then across 4 columns and want something in the report footer to show up after the last entry. However, it is showing up on the next page even though there are still blank columns on the previous page.

Thanks a bunch,

Dawn

http://www.calliopeconsulting.net

 

[GShen]

Hi,
My problem was with a sub report. A report does not have these issues. Do you have the footer skipping to the next page? Do you have any breaks on the report or is it just detail and you want a total at the end?

Remember when... everything worked and there was a reason for it?

 

[dawnd3]

I just have stuff in the detail section, no breaks or totals. Just some text they want at the end of the report. I don't have the footer skipping to the next page on purpose, but not sure if there is a property that I can check for that. I checked all the report footer properties and couldn't find anything that seemed like it was causing the problem.

Thank you for your reply. Let me know if you think of anything.

Dawn

http://www.calliopeconsulting.net