Guest_imported
New member
- Jan 1, 1970
- 0
How do I use a stored procedure in CR ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crystal Reports and Procedures
- Thread starter Guest_imported
- Start date
- Status
KamalKhalil
MIS
In short, a stored procedure is a saved group of statments that returns an output or triggers another action.
You need to know where the stored procedure is located.
Then, you need to decide what fields you need to pick up , if not all.
You will be prompted to decide what are you going to group by, and what fields you would like to subtotal.
The rest actually will be the same as if you are using a table.
Hope this will give you the lead. Kamal Khalil
Sr. Client Technical Analyst
kkhalil@Houston.ds.adp.com
You need to know where the stored procedure is located.
Then, you need to decide what fields you need to pick up , if not all.
You will be prompted to decide what are you going to group by, and what fields you would like to subtotal.
The rest actually will be the same as if you are using a table.
Hope this will give you the lead. Kamal Khalil
Sr. Client Technical Analyst
kkhalil@Houston.ds.adp.com
File|Options|Database has Show Stored Procedures under the Explorer Options - the default installation has this turned off I believe.
You have to turn on this option so that you will be able to see sp's in the explorer with other tables. Malcolm
You have to turn on this option so that you will be able to see sp's in the explorer with other tables. Malcolm
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question