Crystal Report Parameter multiple values

[Former Member]

In crsytal report 2008, I created a report to enable user to view list of sales order. I created the following parameter to display list of sales order:

doc@select docnum from ORDR

In SAP B1 8.8, it displays a dropdown list of SO and users can select one sales order at a time to view the report. However, is there a way for users select MULTIPLE SO from the dropdown. I know in the parameter properties, you can set the 'enable range values' to TRUE. The end result of that is it generates a range for users to choose from (docnum next to each other). Instead of selecting range of SOs, is there a way for users to select random SO from the list? Example, from the list, select SO 13000, 13010, 14000 etc. Thanks.

[Former Member · Accepted solution]

Hi,

It is not possible to select random value from the list.

This is a limitation of CR parameter.

Thanks,

Gordon

[Former Member · Accepted solution]

Experts,

I know this is crystal limitation. But is there a workaround? I desparately needed to get this done.

I change the parameter to 'dynamic' and select DocNum as Value. Under value options, I changed 'allow multiple values', 'allow discrete values' and 'allow range values' to TRUE. When I view in SAP, there's a multiple values selection window appears with 3 columns: value, description and check box. For some reason, the value column is empty. If the value field is successfully populate with all SO docnum values, then i can manully check the box and the report will be successful. I know I am getting closer. Any help will be much appreciated!!

[Former Member · Accepted solution]

Just try leave only 'allow discrete values' to see.

[Former Member · Accepted solution]

Nope. that doesn't work. Don't know why the values field are not showing....

[Former Member · Accepted solution]

What if nothing selected? If still show nothing, that mean they are not value but text.

[Former Member · Accepted solution]

Gordon,

The multiple selection value screen has 192 lines and that's exactly the same total as open sales order.

Seems like it has the correct total but not showing all the sales order details.

I took a look in CR parameters, found out value field is not selected. When I select docnum from value field, it prompted me to enter db info. I entered those info and receive the following error:

Login failed

Error in file UNKNOWN.PRT

Unable to connect: incorrect log on parameters (rptcontrollers.dll)

Why does it ask me for seperate login for parameters?

[Former Member · Accepted solution]

Hi,

Have you a copy of this:

https://websmp209.sap-ag.de/~sapidb/011000358700001264462010E/Working_with_CR_Integr.pdf

It does describe how to use tokens to create different types of parameters in reports

The one for choosing multiple from accounts table is <parametername@FROM OACT

not sure if it would work on ORDR as well or not.

[Former Member · Accepted solution]

Creating the token as

  doc@select * from ORDR 

will work, it'll give you a multiselect B1 selection screen inside B1

where you can select as you like

Just remember to put the Select expert criteria as

 ORDR.docentry in doc@select * from ORDR 

the IN is important here

[Former Member · Accepted solution]

Daniel,

Excellent, I changed

- list of values from static to dynamic

- changed toke from @select docnum to @select *

- changed select criteria from docnum to docentry

The list works fine.

From the multiple values selection screen in SAP, it shows the following three columns:

- Value (DocEntry)

- Description (DocNum)

- Check Box

I was able to hide the vlaue (docentry) column from form settings. However, can I change the name of 'Description' to something more meaningful like 'Sales Order #'? Also, the description column is really wide. Is there any way I can narrow the column width?

[Former Member · Accepted solution]

To change the above, do I need to change them in SAP SDK or can I change it in crystal?

[kvbalakumar · Accepted solution]

Hi,

You can change this in the Crystal itself, no need to go for SDK....

Regards,

Bala

[Former Member]

Hi........

The work around behind your solution would be you need to apply the selection range criteria so that you can select multiple SOs........

Regards,

Rahul

[Former Member]

Hi Rahul,

But that will only allow me to select range of multiple SO though (e.g. from 5 to 10, 11 to 20 etc.).

Is it possible I can select random multiple SO, like 5, 9, 16, 19 etc.?

Edited by: flyboy10 on Jul 8, 2011 7:39 AM

[Former Member]

Hi.......

I dont think it is possible.

You can only have Range criteria or have single or random but only one selection.

If you want the way how you then you have to create that many no. of selection criteria but will be fixed and from your requirement it seems the no. of criteria should be variable........

Regards,

Rahul