on 09-25-2008 5:40 PM
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
Please re-post if this is still an issue to the Business Objects Forum
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)));
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Please post your Select formula.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.