Tuesday, December 29, 2015

How to add command to crystal report

It is so confusing of using crystal report with database expert

under data tab

on the right side, select my connections, the sql db, then click on add command, then click on ">" button. It will prompt "Add Command to report" window.

Then you add SQL and Parameter

after you finish, if pass the syntax check, then you get it back to the Database Expert window, then you have to right mouse click on the "Command" to view the options to Edit, View or add to repository.

If you have two commands, then you have to link then using the link tab.

No comments:

Post a Comment