Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  HOME    TRACKER    Visual Basic

Page Sum For Data Report

I am using Datareport to generate reports using SQLServer as backend. I need to insert Page-sum for each page (or running total) at page footer of the report. How can I do it?

Susant Maharana

View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
URGENT: Data Report (Page Header On Each Page)

I am using Data Report (why?!!) to print a bill. It contains the company name and other information such as date and total amount etc.

I am doing this by coding only. NO DATA ENVIRONMENT (!).

I have put a lable on the Page header and I am displaying the company name in that lable. It prints perfactly on the first page of the bill. But it does not appear on the second page of the bill. Instead it displays the remaining items of the bill from the beginning.

I want to print company name on each page of the bill. this is shown in the image.

Is there a way to get the out put like this?

Please help me. Its urgent.

Thank a ton in advance.

How To Get Page Wise Report Using VB 6.0 Data Report
i need to get pagewise total in the report. Currently i am getting group wise help me ....

reply to

Different First Page On Data Report
Hello Everyone,

I'm creating a Data Report dynamically through Visual Basic and I want to display some labels and fields on the first page of the report, but not on all the others. Does anybody know how I could do this? I was thinking I can make the fields visible in the first page and make them invisible in the rest, but I don't know how I would do that. If I could add code the the next page button on the Data Report itself, it would be simple but I don't think I can.

Well any help would be greatly appreciated. Thanks.

One Page Data Report

