Fixed Length on SubReport 1

[Barock21]

I need to create a fixed length flat file. Unfortunately, part of the information is from a subreport. I tested this and export it on a .csv file and the subreport information is not showing on the .csv file. Is there a way for me to get around this?

Thanks in advance.

 

[synapsevampire]

Maybe, but you need to take the time to post your software version, where thwe subreport is, and what the format of the subreport is.

A CSV file means that you have a single data source, not multiples, which is what subreports tend to provide.

You might consider returning the values from the subreport using shared variables and placing those in the main report to emulate a single datasource.

-k

 

[Barock21]

I currently am using crystal 8.5 but can use version 11 if need be. All the subreport has is just 1 line count of number of sales. I did the formula to make it fixed length text on the subreport. Can you please elaborate on how to return value from the subreport to the main report? This may be a way out. Thx.

 

[Barock21]

Here's the formula I did on the subreport:

NumberVar RequiredLength:= 9;
NumberVar CurrentLength:= Length (TOTEXT ({#BID Count}, "0000000000"));
IF RequiredLength < CurrentLength

THEN TOTEXT ({#BID Count}, "0000000000") [1 TO RequiredLength]

ELSE ReplicateString ("0",RequiredLength - CurrentLength) + TOTEXT ({#BID Count}, "0000000000")

 

[Madawc]

To pass data back from a subreport, use a shared variable. For a date, put a formula field in the subreport like

Shared dateVar 
V_Today := {LoadStatus.LastDLoad}

To access it in the main report, create another formula field with

Shared dateVar 
V_Today := V_Today

If it was a currency value, you'd do it differently, e.g.

whileprintingrecords;
shared currencyvar SumSaved;
SumSaved:={#TotSaved};
SumSaved

And to access it in the main report, create another formula field with

whileprintingrecords;
shared currencyvar SumSaved;
SumSaved

Note that the shared variable is only available in the section after the section which contains the subreport.

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