Dynamic parameter filter

[Former Member]

Hi All,

I have the attached report created.

There are two parameters, Supplier - AP001_org_code and Supplier - AP105_Name.

What i need to do is to refresh the list of Supplier - Ap105_name when the user select the Supplier - AP001_org_code.

Notice that if i add in one new supplier Name in Supplier - AP105_name, the supplier will not appear in my Supplier - Ap105_name parameter.

I did select the correct Org but the new supplier does not appear in the list.

Can anyone help me to check on that?

Thanks.

Payment.txt.zip

[former_member477249]

Can you test with a parameter based on some other field.

Prathamesh

[abhilash_kumar]

Hi Mavis,

Is the report saved to the BO Enterprise and is the LOV 'scheduled using the Business View Manager'?

Try clicking the 'Clear Instance' button under 'Edit LOV' option in Business View Manager. This will make the LOV 'on-demand' and should send a query to the database each time the report is refreshed.

-Abhilash

[Former Member]

Hi Abhilash,

This report is not save to BO.

What is LOV?

This report is link to one of our application.

[abhilash_kumar]

LOV = List of Values.

When you refresh the report in the CR Designer, does the LOV show the new values you've added to the database?

-Abhilash

[Former Member]

Hi Abhilash,

Notice that when i run the report with CR Designer, the supplier list is being updated but when i run the report in my application (the database in a server) the supplier list is not being updated.

Not sure is it the server resource issue.

Thanks.

[abhilash_kumar]

And what is this 'application' that you run the report from? Is it a Crystal Reports Server, BO Enterprise Server or a custom application that someone built for you?

-Abhilash

[Former Member]

Hi Abhilash,

It is a so call custom application which sit in Cloud server.

[Former Member]

Hi Abhilash,

I have a question.

For the report, i did a Print Preview from CR Designer in my live database and i am unable to pull out the full list of supplier.

When I did a Print preview  from CR Designer in test database, i am able to get the full list of supplier.

Both Database sit in diff server in the cloud.

Can i confirm that it is a server issue?

Thanks

[abhilash_kumar]

Do both the databases have the same suppliers?

CR limits the values in the prompt to 1000 for performance reasons. The resolution is to modify a registry key.

What version of CR are you using and is the OS 32-bit or 64-bit?

-Abhilash

[Former Member]

Hi Abhilash,

Both database have the same list of suppliers.

I am using Version 2008

My Dynameic parameter allow the user to select the org and it will filter the list of suppliers that belong to the org the user select.

For the Org there are only 7 selection and the supplier max list i have is only 650.

Can i check for one more question, for dynameic parameter, the first parameter can it be auto deteacted?

When the user login to the application, they will select which org they wan to be in.

Can the first selection to deteact and list the all the suppliers in that org?

Will this solve my issue?

[former_member477249]

The prompt being used in the report is called a dynamic cascading prompt.

Once user selects a value from the Org-code the corresponding list of suppliers is populated in the Supplier parameter.

By auto-detecting do you mean that the Org-code will be pre-selected based on the user who logs-in. If thats the case, then it can be made possible using a CurrentCEUserName special field available in Business View Manager and Crystal Reports. You can refer this post as an example

However, hope, this should not complicate the issue even further.

In your case, if it is evident that running the report off different databases- test and live , fethches different supplier list then you should first work on getting the two databses in sync before testing it from the Crystal-end. A simple Select Supplier-AP105_Name from Table_Name should tell the difference, if any.

Prathamesh

[Former Member]

Hi Prathamesh,

Thanks for your repsonse.

have look into the supplier table in both live and test database.

The data inside is the same.

Thanks.