Show Label Vertically and Total Amount each Page 1

[Thuky]

Hi Everyone,

Normally, we show label horizontally. Is there a way to make the label rotate counter-clock 90 degree? I check yes for property Vertical, but it turns clockwise instead.

One more thing is there a way to sum amount on each page?

Thanks for any help.

 

[BSman]

To calculate totals I prefer to do the calculation manually. A simple version of this would be if your report had details, no grouping footers, but just a report footer and page footers and you wanted to print the total on each page of what was printed on that page and also print the grand total(s) for the report on the report footer. Here's how I do it, assuming one column with data in the details section of the report in the control txtValue:

In the VBA code for the report, define variables for use in the entire report. I'll call them dblValuePageTotal and dblValueReportTotal.

In the VBA code for the report header put the following:

dblValueReportTotal = 0

In the VBA code for the page header put the following:

dblValuePageTotal = 0

In the VBA code for the details section put this:

dblValueReportTotal = nz(dblValueReportTotal) + nz(me.txtValue)

dblValuePageTotal = nz(dblValuePageTotal) + nz(me.txtValue)


(I'm using the nz() function to insure that blanks are treated as 0.)

Somewhere in your page footer place a control to display the value of dblValuePageTotal.

Do the same thing with dblValueReportTotal in the footer of your report.

 

[Thuky]

Hi BSman, I forgot to tell you that it worked great. Thanks!!!