I'm making 1 page data report.
Actually, any DB doesn't have to be connected this report.
This report has 1page including 8 images.
I used 8 RptImage controls on Detail(Section1).
And I seet Data Source and Data Member.(If I don't set this, error occurs)
If I run program, 16 page is made.
Why this happens?
Could anybody help me?

Placing Text Fields In The Report Header Or Page Header Sections Of A Data Report
Is it possible to place text fields in the Report or Page Header of a Visual Basic 6 Data Report?

Data Report Page Headers
Does anyone know how to turn a group header into a page header. I have many databound text boxes in my group header, so I can't just move it into the page header section, but I need the group header to appear at the top every page. This is very frustrating.

Data Report Page Break

I have to generate the report in visual basic. I am using data report. Now i am struck with some problem.

For example lets say i have 100 records after running the query. Now i want to display only 10 records per page in the data reports one page.

Pls help.


How Can I Print Per Page To Data Report From VB
Hello to everyone,

What code should i put to print per page from MS Access data report to Visual Basic.

for example page 1 only. and not the whole pages.

Please advise if anyone know how to do this.


Adding New Page In Data Report
Hi, I am using data report with ms access. I filled detail section with ADO Shape command. Now at the end of the report I want to add another page for which data is coming from another resource (database/textfile).

Can anyone suggest how to do this?

Data Report: Set Page To Landscape
I'm designing a report using Data Report.
The problem is that the report is widther than the page, so I need to change the page orientation to landscape.
I have been searching the forum and I found that this can only be done if you have service pack 5. Is this right?.
I also tryed DataReport1.Orientation = rptOrientLandscape but the Orientation property doesn't exists.

How can i change the page orientation?

Page Totals In A Data Report....
How do you display page totals in a VB data report?

Data Report, Page Total Possible?
I know that the function control can't be placed on the page footer section. Just wondering if there's a way around this restriction so I can get the total for the page.

e.g. A long list of values, no grouping, and for every page the total for that page only. At the end of the report would be the grand total = sum of all OR sum of page totals.

I hope it's possible. Thanks for your time.

How Can I Set Page Breaks Within My Data Report?
I have created a DataReport within my VB6 application, but to make it look proper, I need to set page breaks within it at certain points..

I noticed that it will allow you to force page breaks after sections, but all my data is found within the Detail Section???

Can someone please assist me with this portion?

Thank you.

Data Report - Page Breaks Possible?
> is it possible to add page breaks in Data Report.
> I am using it to generate invoices
> and I want every invoice to appear on a new page

Data Report - Page Breaks
is it possible to add page breaks in Data Report.

I am using it to generate invoices

and I want every invoice to appear on a new page

Data Report Not Confined In One Page..Help
Hi all,

I am working with data reports and the problem that i face is , the reports exceeds one page.Please suggest how can i see the remaining contents of the report in the other page.

I will be eagerly awaiting your help and suggestions.

thanking you in anticipation.


Data Report Page Setting
Please tell me how can i change the default page settings in a data report

Data Report Page Size
May I know how to change the page size of a data report? I would like to make a report of A3 size. Thanks


Data Report Page Number
Can I put current page Number in Data Report starting with any other Number except 1 is default ? How ? I want to put Page number starting with 59 or 37,93 what ever. and then it should continew.

K the Killer

Edited by - kcv80 on 3/15/2004 10:21:48 AM

Data Report: One Record Per Page
I want one record at one page (one record can be easily mangae on one page)
I am able to acheive it by seeting the
Force page break = rptPageBreakAfter
of the Groupfooter (section 7) (there is only one group)

But problem is if quey returns 10 records it generate report of 11 pages

My aim is that if query returns 10 records then report should have 10 pages
How is it possible?

Edited by - haahoou on 2/8/2004 8:45:43 PM

Page Orientation In Data Report
my datareport is in landscape mode. when i give command then if the page setting of the default printer is set to landscape then datareport opens fine but when the printer setting is in portrait mode then on opening datareport it gives error message that report width is more than the page width. So i have to keep my printers setting fixed to landscape mode which affects other applications. I want that irrespective of the printer setting datareport should open without error and on giving print command i should select the page orientation mode.
Please help.

Page Total In A Data Report
Hi! Deke, Could you please suggest a method to calculate Page Total in a Data Report
Thanks in Advance for any suggestions

Page Number In Data Report
Hi there,

I want to put as page footer the current page number of the data report (e.g. Page 3 of 15) and I don't know how to do it.



DAta Report Page Count
Hi Friends,

How to return the total number of pages in Data Report.

I want to display at the page footer "Page number(%p) of NumberofPages ". How to do this



Data Report-Page Numbers

I m trying to Display reports of using "sql query",everything is working fine, but is there any way to display the page numbers in the Page Footer in the format of

"Page 1 of 5" if so, plz let me know,

I m using VB 6.0, Datareports, MS Access 2000. and jet 4.0 provider.

Thanks in abvance.


Page Columns In Data It Possible??
Can i put page columns (not table columns) in a data report???

the attached file is the format i wish to do in data reports

Thanks in advance!


How To Set The Page Height In Data Report
Hi Guys,

I wish to set the page height in data report. Datareport1.height property doesnt' reflect in printing.

I wish to get the printout from the data report with user defined page size (custom size).

Any other option other than datareport to perform the job also welcome.

Please help me.


Parameters In Page Header Of Data Report

I have to pass some parameters do Data Report (of Visual Basic 6.0). I did. Further, I want the parameters to display along with the page header (or) report header.

For example, if I am sending two dates to the report and fetching the data between them. I want to display the report header or page header which reflecting that those data are between those two dates.

Like...XYZ REPORT FROM 10.JUN.2004 AND 16.JUN.2004

Expecting the solutions.


Urgent...Data Report Page Size

Data Report in VB 6.0 by default is set to print on an A4 size paper. I have a generated a larger report ( A3 size). But when I run the report it gives me an error that report width exceeds page size.

How to increase the size of the data report so that i can generate and print the required report.

If u have the answer plz reply asap.


Adding Page Numbers To Data Report
how do you do this? like you want to put the page number of the report on the footer so that it will increment depending on how many pages the report is?

Data Report Of Vb6 - Page Header Problem...
i have a report wherein some data in the page header section change everytime the value of a certain field changes...

the data is grouped by batch#....

if batch# field's value = 001
the header becomes = 'RECEIPTS REGISTER'
if the value = 002
the header becomes = 'INVENTORY SUMMARY'
... AND so on....

the batch# is in the details section...
the header is in the page header section....

then, after every changes in batch# field, there is a page break...

how will i manipulate it? i am using vb6's data report... anybody help me out? i really need it badly....

How To Dynamically Set Page Length In Data Report?
I need to set the page length dynamically in the data report. Any way to do it?

I wish to generate a invoice bill with food items. Based on the items the bill length varies. Thats why i need.


Any other ways to accomplish the above thing.

Advance thanks,

Is It Possible To Display One Record In One Page In Data Report
is it possible to display one record in one page in data report. im getting data from two tables. the main table and details table some times the data in the details page will be more and it will jump on to the next page. and below that the next record will display. is it possible to display the next record in the next page.

Change Page Orientation In Data Report
i have three to four data report in my project. i have to change orientation and size of paper for each report.
how can i do it at runtime.

i tried to use comm dialog control. but i don't know proper method.


I would like to know how to change the data report
setting in VB CODE.

My requirement is to print on 8 " , 10" , 4" i.e
stationary. I want the code in VB so that data report
can be printed on 8" (inch) or 10" (inch) stationary

Thanks in advance

View Data Report Page Fully
When we have to add data from data environment the data report page is not fully seen because the limit of length. How can we arrange the details of the data in groups after we drag table to report? Or how can we add tables one by one to the same report

Data Report Page Break Problem
I am using vb6 and use data report from vb6 to print my reports.

I have one report where i am printing assembly/part/properties where i have a table Assembly linked to a table Parts and a table Properties linked to parts.

i need to print an assembly where i need to print one part per page.....everything was working for the last year or so.
i noted that about a couple of weeks ago it does not force the page brake anymore.
if i try this same program on my computer at work it still works fine.

any ideas would be most appreciated.
i am lost....:(

How Display A Record By Page In Data Report?
hello everybody.
I am using vb6, I created a data report with data enviroment and the what i want to do, is to display a record by page. I mean in the first page the first record, in the second page the second record etc.
Does anyone know about this?

Thank you
very much.

How To Set Page Size And Printer In Data Report In VB

I want to know how I could set the page size and printer in VB appliaction. I am Printing DataReport in Vb and I want to set page size for the reports. Kindly give me details about the solution with example.

Thank you,


Printing Data Report In VB6 - Control End Of Page

Could someone help me with this : I am using a datareport on a supermarket app , to produce the final bill. Everything works fine , but the app always prints the full page , causing the printer to scroll forward on every bill. I did not succeed in any way to define the data report page size to be printed. Any solutions ?

Thanks Alot

(RESOLVED)Data Report Page Navigation
I am new to data report. My report generates 18 pages. I dont know how to go to next page as it will by default show only one page. Plz help me.

Edited by - Krupa Jetly on 8/29/2006 3:51:21 AM

SOLVED Data Report : How Can I See Remaining Page
lets say My query returns a record that cover more than one page but I can see only one page
How Can I see the remaining page.??

Edited by - haahoou on 1/28/2004 1:41:11 AM

One Of The Field As A Page Header Of Data Report
In order to avoid repetition of printing of a same information , I want to use that field as a page header of the data report. I tried to place that fields in page header section but I failed. Pls any one of u gurus out there help me.

Thanks Premlatha for helping me. I was badly stuck in this. B'cos my client was insisting to avoid duplicate printing. Thanks to u for helping me in fulfilling this requirement.

Can Data Report Print Two Column In One Page
Subject: Can Data report print two column data in one page

Category: ActiveX

Here I have a question. In Data report, Can I print data in two column like the following report
Page 1
Page 2
If Datareport , cannto do it, what about crystal report?

Best regard


Changing Page Width Using Data Report
I have the following code into a module.
Option Explicit

Private Const CCHDEVICENAME = 32
Private Const CCHFORMNAME = 32

Private Const PRINTER_ACCESS_USE = &H8

Private Const DM_MODIFY = 8
Private Const DM_COPY = 2
Private Const DM_ORIENTATION = &H1

Private Type DEVMODE
dmDeviceName As String * CCHDEVICENAME
dmSpecVersion As Integer
dmDriverVersion As Integer
dmSize As Integer
dmDriverExtra As Integer
dmFields As Long
dmOrientation As Integer
dmPaperSize As Integer
dmPaperLength As Integer
dmPaperWidth As Integer
dmScale As Integer
dmCopies As Integer
dmDefaultSource As Integer
dmPrintQuality As Integer
dmColor As Integer
dmDuplex As Integer
dmYResolution As Integer
dmTTOption As Integer
dmCollate As Integer
dmFormName As String * CCHFORMNAME
dmLogPixels As Integer
dmBitsPerPel As Long
dmPelsWidth As Long
dmPelsHeight As Long
dmDisplayFlags As Long
dmDisplayFrequency As Long
dmICMMethod As Long
dmICMIntent As Long
dmMediaType As Long
dmDitherType As Long
dmReserved1 As Long
dmReserved2 As Long
End Type

pDatatype As String
pDevMode As Long
DesiredAccess As Long
End Type

Private Declare Function OpenPrinter Lib "winspool.drv" Alias "OpenPrinterA" _
(ByVal pPrinterName As String, phPrinter As Long, pDefault As _
Private Declare Function SetPrinter Lib "winspool.drv" Alias "SetPrinterA" _
(ByVal hPrinter As Long, ByVal Level As Long, pPrinter As Any, ByVal Command _
As Long) As Long
Private Declare Function GetPrinter Lib "winspool.drv" Alias "GetPrinterA" _
(ByVal hPrinter As Long, ByVal Level As Long, pPrinter As Any, ByVal cbBuf As _
Long, pcbNeeded As Long) As Long
Private Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (hpvDest As _
Any, hpvSource As Any, ByVal cbCopy As Long)
Private Declare Function ClosePrinter Lib "winspool.drv" (ByValhPrinter As _
Long) As Long

Private Declare Function DocumentProperties Lib "winspool.drv" Alias _
"DocumentPropertiesA" (ByVal hwnd As Long, ByVal hPrinter As Long, ByVal _
pDeviceName As String, ByVal pDevModeOutput As Any, ByVal pDevModeInput As _
Any, ByVal fMode As Long) As Long

Public Sub SetOrientation(NewOrientation As Long)
On Error GoTo eh
Dim PrinterHandle As Long
Dim PrinterName As String
Dim lpDevMode As DEVMODE
Dim Result As Long
Dim Needed As Long
Dim pFullDevMode As Long
Dim pi2_buffer() As Long
PrinterName = Printer.DeviceName
If PrinterName = "" Then
Exit Sub
End If

pd.pDatatype = vbNullString
pd.pDevMode = 0&
pd.DesiredAccess = PRINTER_ALL_ACCESS

Result = OpenPrinter(PrinterName, PrinterHandle, pd)
Result = GetPrinter(PrinterHandle, 2, ByVal 0&, 0, Needed)
ReDim pi2_buffer((Needed 4))
Result = GetPrinter(PrinterHandle, 2, pi2_buffer(0), Needed, Needed)

pFullDevMode = pi2_buffer(7)

Call CopyMemory(lpDevMode, ByVal pFullDevMode, Len(lpDevMode))

lpDevMode.dmOrientation = NewOrientation
lpDevMode.dmFields = DM_ORIENTATION

Call CopyMemory(ByVal pFullDevMode, lpDevMode, Len(lpDevMode))

Result = DocumentProperties(0, PrinterHandle, PrinterName, ByVal _
pFullDevMode, ByVal pFullDevMode, DM_IN_BUFFER Or DM_OUT_BUFFER)

Result = SetPrinter(PrinterHandle, 2, pi2_buffer(0), 0&)

Call ClosePrinter(PrinterHandle)

Dim p As Printer
For Each p In Printers
If p.DeviceName = PrinterName Then
Set Printer = p
Exit For
End If
Next p
Printer.Orientation = lpDevMode.dmOrientation
Exit Sub

End Sub


How can I change this to work for a user who's printing to a Windows NT network printer. Thank's.

Changing Page Width Using Data Report
I have created a report using Microsoft's Data Report (Visual Basic 6). I want to make the report form landscape.

Thanks for any help

Changing Page Width Using Data Report
I have created a report using Microsoft's Data Report (Visual Basic 6), that is to be printed on 11 x 17 paper with a landscape orientation. However, every time I try to run the report I get a message that says the report width is larger then the paper width.

How do I change this at run time?

Thanks for any help

HELP: Print A Data Report With Specific Rows Per Page
Dear friends,

I have a SQL which outputs a couple of rows to my data report sheet. There is no problem to me to print them all on the pages but how can I limit the number of rows per page? Lets say, 12 rows per page, rather than just print to the end and then back to the top on next page again? Is there any extra SQL statement I need to add or I need to change some settings on the data report?


How Can I Print A Single Page In MS Access Data Report Using VB

Can anyone put a code that when i click the print command It will launch a printer so i can select what page no. should i print.
Because as of now i am having a proble all page are printing and i cannot stop it.

I use a data and i 'am using access for my database.


Copyright 2005-08, All rights reserved