Joined: 08 Jan 2014
Online Status: Offline
Posts: 16
Topic: Parameter with Like, Specific and ALL Clause Issue Posted: 12 Feb 2014 at 7:17am
My dataset has a field that shows City, State ZIP and sometimes country code as well. I need my parameter to gather sales info from the dataset, currently my parameter has the specific dataset listed as a drop down, but I also made it editable. I want the end user to be able to pick a specific City, State ZIP from the drop down or manually type in part of whats in the field, such as for Fresno, CA which may have multiple entries with different ZIP's if the user manually types in Fres I want the result to be every record that has Fres in it.
So the formula I am trying to make thus far is as follows... if {?CityStateZipParameter} = "ALL" then {CityStateZipDataset} = "*" else {CityStateZipDataset} like {?CityStateZipParameter}
Joined: 08 Jan 2014
Online Status: Offline
Posts: 16
Posted: 12 Feb 2014 at 8:31am
Thanks DBlank! That worked, when I type in Fres it brings up the correct data, when I select ALL I get all data for the date range. The only issue I have is when I select a specific City, State ZIP from the drop down it still shows nothing...
Dataset Sample: Fredericksburg, TX 78624 Fresno, CA 93706 FRESNO, CA 937116096 Fresno, CA 93722-3451 Fresno, CA 93726 Friendswood, TX 77546 Frisco, TX 75034
So with that parameter I have it set to allow editing but I also selected the field and added all values so they show up like the above sample in a drop down list, so if someone knew the specific City, State ZIP they could select it.
I tried to edit the formula you provided a little bit... ({?CityStateZipParameter} = "ALL" or {CityStateZipDataset} like "*"+{?CityStateZipParameter}+"*" or {CityStateZipDataset} = {?CityStateZipParameter})
When someone selects from the list the report should pull that data for that specific City, State ZIP, not sure if this is possible or not.
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