I have two report viewer in a page .....I have two store procedure ..That return a result and store into Datatable. One Store procedure is Parameterless and 2nd is parameter .But One Report viewer Show the result but another one that is parameter with Storeprocedure didnot show in report viewer
I m using Visual studio 2008 for ------------>SSRS report
And call it Visual studio 2010.
plzzzzzzzzzzz guide me


Dilshad AliPosted Oct 3, 2013, 10:18 AM
GO
/****** Object: StoredProcedure [dbo].[spSellerUnpaidHistory] Script Date: 10/03/2013 14:21:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spSellerUnpaidHistory '09/01/2013','09/28/2013',1,1]
(
@FromDate as varchar(50),
@ToDate as varchar(50),
@Counter as int,
@ID as bigint
)
AS
BEGIN
if(@Counter=1)
select P.tblProduct_ItemName, OD.tblOrderDetails_DiscountAmount As Payble_Amount,CONVERT(VARCHAR(12),OD.tblOrderDetails_CreateDate , 101) AS Date_Of_Sell from tblOrderDetails OD INNER JOIN
tblOrders O ON
O.Order_ID=OD.tblOrders_ID
INNER JOIN tblOrderStatus OS ON
OS.tblOrderStatus_ID=O.tblOrderStatus_ID
INNER JOIN tblProduct P ON
P.tblProduct_ID=OD.tblProduct_ID
INNER JOIN tblSellerMaster S ON
S.tblSellerMaster_ID=P.tblProduct_CreatedBy
Where P.tblProduct_InsertBy='Seller' AND S.tblSellerMaster_ID=@ID AND O.tblOrderStatus_ID <=4 AND
O.tblOrders_CreateDate>= Convert( varchar(12),@FromDate,101) AND O.tblOrders_CreateDate<=Convert( varchar(12),@ToDate,101)
End
Ramesh MaruthiPosted Oct 3, 2013, 10:14 AM