Hi to all,
I am new to Generate TelericReports. I want to display Report for Selected Item in Dropdownlist programmatic ally.
My dropdownlist items are 'ProductName, CategoryName,Manufacturer. When I select Product(dropdownlist Item) it should display product related report. I created a store procedure like this ..
if(@Filter='ProductName')
SELECT d.ProductID as 'Product ID',S.ProductName as 'Product Name',Count(d.ProductID) as Sold from S2Commerce_StoreOrders o
inner join S2Commerce_StoreOrderDetails d on d.OrderID=o. OrderID
--inner join S2Commerce_PayHist p on p.OrderID=o.OrderID
inner join S2Commerce_Products s on s.ProductID=d.ProductID where convert(varchar(10),OrderDate,101) >= @fromdate and convert(varchar(10),OrderDate,101) <= @todate group by d.ProductId,S.ProductName
else if(@Filter='CategoryName')
SELECT S.CategoryID as 'Category ID' ,C.CategoryName as 'Category Name',Count(s.ProductID) as Sold from S2Commerce_StoreOrders o
inner join S2Commerce_StoreOrderDetails d on d.OrderID=o. OrderID
--inner join S2Commerce_PayHist p on p.OrderID=o.OrderID
inner join S2Commerce_ProductCategories s on s.ProductID=d.ProductID
inner join S2Commerce_Category c on c.CategoryID=s.CategoryID where convert(varchar(10),OrderDate,101) >= @fromdate and convert(varchar(10),OrderDate,101) <= @todate group by S.CategoryID,C.CategoryName
else if(@Filter='Manufacturer')
SELECT s.ManufacturerID as 'Manufacturer ID',m.ManufacturerName,count(s.ManufacturerID) as Sold from S2Commerce_StoreOrders o
inner join S2Commerce_StoreOrderDetails d on d.OrderID=o. OrderID
--inner join S2Commerce_PayHist p on p.OrderID=o.OrderID
inner join S2Commerce_Products s on s.ProductID=d.ProductID
inner join S2Commerce_Manufacturer m on m.ManufacturerID=s.ManufacturerID where convert(varchar(10),OrderDate,101) >= @fromdate and convert(varchar(10),OrderDate,101) <= @todate group by s.ManufacturerID,m.ManufacturerName
else if(@Filter='Day')
SELECT convert(varchar(10),OrderDate,101) as 'Day',count(o.OrderID) as #Orders,sum(d.UnitCost * d.Quantity) as TotalAmount,sum(ShippingTotal) as TotalShipping,sum(DiscountAmount) as DiscountAmount,sum(TaxAmount) as TotalTax from S2Commerce_StoreOrders o
inner join S2Commerce_StoreOrderDetails d on d.OrderID=o. OrderID
--inner join S2Commerce_PayHist p on p.OrderID=o.OrderID
inner join S2Commerce_Products s on s.ProductID=d.ProductID where convert(varchar(10),OrderDate,101) >= @fromdate and convert(varchar(10),OrderDate,101) <= @todate group by convert(varchar(10),OrderDate,101)
else if(@Filter='Month')
SELECT DateAdd(Month, DateDiff(Month, 0, OrderDate), 0) as 'Month',count(o.OrderID) as #Orders,sum(d.UnitCost * d.Quantity) as TotalAmount,sum(ShippingTotal) as TotalShipping,sum(DiscountAmount) as DiscountAmount,sum(TaxAmount) as TotalTax from S2Commerce_StoreOrders o
inner join S2Commerce_StoreOrderDetails d on d.OrderID=o. OrderID
--inner join S2Commerce_PayHist p on p.OrderID=o.OrderID
inner join S2Commerce_Products s on s.ProductID=d.ProductID where convert(varchar(10),OrderDate,101) >= @fromdate and convert(varchar(10),OrderDate,101) <= @todate group by DateAdd(Month, DateDiff(Month, 0, OrderDate), 0)
Regards,
Venkateswararao