Crystal Reports Select all when parameter is blank.

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Select all when parameter is blank.
	<< Prev Page of 2

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 04 Apr 2014 at 7:03am
	In the parameter properties I believe you have to set Optional=True That said, if you looka the below it is not checking the DB for the field to be ="", it is checking the parameter value to be "" which is similar to your "else 1=1". ({?Parm}="" or {?Parm}={SomeTable&Col})
	IP Logged

DrPepperholik Newbie Joined: 03 Apr 2014 Online Status: Offline Posts: 9	Posted: 04 Apr 2014 at 8:10am
	That got it to work in Crystal but when I move the Crystal file over to the reports directory for the vendor software it doesn't work. Is that something that will only work in the Crystal environment?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 04 Apr 2014 at 8:43am
	Not sure I can answer that. I assume the software has its own custom interface to run the reports and input the parameters so I don't know how that was written or if the custom interface accepts the blanks/nulls in the params.
	IP Logged

DrPepperholik Newbie Joined: 03 Apr 2014 Online Status: Offline Posts: 9	Posted: 04 Apr 2014 at 8:48am
	Your guess is as good as mine. I wish I could access the code for the vendor software but of course I can't.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 04 Apr 2014 at 9:27am
	another solution is to use stored procedure as a source or to add an 'All' to the lists and use it instead of a blank/null.
	IP Logged

DrPepperholik Newbie Joined: 03 Apr 2014 Online Status: Offline Posts: 9	Posted: 04 Apr 2014 at 9:47am
	There is no list, it's user entered data. It's not a drop down.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 04 Apr 2014 at 10:01am
	So can you train the users to use/type in 'All' (trim({?Parm})="All" or {?Parm}={SomeTable&Col})
	IP Logged

DrPepperholik Newbie Joined: 03 Apr 2014 Online Status: Offline Posts: 9	Posted: 04 Apr 2014 at 10:38am
	I didn't think of that. The problem is solved by them having a standard report that already did the "all" part so I made this parm field required so they can't get back an empty report.
	IP Logged

<< Prev Page of 2

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.016 seconds.