Joined: 14 Oct 2008
Location: United States
Online Status: Offline
Posts: 22
Topic: "set to null" on parameters Posted: 20 Nov 2009 at 7:53am
Can anyone tell me what "set to null" on the parameter screen is or does? We run Crystal reports from Lawson's dashboard and this "appears" to serve no purpose and is distracting but I haven't been able to find it in the book or in my research. I would like to remove it. Any help would be greatly appreciated!!
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 23 Nov 2009 at 7:01am
It sets the value of the parameter being passed to NULL. This may have no effect on the report. Yes, it is distracting. No, I don't know how to suppress it. It gives the user the ability to skip a parameter, but usually the parameter is needed and skipping it is not an option.
Joined: 14 Oct 2008
Location: United States
Online Status: Offline
Posts: 22
Posted: 23 Nov 2009 at 8:18am
I did find info on the BO website that you can (supposedly) suppress by calling the stored procedure with a Command connection but you have to add the parameters (I have 9) and if the syntax isn't right, you have to add the parameters all over again. I gave up. Plus it seemed to be adding yet another level of complexity to an already complex report. Wish it was just a parameter checkbox.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 23 Nov 2009 at 10:57am
My company got tired of the Crystal parameter screen. Our application creates a wizard to step the user through the parameter selection then gets the dataset and passes it to the report...simplified my life considerably as the wizard is much more flexible in presentation and retrieval of what the user wants (and we have control over the whole process).
Joined: 14 Oct 2008
Location: United States
Online Status: Offline
Posts: 22
Posted: 23 Nov 2009 at 1:12pm
That sounds like a great solution. However, we're publishing reports to Lawson's LBI dashboard. We remove their parameters (looks better and more functionality???) so it shows the Crystal parameters. I would just like to get rid of this one thing but I don't think its worth the effort at this point.
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
IP Logged
