Thanks Madawc for those suggestions. I have been working with summary and running totals on test report. I still have a problem of figuring out how to get the exact output.
Eg
I have 3 fields CPNo, Qname and Calls. In my main report i would like to display Each Qname , the various CPNo's for...
I have got the following columns in my report
Callid, QNAME, Calls, Abandoned Calls. Now i have a page total as well as grand total at the end of the report. I want totals grouped by QNAME without disturbing the page total or the grand total.what should i do in Crystal Report to get this ...
No not the CRviewer. In the CRViewer a preview pane appears during run time,which practically has no use. I just want to suppress that pane. IS it possible to suppress that.
Longfellow
when i use the formulas
accum formula:
//accum ----------- Used in Details section
WhilePrintingRecords;
shared numbervar total := total + {table.numberfield};
shared numbervar Grandtotal := Grandtotal + {table.numberfield};
display formula:
//display ---------------- Used in Page...
I am using Crystal Reports Ver9, CRviewer91 and VB 6
Form2.CRViewer91.ReportSource = report is the method used to link to the report. When i call the report i don't want to see the preview pane in CRViewer
Is it possible
longfellow
Hi Ken
You said
"If you want BOTH a single page total and a cumulative page total you will need two variables. "
How do i use 2 variables or where do i use them can you explain?
Thank you
Longfellow
I Call Crytal report from VB. At runtime i dont want the preview pane to appear in the crystal Viewer. Is there anyway to disable this? Either setting properties or any other way? Can anyone tell me?
//display Last
OnLastRecord
Shared numbervar Grandtotal;
GrandTotal
When i used this formula while definig it i got an error "The remaining text does not appear to be part of the formula"
Whats wrong Can anyone help me?
I require a grand total as well as a page total. Yes i have done {table.numberfield} and select Insert - Summary?
What should i do to get a continuous page total
How do i get a grand total on the last page of my report after using the following formulas for page totals?
reset formula:
//reset
WhilePrintingRecords;
shared numbervar total := 0
accum formula:
//accum
WhilePrintingRecords;
shared numbervar total := total + {table.numberfield}...
hi
The following is my VB code written for a command button when i input the date in the text box and click the command button the report should get generated. I am not egtting any data in the report. There is data in the table in the database...
Versions VB 6 CR 9 and SQL Server 2000
I run a form in VB which will (execute a SQL procedure) and should then pass a date parameter to the crystal report which has to give the report for the day of the qname, caller id and the total calls. Can anyone very briefly tell me what I should do...
There is no other code on the form. I just have to pass the parameter from the form to Cr and generate the report. If i could do this with a single form then i will integrate this across several forms in the project. So if you can help me it will be of very great use
Thanking you in advance
Versions VB 6 CR 9 and SQL Server 2000
I run a form in VB which will pass a date parameter to the crystal report which has to give the report for the day of the qname, caller id and the total calls. I am sorry for asking again Can you very breifly tell ne what i should do in both VB as well...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.