Showing posts with label Crystal report. Show all posts
Showing posts with label Crystal report. Show all posts

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.

Visual studio view crystal report field explorer

open the rpt file
Go to view, other windows, document outline

Tuesday, August 25, 2015