Winla
Apr 17th, 2008, 01:48 AM
I have a stored procedure with the following simplified code
Procedure usp_MonthSummary
AS
Select top 1 Programname, programlocation, participantNo, revenue, Cost from tblManyTables
Now I would like to have a Crystal reports to show the summary as a following two column table
Program Name xxxxx
Program Location xxxxx
Particiapnt Number xxxxx
revenu xxxxx
cost xxxxx
How to do it?
If I have several one row SQL query and I like to have each one row query to fit into a table like above , can I achieve my goal using CR?
Thanks
Procedure usp_MonthSummary
AS
Select top 1 Programname, programlocation, participantNo, revenue, Cost from tblManyTables
Now I would like to have a Crystal reports to show the summary as a following two column table
Program Name xxxxx
Program Location xxxxx
Particiapnt Number xxxxx
revenu xxxxx
cost xxxxx
How to do it?
If I have several one row SQL query and I like to have each one row query to fit into a table like above , can I achieve my goal using CR?
Thanks