how to display dates in report

Question

how to display dates one by one in report,if select 'from date' and 'to date' from date time picker, while date parameters are passing through preview button click

Maneesh A N · Answer

in button preview click frmExpenseDetailsPrint objfrmExpenseDetailsPrint = new frmExpenseDetailsPrint(); objfrmExpenseDetailsPrint.FromDate = dtpFrom.Value; objfrmExpenseDetailsPrint.ToDate = dtpTo.Value; objfrmExpenseDetailsPrint.iAccID = G_iAccountID; objfrmExpenseDetailsPrint.iItemID = G_iItemID; //objfrmExpenseDetailsPrint.dtpInvoive = dtp. objfrmExpenseDetailsPrint.Show(); DateTime dt = Convert.ToDateTime(dtpFrom.Value); DateTime dt1 = Convert.ToDateTime(dtpTo.Value); TimeSpan ts = dt - dt1; int ii = ts.Days; for (int i = 0; i { DateTime dAdd = dt1.AddDays(i); fnInvoiceSaveUpdate(block, dAdd); DateTime dtn = Convert.ToDateTime(dtpFrom.Text); in sql 2005 CREATE PROCEDURE [dbo].[PrcInvoiceReportPrint] ( @iAccID INT, @iItemID INT, @FromDate DateTime, @ToDate DateTime ) AS BEGIN --DECLARE @iSalesID INT --DECLARE @iItemID INT DECLARE @dInvoiceDate INT DECLARE @iTeaQty INT DECLARE @iTeaTotal INT DECLARE @iCoffeeQty INT DECLARE @iCoffeeTotal INT DECLARE @iSoftQty INT DECLARE @iSoftTotal INT DECLARE @iMineralQty INT DECLARE @iMineralTotal INT DECLARE @iPhotoQty INT DECLARE @iPhotoTotal INT DECLARE @iFaxQty iNT DECLARE @iFaxTotal INT DECLARE @iGenQty INT DECLARE @iGenTotal INT DECLARE @iMiscallaQty INT DECLARE @iMiscallaTotal INT SET @iTeaQty=(SELECT SUM(iNos) from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iTeaTotal=(SELECT SUM(deAmount)from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iCoffeeQty=(SELECT SUM(iNos) from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iCoffeeTotal=(SELECT SUM(deAmount)from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iSoftQty=(SELECT SUM(iNos) from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iSoftTotal=(SELECT SUM(deAmount)from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iMineralQty=(SELECT SUM(iNos) from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iMineralTotal=(SELECT SUM(deAmount)from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iPhotoQty=(SELECT SUM(iNos) from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iPhotoTotal=(SELECT SUM(deAmount)from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iFaxQty=(SELECT SUM(iNos) from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iFaxTotal=(SELECT SUM(deAmount)from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iGenQty=(SELECT SUM(iNos) from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iGenTotal=(SELECT SUM(deAmount)from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iMiscallaQty=(SELECT SUM(iNos) from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) SET @iMiscallaTotal=(SELECT SUM(deAmount)from tblSalesItem SI INNER JOIN tblSales TS ON SI.iSalesID=TS.iSalesID WHERE SI.iItemID= SI.iItemID AND TS.iAccID=TS.iAccID AND TS.dInvoiceDate=TS.dInvoiceDate) INSERT INTO tblTempExpense(iAccID, iItemID, iTeaQty, iTeaTotal, iCoffeeQty, iCoffeeTotal, iSoftQty, iSoftTotal, iMineralQty, iMineralTotal, iPhotoQty, iPhotoTotal, iFaxQty, iFaxTotal, iGenQty, iGenTotal, iMiscallaQty, iMiscallaTotal, dInvoiceDate) VALUES(@iAccID, @iI temID, @iTeaQty, @iTeaTotal, @iCoffeeQty, @iCoffeeTotal, @iSoftQty, @iSoftTotal, @iMineralQty, @iMineralTotal, @iPhotoQty, @iPhotoTotal, @iFaxQty, @iFaxTotal, @iGenQty, @iGenTotal, @iMiscallaQty, @iMiscallaTotal, @FromDate) SELECT ISNULL(iAccID,0) AS AccID,ISNULL(iItemID,0) AS ItemID,ISNULL(iTeaQty,0) AS TeaQty,ISNULL(iTeaTotal,0)AS TeaTotal,ISNULL(iCoffeeQty,0)AS COFFEEQTY,ISNULL(iCoffeeTotal,0)AS COFFEETOTAL,ISNULL(iSoftQty,0)AS SOFTQTY,ISNULL(iSoftTotal,0)AS SOFTT OTAL,ISNULL(iMineralQty,0)AS MINERALQUANTITY,ISNULL(iMineralTotal,0)AS MINERALTOTAL,ISNULL(iPhotoQty,0)AS PHOTOQUANTITY,ISNULL(iPhotoTotal,0)AS PHOTOTOTAL,ISNULL(iFaxQty,0)AS FAXQUANTITY,ISNULL(iFaxTotal,0)AS FAXTOTAL,ISNULL(iGenQty,0)AS GENERATORQTY,ISNU LL(iGenTotal,0)AS GENERATORTOTAL,ISNULL(iMiscallaQty,0)AS MISCALLANEOUSQTY,ISNULL(iMiscallaTotal,0)AS MISCALLANEOUSTOTAL,dInvoiceDate FROM tblTempExpense WHERE iAccID=@iAccID AND dInvoiceDate=@FromDate AND iItemID=@iItemID END is this correct?but not getting date as my requirement in report like one by one increasing from 'FROM DATE'

venkata kumar · Answer

hi try the fallowing create one parameter in report give name fromdate. similarly do for to date also ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = dtpfromdate.text; crParameterFieldDefinitions = _objReport.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["FromDate"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

how to display dates in report

Answers (2)