Have you validated the database query that gets generated for the specific parameters to confirm that data should come back... and then also validate that no record selection formulas were present to block data?
Thanks,
Matt
On our system we always have ~ 95 jobs listed under the "Waiting:" section of Current Jobs in the system metrics.
Any idea what these jobs are? Can someone provide a query builder query that will return these jobs?
thread73-1259995
I'm having almost the same issue as above mentioned thread.
(except it is not from home through a VPN, it is directly on my laptop at work... and I don't seem to have the 5-6 times and then it works...keep getting the pop-up box.. also on Lotus Notes 7)
Try to open Notes and...
I already had the "Repeat Group Header on New Page" option checked... that is the weird part... seems like a bug in Crystal Reports to me.
I also already had both the header and footer of groups 1, 2, and 3 suppressed... those groups do not display anything, just there for sorting purposes...
Could you give a quick layout of what your report is like, as far as header, groups, number of detail rows?
Could it have something to do with "select distinct" option? Are you running with the same parameters / filters from BO?
I apologize in advance if this is a repeat topic, but I could not find it anywhere using the Keyword Search...
I am using Crystal Reports Version 11.5.8.939
I have a report with six groups... the basic layout idea is show below...
RH
PH
G1_HEADER
G2_HEADER
G3_HEADER...
Well, I never could figure this out... turns out my import will work just fine if I have "^ " (note the space character next to the "^" character). And by adding the extra space it will always show up. There must be a bug of some sorts that doesn't allow a single character on one line from a...
No, I do have a suppression on that line which is this:
WhilePrintingRecords;
Shared booleanVar recordsFound;
not (recordsFound);
The recordsFound shared variable gets set in the sub reports Report Header section.
WhilePrintingRecords;
Shared booleanVar recordsFound;
recordsFound := not...
Well, I figured out the missing data of the first transaction... I had a shared variable that was to determine if no data came back which wasn't getting evaluated in time for the first group.
Anyhow, I am still at a loss why a single character on a line in a sub report will not display in the...
I have some patches, not sure if they are the latest or not... my version is 11.5.8.939
Yes, I have tried other characters besides "^", and it does not seem to matter... even when using "A" it still does not show when exporting from the parent report. Another possible clue to what is going on...
I have tried many characters per inch values to no avail. I have tried all the recommended values from 8-16 and even some outside that range. I'm not sure if this matters or not, but I have the font set to Courier New with a size of 10. I have also tried changing the font to Courier New with...
Crystal Reports Version: 11.5.8.939
Main report contains sub report.
There are two cases of missing data.
Problem one, the first transaction is missing except for the last line which is supposed to be a "^".
Which leads me to the second problem... all the lines that are separating the...
Hey thanks...this was a great help!
Here is my final solution... since yours only covered one split of pages I needed to modify it a bit to handle any number of page splits...
created formula {@count}:
whilereadingrecords;
global numbervar cnt := cnt + 2;
numbervar output;
if cnt mod 998 = 0...
Is there a way to do this same thing if you don't have a group to pass into the sum function? So in my report, every 999 detail rows I split into a second page. So I might loop over 1,500 records and get 1,500 detail rows... between 999 and 1000 I have to put a footer and then a header for the...
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.