Parameter question

[luv2bike2nv]

I have a parameter in a report as follows:
Name: VendorID
Prompting Text: Enter Vendor ID
Value type: String

Options:
Allow multiple values
Discrete Values
Allow Editing of default values when there is more than one value

Set Default Values
Browse Table - order master
browse Field - Venid

selected all the values that need to be default. there are 41 vendor ID that I brought over.

The problem i am having is that when i refresh the report and add all of the 41 one vendor id only 20 vendors show up the other 21 are not there.

What could be causing this to happen? How would I fix this?
also is there a way i can "hard code" the vendor numbers so the user does not have to select all of them?

thanks,
r

 

[lbass]

I think you are using an older version of CR. You could import the values for the picklist instead of trying to get them from the browse option--there is a registry key that controls how many are returned, and you should not go into the registry unless you know exactly what you are doing.

To import a list, you would create a separate Crystal Report with the desired value and description field, export the report to tab-separated text, and then in wordpad, use find/replace to replace the quotes with nothing (leave replace blank). Then save this file and import it as your picklist.

-LB

 

[luv2bike2nv]

Thank you LB.

Yes we are using CR 8.5 (very old)

I won't be trying the import list this week, I will play with that next when I return to the office.

Thanks again.
R

 

[luv2bike2nv]

I created a seperate CR and did as you said to do however I am still getting just 20 vendor ID and not the 41 that is needed.

The registry Key that you are talking about is that in CR or is that the REGEDIT on the server where CR is installed? If so, where would i go to make the change. I am comfortable in working in the REGEDIT file.

thanks so much for your help.

R

 

[lbass]

The limit for the import should be 1000, I think, so I really don't think that's the issue. Do you see all 41 vendors in the separate report you created to use for the picklist?

-LB

 

[luv2bike2nv]

Yes I see all of the 41 vendor ids in the list.

 

[lbass]

I just imported a list of 270 values into 8.5--without making any changes to the registry. So after creating the report with the 41 vendors, what did you do next?

-LB

 

[luv2bike2nv]

from the vendor Id report (with only has the vendor ID for detail field and a parameter which i imputted all the vendor ids that we want in the default values), I exported the report to a Tab-separated text (format) and disk file (destination). I left the default for Specify the number of char. per inch for the text layout to User defined (9) wordpad opened up.

In wordpad, I removed VenID heading at the top of the list and than Find all the " and replace with nothing. so there were no quotes in the list. I saved the file which had the extenion of ttx.

I went to the report that i wanted to import the pick list to, (parameter is VenID) went to set default values and cleared what was there already, then import pick list, the ttx file did not show up only TXT files showed up. so i exported the vendor id report again and save it as a txt file. went back in to import the txt file (cleared what was already in the default list) and all the vendor ids came up. i refreshed the report, i added all the vendor ids and only 20 showed up.

what step did i miss.

 

[lbass]

So they all appear in the pick list but then when you select all values at the prompt not all show up in the main body of the report? This wouldn't have anything to do with the picklist, but instead probably with your links. What tables are you using, and how are they joined? If you want all vendors to appear in the report, then you should use the vendor table as your lead table, and join other tables to it with a left outer join--and no selection criteria on the outer tables.

-LB

 

[luv2bike2nv]

I have 4 tables (order master, Vendor master, PO Receipt, part master) which i looked to see if i need them all and i do. I changed the order of them to have Vendor master first with VenID as the link between the two, and link the other tables together as well.

I made the change in Select Expert to have Vendor Master is equal to ?Venid instead of the Order Master is equal to ?Venid. I also changed the Parameter setting to use Vendor Master as the table and VenID as the field I am still getting only 20 vendor ids.

 

[lbass]

Did you make the joins to the other tables left outer joins? With no selection on any table except the Vendor master? I would think you would link something like this:
lo join lo join
vendormaster------->order master------>part master
|
| lo join
v
po receipt

-LB

 

[luv2bike2nv]

I am in the process of recreating the report and I just did the parameter and the select statement and it is working. I just have figure out what I did to make it work in the new report and make the adjustments to the old one.

I will get back with results hopefully later today if not I will next week.

Thanks,
R

 

[luv2bike2nv]

LB... thank you for your help (again)

I recreated the report and everything is working the way it suppose to be working.

R