Hi,
I need to create a SSRS report that shows data from 2 different Stored Procedures that expect the same two parameters. How do I do this please? One Stored Procedure will return 3 or 4 lines (Summary Data) whilst the second will return 100's of lines ( the detail)
2 Tables are as below. Report will look like this below:
Unfortunarely my data has to come from 2 stored procedures and 2 datasets I cannot merge them for lots of other reasons.
Report Start --------------------------
-------
(From Stored Procedure 1)
Type Amount Notes
Cash £100 Blah Blah Blah
Card £50 La La La La
(From Stored Procedure 2)
Type Amount ItemNo
Cash 10 1
Cash 50 2
Cash 40 3
Card 25 1
Card 25 2
Report End-----------------------
----------
---
DROP TABLE [dbo].[TableA]
CREATE TABLE [dbo].[TableA](
[Type] [varchar](50) NOT NULL,
[TotalAmount] [decimal](18, 2) NOT NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[TableA]
([Type] ,[TotalAmount], [Notes])
SELECT 'Cash' ,100, 'Blah Blah Blah'
UNION SELECT 'Card', 50, 'la la la'
DROP TABLE [dbo].[TableB]
CREATE TABLE [dbo].[TableB](
[Type] [varchar](50) NOT NULL,
[Amount] [decimal](18, 2) NOT NULL,
[ItemNo] [int] NOT NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[TableB]
([Type]
,[Amount]
,[ItemNo])
SELECT 'Cash', 10, 1
UNION SELECT 'Cash', 50, 2
UNION SELECT 'Cash', 40, 3
UNION SELECT 'Card', 25, 1
UNION SELECT 'Card', 25, 2
GO
Thanks
nutnut
Start Free Trial