Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Double parameter windows Post Reply Post New Topic
Author Message
ajmufic
Newbie
Newbie


Joined: 28 Aug 2008
Online Status: Offline
Posts: 20
Quote ajmufic Replybullet Topic: Double parameter windows
    Posted: 24 Apr 2009 at 1:20am
Has anyone else ever experienced a problem with double parameter windows? I have some dynamic drop down lists that I fill with data from stored prodecures. Everything works ok in the development tool but when I run the report from our ERP-system I get two parameter windows!! Confused
First I get "the new one" which contains textboxes, with @<parametername> as headline.
After I filled in these my "real" parameterpage comes up, with dropdownboxes that contains the correct data, correct headlines etc.
 
I realize that this of course could have something to do with our ERP-system but have anyone else ever experienced this? And did you manage to solve it??
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 24 Apr 2009 at 6:42am
I think we had something like that happen, but you won't like the solution...we did away with the Crystal parameter screens.  Our ERP system collects the information for the parameters, calls the stored proc and sets the resulting dataset to the reports dataset, and then we display the report.
 
In the long run, it has been really nice, there is only 1 data table, so there is only 1 call to the database.  If there is a subreport (and the usually isn't), it is looking in the same table, so it is all in memory and no additional calls to the database.  The parameter inputs can look way nicer and have much more functionality and ease of use for the users.
 
It kind of sounds like the report is getting parameters to populate the stored procs that populate the parameters, but Crystal is odd when it comes to populating Command objects for parameters...at least every now and then.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.