Exporting to TXT format removes data shown in preview tab 2

[mattlscc]

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 transactions have a single character of "^" which displays in the preview, but not in the text export. If I add a space character after the "^" character then it will display both the "^" and the space character in the text export, but I would prefer no space after the "^".

Please see attachment for screen shots of the preview tab and the resulting text export as well as a screen shot of the sub report and parent report.

Any help in resolving this issue is greatly appreciated.

Thanks,
Matt

 

[Madawc]

In Crystal 10, I had a similar problem. Increasing the 'Characters Per Inch' improved the outcome.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[mattlscc]

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 a size of 9. Currently, I have all the fields on the sub report set to Courier New size 10 and from the parent report I have the sub reports font set to Courier New size 10 as well.

Any further ideas on how to resolve my problem? Is this just a bug in Crystal Reports?

 

[Madawc]

Have you got the latest patches? I was told this would fix the problem for Crystal 10, but we're upgrading soon anyway so we live with the problem.

Can anyone else help?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IanWaterman]

Have you tried something other than ^, in the back of my mind this is a control key for something. If it is this may be causing the problem you are experiencing.

Ian

 

[mattlscc]

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 is, if I export to TXT directly from the sub report (instead of from the parent report) then the "^" character shows up on the lines correctly.

Again, note that it always shows up correctly in the preview tab, it is when exporting to TXT that I start missing data.

 

[mattlscc]

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 TXT export from the parent report, but it will display if I export directly from the sub report. Any ideas on this one are greatly appreciated. Thanks!

 

[CR85user]

Anything conditional suppresion based on: whileprintingrecords?

 

[mattlscc]

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 IsNull({Financials.FIN_TXN_ID});
'';

But, even if I get rid of the suppression rule on that section, I have the same problem. So I don't that is the cause. Any other ideas? There is no suppression on the field itself and the field is marked as can grow.

 

[mattlscc]

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 sub report show up when running from the parent report. Thanks, Matt

 

[Madawc]

That's a useful work-round to know. Worth a star.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10