Modifying command in crystal report

[#1]

Hi to all,

I have a A/R invoice crystal report layout with inside a subreport for the VAT detail.

In this subreport there is B1_VatView in expert database and I seem to remember that I was able to edit and modify it.

I remember that doing right click on B1_VatView in expert database and selecting "modify command" I was able to do it.

Now I can't do it because doing right click, I don't find the "modify command" choice.

Anyone can say me why?

Thank you

[Former Member · Accepted solution]

Hi Federico,

Have you published this report to BO Enterprise or Crystal Reports Server?

If yes, then open the report from Repository >> Save it on local hard drive and test it again.

You can also go into Database >> View SQL >> Copy the SQL >> Test with a new report using the Add Command feature

and update this thread with the findings.

Thanks,

Prathamesh

[Former Member · Accepted solution]

Hi Prathamesh,

No, the report is not published in BO enterprise.

If I create a own command, I can modify it.

Instead adding in the report the B1 database views I can't do it.

Thanks

Federico

[abhilash_kumar · Accepted solution]

Hi Federico,

Could you explain this part a little more please : "Instead adding in the report the B1 database views I can't do it."?

-Abhilash

[Former Member · Accepted solution]

Can you mention the workflow here. for e.g type of connection being used etc.

Thanks,

Prathamesh

[Former Member · Accepted solution]

- I open Expert database window.

- In data source section, I open the server name->db name->dbo->views

- I select the B1_VatView and I add it to the report

- when I try to modify it doing right click on command, I can't find the modify command choice

I seem to remember that I was able to do it

Thanks

[abhilash_kumar · Accepted solution]

Thanks Federico; that explains things!

You cannot modify the SQL behind a Table or View that is added from the Database Expert and moreover what you're called a Command Object is NOT really what you think it is!

To be able to 'modify', you first need to add a Command Object via the "Add Command" option. This option should be available under the Database Connection name in the Database Expert.

Using this option you can add a SQL Query and report against it. The option to "Edit" the command in the Database Expert is available for such objects only.

Hope this helps!

-Abhilash

[abhilash_kumar]

Hi Federico,

Which version of Crystal Reports are you using?

Does this happen on just this report or all the reports?

-Abhilash

[Former Member]

This message was moderated.