cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting data to an excel sheet

Former Member
0 Kudos

Hello,

I have a report abc.rpt which takes 3 input parameters, two are required fields and one is an optional field.

When I enter all three values and try to export report data to an excel sheet, it works fine. But when the optional field is left empty and I run the report, report data comes up fine, but the export feauter throws the following error:

Error in File C:\WINDOWS\TEMP\{F1CFE892-2C55-4B9B-AF85-D0922642163C}.rpt: The request could not be submitted for background processing.

When ran the report from Central management Console with the empty optional field, the following error occurs:

CrystalReportViewer:

handleCrystalEvent failed

Unable to retrieve Object.

Crystal Reports: Print Engine Error

PDF Format works alright, but its the excel sheet export that throws an error. Please help

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Please re-post if this is still an issue to the Business Objects Forum

Former Member
0 Kudos

Below is the report formula. I want each record as a single string data(like a 36bit string data). So I am using the below formula.

Thanks for ur time

-


whileprintingrecords;

shared StringVar data := "";

if Length(Cstr({tab1.SS_NO})) = 9 then data := data + Cstr({tab1.SS_NO})

else (if Length(Cstr({tab1.SS_NO})) < 9

then data := data Cstr({tab1.SS_NO})Space(9-Length(Cstr({tab1.SS_NO})))

else data := data + Left (Cstr({tab1.SS_NO}),9));

if isNull({tab2.CUSTOM8})

then data := data+ Space(7)

else (if Length(Cstr({tab2.CUSTOM8})) = 7

then data := data + Cstr({tab2.CUSTOM8})

else (if Length(Cstr({tab2.CUSTOM8})) < 7

then data := data + Cstr({tab2.CUSTOM8}) + Space(7-Length(Cstr({tab2.CUSTOM8})))

else data := data + Left (Cstr({tab2.CUSTOM8}), 7)));

if isNull({tab3.CUSTOM8})

then data := data+ Space(6)

else(if Length(Cstr({tab3.CUSTOM8})) = 6

then data := data + Cstr({tab3.CUSTOM8})

else (if Length(Cstr({tab3.CUSTOM8})) < 6

then data := data + Cstr({tab3.CUSTOM8})+ Space(6-Length(Cstr({tab3.CUSTOM8})))

else data := data + Left (Cstr({tab3.CUSTOM8}), 6)));

if isNull({tab3.VERSION})

then data := data + Space(1)

else (if Length(Cstr({tab3.VERSION})) = 1

then data := data + Cstr({tab3.VERSION})

else (if Length(Cstr({tab3.VERSION})) < 1

then data := data + Cstr({tab3.VERSION})+ Space(1-Length(Cstr({tab3.VERSION})))

else data := data + Left (Cstr({tab3.VERSION}), 1)));

if isNull({tab4.DURATION})

then data:= data + Space(3)

else (

stringvar durationValue:=Replace(Cstr({tab4.DURATION}),".00", "");

if Length(durationValue) = 3

then data := data + durationValue

else (if Length(durationValue) < 3

then data := data + durationValue + Space(3 - Length(durationValue))

else data := data + Left(durationValue, 3)));

if isNull({tab4.END_DATE})

then data := data + Space(8)

else(

stringVar dateVa := Cstr(Date({tab4.END_DATE}));

local Stringvar formattedD := "";

if Length(dateVa)> 0 then

(if Length(Split(dateVa,"/",3)[1]) = 1 then formattedD := formattedD +"0" +Split(dateVa,"/",3)[1]

else formattedD := formattedD+Split(dateVa,"/",3)[1];

if Length(Split(dateVa,"/",3)[2]) = 1 then formattedD := formattedD +"0" +Split(dateVa,"/",3)[2]

else formattedD := formattedD + Split(dateVa,"/",3)[2];

formattedD := formattedD + Split(dateVa,"/",3)[3];)

else (data := "");

data := data + formattedD

);

if isNull({tab1.CUSTOM7})

then data:=data+ Space(2)

else(

if Length(Cstr({tab1.CUSTOM7})) = 2

then data := data + Cstr({tab1.CUSTOM7})

else (if Length(Cstr({tab1.CUSTOM7})) < 2

then data := data + Cstr({tab1.CUSTOM7})+ Space(2-Length(Cstr({tab1.CUSTOM7})))

else data := data + Left (Cstr({tab1.CUSTOM7}), 2)));

Former Member
0 Kudos

Still need to see your Select formula. What you've psoted does not reference your parameters.

Former Member
0 Kudos

Below is the Record selection formula:

{tab1.END_DATE} >= {?ED Start Date} and

{tab1.END_DATE} <= {?ED End Date} and

{tab2.CUSTOM8} = "NG"

and

({?Pm-?State Code}= "" or ({tab3.CUSTOM7}=ucase({?Pm-?State Code})))

StateCode is the optional field, so its equal to either empty string "" or if value is given, the entered value is compared to the DB Data

Former Member
0 Kudos

What happens if you put parentheses around {?Pm-?State Code}= "" so that it reads ({?Pm-?State Code}= "")

Fuskie

Who has never had an export report fail before but imagines there could be logic confusion in the expression...

Former Member
0 Kudos

I tried that, but i still get the error

Former Member
0 Kudos

Please post your Select formula.