Parameter error

[tttggg]

I have report with 4 parameters,
Start Date, End Date, Limit (number of rows to be displayed in the report), storeID.
i created the first 3 parameters in the SQL Command and working fine.
With the store ID parameter what happens is when i try to append all the database values to make
the crystal crashes.when i tried to make it dynamic and make it be multiple value
i have a error saying that unable to get data from database.

the report is also grouped my the store id and populating it in the group header.
using CR XI
Database - Postgres

Can anyone help me with this issue.

Thanks in advance

 

[lbass]

You should be able to do this, although it means that the selection on the store ID will occur locally, and will slow your report. You would have to use the parameter you created in CR (not in the command) in a record selection formula. I just tested this, creating some parameters within the command, and then creating one in CR, appending values from the command to populate the list of values, and then using the parameter in the record selection formula, and it worked fine.

I guess the question is what you mean by CR crashing. Did you get an error message? Or did it just slow way down?

-LB

 

[tttggg]

thanks for the reply.
It seems to work fine as long as the parameter is static.
But i want this parameter t be dynamic.
When i make it dynamic and refresh I'm getting the following error:

'List of values failure : fail to get values[Cause of error:
Fail to retrieve data from database UNKNOWN.RPT]'
Error Source: prompt.dll Error code:8x8004380D

Your help is much appreciated
Once again thanks a lot.

 

[tttggg]

i tried it in another way.
I created store ID(Dynamic) , and limit parameter in the CR and created the Start and End Dates in the Command.This Way it works fine but when i refresh the report ,I get two prompts, the first prompt is for the end date and Start date. So when i respond to this prompt i get second prompt where it asks for all the parameter values including the start and end date.
I'm totally lost with this issue.
Can you you please tell me is there a way where i can eliminate the first prompt or what would be the good solution for this problem.

Thanks

 

[lbass]

I don't know of a way to fix this, except to upgrade to the XIR2, which I believe corrects this behavior.

-LB

 

[tttggg]

I actually working on CR XI R2
Sorry i forgot to mention the R2

 

[lbass]

Hmmm. Maybe it's because you are using parameters both from within CR and within a command, not sure. It's not best practice to do this.

-LB

 

[tttggg]

anyone have any idea.
Thanks

 

[dgillz]

LB had an idea......did you try eliminating the parameters with the command?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[tttggg]

I have to to have the Start And End parameters in the command to get required data.If i create from report designer i'm getting too many unwanted data.Thats why i have to create it from the command.But Some how i manage to create the parameter working. But the problem i'm facing is that, when i refresh the report first the start and end Date parameters is pops up and after responding to that then there is another popup for the other parameters including the start and end parameters. Also i'm not able to set the parameter orders to the date parameters.
Any help here is much appreciated.

 

[dgillz]

I have to to have the Start And End parameters in the command to get required data

Not true, you can have the command return the entire recordset, and filter it with Crystal parameters.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry