Issue when using Add Command

[BettyJ]

I created a report using Add Command. It uses a dynamic parameter.It runs perfectly inside Crystal Reports. But once I run it inside the application (Centricity EMR)it is missing parameter values. Can anyone offer suggestions? Thanks in advance.

 

[PeterDimitrov]

Is the parameter value set by Centricity EMR ?

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports and SSRS.

 

[BettyJ]

Thank you for your reply, Peter. I don't exactly get what you are asking. But, I will explain what the report is doing.

This report pulls the patients who have appointments on a selected date with a selected provider. I have used a SQL Command as the data source.

Parameters are date and provider. Date is a static parameter. Provider is a dynamic parameter. The parameter is a field of the SQL command. When I run the report inside Crystal Reports I am able to see all the providers. But, when I run it inside Centricity EMR, some of the providers are missing.

 

[PeterDimitrov]

I was thinking that you receice an error for missing parameter values.
Do you have more than 1000 providers ?

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports and SSRS.

 

[BettyJ]

Thankyou again Peter.

We have more than 1000 providers. But, my question is mainly why it is not displaying all the providers when I run it inside the application(Centricity EMR) while it is listing all of them when run inside CR.

I also tried to filter by location also. So in one particular location I had 10 providers. In CR, it listed all 10 of them. When I ran it inside EMR, only 6 of them is being listed.

Any ideas?

 

[PeterDimitrov]

Centricity EMR might be using different Crystal Reports runtime.
Sample registry key for the restiction is:
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords
This include the version

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports and SSRS.

 

[BettyJ]

I added the MaxRowSetRecords for HKEY_CURRENT_USER already. For a previous report, I was not getting all the values inside CR. It worked fine once I added it. Now it is set to 10000000.

Under HKEY_LOCAL_MACHINE I don't see Database Options folder. How do I add the remaining? Can you explain the steps? Thank you so much.

 

[PeterDimitrov]

Open regedit, select the key, right click , select "New" and then "Key" do this to create each level and at the end create a value.
You need to know the version of the components used by Centricity EMR. The sample bellow is for version 11:
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords

It probably will be OK to create this in HKEY_CURRENT_USER, but then you will need to create it for any user who is using the machine ( login as the user and create the registry key)

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports and SSRS.

 

[BettyJ]

I am using CR version 11.As mentioned in the previous post, I already have the LOV set under HKEY_CURRENT_USER. I cannot add DATABASEOPTIONS under HKEY_LOCAL_MACHINE. It is giving an error: "Cannot create key. Error while opening the key Crystal Reports".

If you have any suggestions please let me know.

I really appreciate your help.

 

[briangriffin]

When you publish to Centricity, the report is being processed on the Centricity server, correct? So you would have to modify the key on the server in addition to the pc you use for development. You may have done this, but I don't see that in the thread.

 

[PeterDimitrov]

I didn't even know that Centricity is a server based software

Even if it is installed on the same machine it might use Crystal Reports runtime with different version than your designer. For example most of the .NET applications will use CR runtime version 13. If this is the case you will have 2 different versions of Crystal Reports components on the same machine - 11 and 13 and you need to create the key for both.

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports and SSRS.