473,324 Members | 2,531 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

To get Page Total in Report developing in VB6.0

3
Dear All,
I want to get total on each and every page containg data. so could you help me how can i get this.
i am using data report.
bye
see u
raj
Sep 11 '06 #1
4 4415
Assyst
4
Isnt there a option called Page total ? Done a long back so couldnt exactly say . Do you want to get like

Page 1 of 2

Means you have to put the pagenumber field first and embed the of text and put the Page total text.

Please Revert
Sep 12 '06 #2
ridp
3
Isnt there a option called Page total ? Done a long back so couldnt exactly say . Do you want to get like

Page 1 of 2

Means you have to put the pagenumber field first and embed the of text and put the Page total text.

Please Revert
dear fren
i want to get calculate a field total amount in every page. not page number.. so pls try to help
bye
Sep 12 '06 #3
If you use Microsoft Data Reports, there is an option that allows you to autmatically drop and drag a field which contains either page totals/ or the current page being displayed.

1, When in design time at report view, right click and select which field you would like to add to the page, ex CURRENT PAGE OR TOTAL PAGES or BOTH

2, Alternatively you can also add this statement to the end of a data caption %p this shows the current page or %P This shows the how many pages are in the report.
Sep 13 '06 #4
Killer42
8,435 Expert 8TB
What ridp is after is not the number of pages, but a per-page total (perhaps subtotal would be a better term) for a field.
May 11 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Andy V | last post by:
Hi. I've got a multi page report of my monthly purchases. I'd like a running total (month to date) at the end of each page and to have that total at the top of the following page. So far all I can...
2
by: L Mehl | last post by:
Different users of the app will want or not want to see report footer ( appears as a separate page). I can make the section invisible with a DLookup of a Y or N value from a 'parameters' table ...
2
by: Louis1 | last post by:
I am just going crazy. I have a report that requires page totals. I got the report working, except that my page has ELEVEN records (ok), but the page total includes data on the TWELFTH record....
1
by: kaosyeti | last post by:
hey... i have a report that groups on salespeople. the report footer is a three part summary of the store's total data with 2 different departments for parts 1 and 2 and a store total for part 3. ...
0
by: CaptainDahlin | last post by:
Access 2003 Report rptWhiteMailDeposit I have found the "four lines of code" solution to adding sums to page footers and it is working...mostly. (if report is only one page long it doesn't...
2
by: CaptainDahlin | last post by:
I know the basics about access reports and putting page totals in the page footers. What I can't figure out is along with the current page total to display the previous page total: At the bottom...
3
by: joelpollock | last post by:
I'm having trouble continuously page numbering a large report in MS Access. The report is made up of three separate Access reports which I join together at the end. In the past I have opened the...
2
by: BerkshireGuy | last post by:
I have a report that is grouped based on Month / Year. Then for each Month / Year, I have a summary for each agency of their sales. For each group, in the group footer, I total all the agencies...
0
by: Josetta | last post by:
Here is something really bizarre that is happening...let me see if I can describe it. I have a report which has two locations on it. Primary Location and Secondary Location. I have both...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.