cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal reports Using Stored procedures?

Former Member
0 Kudos

HI Experts

What is the use of stored procedures in Crystal reports? How it will help us to generate report? If so what kind of reports we generate using stored procedures? When I am using stored procedures it asks more parameter valuer values? what is that parameter values?

Plz help me.

By

Kalai

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

You can call Stored Procedure in Crystal Reports.

For example:

You have STORED PROCEDURE REPORT_BY_CODE (@Code varchar(20))

When you create report add command as query below and parameter Code of String type:


Exec [dbo].[REPORT_BY_CODE] '{?Code}'

It's work.

HTH

Regards

Sierdna S.


CREATE PROCEDURE REPORT_BY_CODE (@Code varchar(20))
AS
BEGIN
  SELECT P.DocEntry, P.DocNum, P.Comments, C.Dscription 
  FROM ORDR AS P, RDR1 AS C
  WHERE P.DocEntry = C.DocEntry
  AND C.ItemCode like '%' + @Code + '%'
END

Edited by: Sierdna S on Sep 25, 2008 11:47 AM

Answers (1)

Answers (1)

former_member186095
Active Contributor
0 Kudos

Hi,

it is really useful. To know more pls browse this link:

https://boc.sdn.sap.com/node/246

Rgds,