Yes Syn, I actually have two subreports, each of which is in its own Report Footer section---they should only print AFTER all the detail records of the main report have printed. I put the 'suppressit' code where your post indicated - first = false in the Report Header, then = true in a section...
Thanks, Syn. You're so helpful to everyone with this stuff, maybe you should write a book. The Crystal books I have are all either way too simple ('here's how to run the Crystal wizards' type stuff) or way too esoteric ('here's how to embed a field in your underlaid chart and make its color...
I'm at wit's end with this...what 'suppress' formula should I enter in my page header so that the page header WILL print on any page where a detail record appears, but WILL NOT print on any pages that come after the final record in the detail section has printed? I don't want the page header...
Solved my own problem - I selected the "details" section, checked the conditional formatting box for New Page After and for the formula, I entered this:
Next ({rep# field}) <> {rep# field}
Sometimes it's the most obvious solutions that elude me while I'm looking around for something...
There are no "groups" in my report. All the relevant data is in the "details" section of the report. The data is coming in from a .csv flat file, in the same order as it is to appear in the report---this is necessary because the sorting requirements are unorthodox. The...
In the source data for my report, records are grouped, i.e. all sales for sales rep #1 appear as individual rows, then all sales for rep #2, then rep #3, etc. The number of rows per rep will vary each time the report is run, so there could be 5pp of sales for rep #1, one page for rep #2, etc...
If your report doesn't always get its data from the same source, I think you'd have to use an Active Data source when you first set up the report and then point to the desired data in your code.
I recently finished an app that does this. Users of a certain program do a data dump out of that...
I've written a very small exe in VB 6 that opens a Crystal Report, exports the report to .pdf format and then saves it to a disk file. This executable is intended to be launched, run and closed from within another program, so in the production environment the only "user" of the...
Synapse - thanks for your reply. When you say you suspect it's a problem with unregistered DLLs, do you mean unregistered on the Crystal Server machine? I would think that unregistered DLLs on the Crystal Server machine would cause the .exe to fail no matter where I launch it from, but that's...
I've written a tiny VB6 standard .exe that calls a Crystal Reports version 8.5 report, exports it to .pdf format and saves it to a disk file. The .exe runs on the Crystal Server machine, there is no client-side code or client-side installation. When I launch it from a DOS prompt on my own, Win...
I solved my own problem with a workaround - I copied the page header from my subreport into a second page header on my main report and then used conditional formatting to control printing so the second page header would only print on pages where the subreport is printing.
The page header I've set up in my subreport only prints once, at the start of the subreport. It doesn't show up again after page breaks. How can I fix this so the page header of the subreport will repeat after each page break? Thanks in advance.
I solved my problem; I imported my .csv file into MS Access 2000, then exported it back out to .csv. Using the newly exported .csv, everything ran fine. Weird. The only difference I could see between the new export and my original .csv file was that the new export surrounded every field value...
Maybe this will help...here's an excerpt from my source data. If I delete the last row in this excerpt, the report runs fine and everything comes into the report as a string. But if I include the last row, any column that has more numbers than letters in it is interpreted as Number and text...
Thanks Kai, but it's not working. I used the word "string" to seed my first row, but it doesn't seem to make any difference. When I run the report without filtering out the seed row, nothing prints in columns that have predominantly numeric data, even in the seed row. Any other ideas?
At runtime, fields I have defined as type String in my .ttx file are being interpreted as type Number when the .csv source data file is opened and passed to Crystal. In the report designer, all the fields for my report are listed as type String, which is correct. But when I run the report, it...
Here's my VB6 code for passing data from .csv text files to a Crystal 8.5 report that also contains a subreport:
Private Sub Form_Load()
'*************************************************************
'PARSE THE COMMAND-LINE EXECUTABLE...
Even though I've defined ALL source data field types as String in my .ttx file, for some reason my report is treating any numeric data it finds in my source data file as a Number data type. This is a problem because where I want the report to print -001 for example, it's printing -1. Also...
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.