Parameter set to no value

[jschya]

hi,
trying to implement the returning of records if part of the parameter strings are empty doesn't work as described in the crystal knowledge base article c2007344:

(table.field1)=(parameter1) or (parameter1)="&quot and
(table.field2)=(parameter2) or (parameter2)="&quot and(table.field3)=(parameter3) or (parameter3)="&quot and ..

Is there any workaround?

regards
johannes schya

 

[synapsevampire]

It's a little unclear what you want.

Here's a sample where I check for the existence of 'All' or nothing to return all rows:

(if {?Contact Type}[1] <> 'All'
and {?Contact Type}[1] <> '' then
({SOL_VW_RPT_CONTACT_DTL.CONTACTDESC} in {?Contact Type})
else
if {?Contact Type}[1] = 'All'
or {?Contact Type}[1] = '' then
true)
and
(if {?Wrap Up}[1] <> 'All'
and {?Wrap Up}[1] <> ''then
({SOL_VW_RPT_CONTACT_DTL.WRAPUPCODENAME} in {?Wrap Up})
else
if {?Wrap Up}[1] = 'All'
or {?Wrap Up}[1] = '' then
true)

This passes the SQL and handles blanks, perhaps you can give an example of parameter is blank?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[jschya]

sorry for being unprecise when describing the problem.

1)My intention was to build a report that could accept up to 6 parameter as selection criteria.

2) It should be possible to enter only one+ criteria to reduce the selected records e.g. to a certain year or to year and region

3) The report worked fine in crystal reports with one or more parameter

4) Publishing the report in crystal enterprise ePortfolio only worked with all parameters set to a value, otherwise a missing parameter was reported.

5) As it looks like does crystal reports accept a &quot;&quot; as no value string to be passed as selection criterion (as described in crystal knowledgebase article c2007344), the ePortfolio only accepts '' for no value strings.

6) It's working in ePortfolio if I view the report and provide one+ parameter.

7) I still get an error if I try to schedule the report with one+ parameter : &quot;There's more information required before this report is to be processed&quot; (just my clumpsy translation of the german error message)

8) That's the problem and it seems there are three area regarding this report:

- crystal report accepts either &quot;&quot; or '' for no value
- crystal enterprise accepts only '' for no value
- scheduling the report doesn't work at all with no value parameter for the time being

apologizing for the bad english and hopefully precise enough
-js-