Can I show Parameter results in Report

Hot Topic

Converting Video 3D from june to sept CTP
How does one set a default value?
Unable to install Visual Studio 2005 on Vista build 5270
VisualBrush + BitmapEffect + Animation = Bug?
Problem about the VSS's Get operation.Need help!
Error opening class diagrams
Determaining isselected inside a data template
WinForms and WPF Dialogs
Assembilies for VSTO files
Database Project Template (possible???)

Visual Studio

Setting the base address
Hierarchies in DataContracts
Outlook 2003?
Office 97 problem
checkitem in menu
Multicast with UDP Transport Sample
Console host with TCP binding: SecurityNegotiationException
VS .NET install problem on XP pro
Reportviewer/Sql Server 2005 Reporting Services Parameter passing problems - Help!
Using MSBuild to build multiple resource assemblies in multiple directories

Can I show Parameter results in Report

Hi,

I have a problem to showing parameter values in my report for exampel (From Date and To Date).

I define public property in my code but i am not able to show these values in my report.

Public Class StatisticsForm
Public fromDate As DateTime
Public tilDate As DateTimePrivate Sub StatisticsForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

fromDate = Now()
tilDate = Now()
Me.Sp_CreateStatisticsTableAdapter.Fill(Me.PromusDataSet1.sp_CreateStatistics, fromDate, tilDate)

Me.ReportViewer1.RefreshReport()

End Sub

How can I show fromDate and EndDate in my report



Answer this question

Can I show Parameter results in Report

  • Medo

    Did you ever solve this   I am having the same problem.

    Thanks,

    Paula

  • Greg Chadwick

    I've just been through this...  The parameters you have are probably for the query only and have not been set up in the report (Report->Report Parameters).  Set up the report parameters and then work from the following:


    Dim p1 As New Microsoft.Reporting.WinForms.ReportParameter("fromDate", fromDate.toString)
    Dim p2 As New Microsoft.Reporting.WinForms.ReportParameter("tilDate",tilDate.toString)
    Dim parms(1) As Microsoft.Reporting.WinForms.ReportParameter
    parms.SetValue(p1, 0)
    parms.SetValue(p2,1)
    Me.ReportViewer1.LocalReport.SetParameters(parms)
    Me.ReportViewer1.RefreshReport()
     


    Good luck!
    DaveL

  • Daniel Cayouette

    I have set the code as above and setup in the report(Report->Report Parameter), FromDate and TilDate, But now error come like this "An attempt was made to set a report parameter 'fromDate' that is not defined in this report".

    Where I am wrong Please Help!
  • Can I show Parameter results in Report
Answer this question