HighTechTalks DotNet Forums  

Display Parameter Results in Report

ASP.net Web Controls microsoft.public.dotnet.framework.aspnet.webcontrols


Discuss Display Parameter Results in Report in the ASP.net Web Controls forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
john
 
Posts: n/a

Default Display Parameter Results in Report - 10-06-2007 , 09:26 AM






Conditions:
Web Control: Report Viewer
The Report.rdlc Dataset query has 2 Date Parameters @Start & @End.
In the Report viewers ObjectDataSource: Configuration, I have them set them
to 2 Textbox controls.

Report works as expected.

What I would like is to have those two Enter Dates Displayed in the Reports
Header itself'.
I have tried setting these parameters in the Report.rdlc Report Parameter
Dialog but do not know how (I assume thru the Expression Builder) to
Reference their Values to those Textboxes on the Report Viewers Form

I have Textboxes in the Header that I Basically want to Display these Two
Entered Dates so the printed(Exported) report Reveals the Reports Date Range

Thanks for any info on how to do this
John



Reply With Quote
  #2  
Old   
Steven Cheng[MSFT]
 
Posts: n/a

Default RE: Display Parameter Results in Report - 10-08-2007 , 02:40 AM






Hi John,

Regarding on the question about mapping the ReportViewrer's LocalReport
parameter to the DataSource's parameter, here are some of my understanding
and suggestion:

**As the documenet mentioend, for Local Report(RDLC ..), reportviewer does
not provide parameter area by default. You will need to use your own
controls(on the page) to accept the parameter values and assign it to
report programmatically. Also, it also mentioned that report parameters can
not be mapped to query parameters since they're used separately and have no
relation to eachother.

#Defining Report Parameters in a ReportViewer Report
http://msdn2.microsoft.com/en-us/lib...85(VS.80).aspx

#Using report parameters in local mode
http://www.gotreportviewer.com/local...ers/index.html


For your case that the parameters are actually of the datasource component,
my suggestion here is that you do not need to care about report parameters.
Just add the TextBoxes onto the page and use them as the parameter source
for the report datasource(object datasource control). Also, since these
TextBoxes are manually added, they're outside of the built-in
reportviewer's toolbar area. I think you may consider set "ShowToolBar"
property of the ReportViewr to "false" so that you can completely provide
the toolbar interface yourself. e.g. You can add code to manually refresh
the report .e.g

=================
protected void Button1_Click(object sender, EventArgs e)
{
ReportViewer1.LocalReport.Refresh();
}
=================

How do you think? Please feel free to let me know if you have any other
ideas or questions here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

==================================================


This posting is provided "AS IS" with no warranties, and confers no rights.







--------------------
Quote:
From: "john" <none (AT) none (DOT) com
Subject: Display Parameter Results in Report
Date: Sat, 6 Oct 2007 09:26:24 -0400


Conditions:
Web Control: Report Viewer
The Report.rdlc Dataset query has 2 Date Parameters @Start & @End.
In the Report viewers ObjectDataSource: Configuration, I have them set
them
to 2 Textbox controls.

Report works as expected.

What I would like is to have those two Enter Dates Displayed in the
Reports
Header itself'.
I have tried setting these parameters in the Report.rdlc Report Parameter
Dialog but do not know how (I assume thru the Expression Builder) to
Reference their Values to those Textboxes on the Report Viewers Form

I have Textboxes in the Header that I Basically want to Display these Two
Entered Dates so the printed(Exported) report Reveals the Reports Date
Range

Thanks for any info on how to do this
John





Reply With Quote
  #3  
Old   
Steven Cheng[MSFT]
 
Posts: n/a

Default RE: Display Parameter Results in Report - 10-10-2007 , 07:11 AM



Hi John,

Have you got any further ideas on this issue or does the suggestion in my
last reply help some? If there is anything else we can help, please feel
free to post here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Quote:
Organization: Microsoft
Date: Mon, 08 Oct 2007 06:40:51 GMT
Subject: RE: Display Parameter Results in Report


Hi John,

Regarding on the question about mapping the ReportViewrer's LocalReport
parameter to the DataSource's parameter, here are some of my understanding
and suggestion:

**As the documenet mentioend, for Local Report(RDLC ..), reportviewer does
not provide parameter area by default. You will need to use your own
controls(on the page) to accept the parameter values and assign it to
report programmatically. Also, it also mentioned that report parameters
can
not be mapped to query parameters since they're used separately and have
no
relation to eachother.

#Defining Report Parameters in a ReportViewer Report
http://msdn2.microsoft.com/en-us/lib...85(VS.80).aspx

#Using report parameters in local mode
http://www.gotreportviewer.com/local...ers/index.html


For your case that the parameters are actually of the datasource
component,
my suggestion here is that you do not need to care about report
parameters.
Just add the TextBoxes onto the page and use them as the parameter source
for the report datasource(object datasource control). Also, since these
TextBoxes are manually added, they're outside of the built-in
reportviewer's toolbar area. I think you may consider set "ShowToolBar"
property of the ReportViewr to "false" so that you can completely provide
the toolbar interface yourself. e.g. You can add code to manually refresh
the report .e.g

=================
protected void Button1_Click(object sender, EventArgs e)
{
ReportViewer1.LocalReport.Refresh();
}
=================

How do you think? Please feel free to let me know if you have any other
ideas or questions here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ault.aspx#noti
f
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

==================================================


This posting is provided "AS IS" with no warranties, and confers no rights.







--------------------
From: "john" <none (AT) none (DOT) com
Subject: Display Parameter Results in Report
Date: Sat, 6 Oct 2007 09:26:24 -0400


Conditions:
Web Control: Report Viewer
The Report.rdlc Dataset query has 2 Date Parameters @Start & @End.
In the Report viewers ObjectDataSource: Configuration, I have them set
them
to 2 Textbox controls.

Report works as expected.

What I would like is to have those two Enter Dates Displayed in the
Reports
Header itself'.
I have tried setting these parameters in the Report.rdlc Report Parameter
Dialog but do not know how (I assume thru the Expression Builder) to
Reference their Values to those Textboxes on the Report Viewers Form

I have Textboxes in the Header that I Basically want to Display these Two
Entered Dates so the printed(Exported) report Reveals the Reports Date
Range

Thanks for any info on how to do this
John







Reply With Quote
  #4  
Old   
john
 
Posts: n/a

Default Re: Display Parameter Results in Report - 10-11-2007 , 02:50 AM



Still Reviewing articles you had links for, will try it out ASAP.
Thanks

"Steven Cheng[MSFT]" <stcheng (AT) online (DOT) microsoft.com> wrote

Quote:
Hi John,

Have you got any further ideas on this issue or does the suggestion in my
last reply help some? If there is anything else we can help, please feel
free to post here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------

Organization: Microsoft
Date: Mon, 08 Oct 2007 06:40:51 GMT
Subject: RE: Display Parameter Results in Report


Hi John,

Regarding on the question about mapping the ReportViewrer's LocalReport
parameter to the DataSource's parameter, here are some of my understanding
and suggestion:

**As the documenet mentioend, for Local Report(RDLC ..), reportviewer does
not provide parameter area by default. You will need to use your own
controls(on the page) to accept the parameter values and assign it to
report programmatically. Also, it also mentioned that report parameters
can
not be mapped to query parameters since they're used separately and have
no
relation to eachother.

#Defining Report Parameters in a ReportViewer Report
http://msdn2.microsoft.com/en-us/lib...85(VS.80).aspx

#Using report parameters in local mode
http://www.gotreportviewer.com/local...ers/index.html


For your case that the parameters are actually of the datasource
component,
my suggestion here is that you do not need to care about report
parameters.
Just add the TextBoxes onto the page and use them as the parameter source
for the report datasource(object datasource control). Also, since these
TextBoxes are manually added, they're outside of the built-in
reportviewer's toolbar area. I think you may consider set "ShowToolBar"
property of the ReportViewr to "false" so that you can completely provide
the toolbar interface yourself. e.g. You can add code to manually refresh
the report .e.g

=================
protected void Button1_Click(object sender, EventArgs e)
{
ReportViewer1.LocalReport.Refresh();
}
=================

How do you think? Please feel free to let me know if you have any other
ideas or questions here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ault.aspx#noti
f
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

==================================================


This posting is provided "AS IS" with no warranties, and confers no
rights.







--------------------
From: "john" <none (AT) none (DOT) com
Subject: Display Parameter Results in Report
Date: Sat, 6 Oct 2007 09:26:24 -0400


Conditions:
Web Control: Report Viewer
The Report.rdlc Dataset query has 2 Date Parameters @Start & @End.
In the Report viewers ObjectDataSource: Configuration, I have them set
them
to 2 Textbox controls.

Report works as expected.

What I would like is to have those two Enter Dates Displayed in the
Reports
Header itself'.
I have tried setting these parameters in the Report.rdlc Report Parameter
Dialog but do not know how (I assume thru the Expression Builder) to
Reference their Values to those Textboxes on the Report Viewers Form

I have Textboxes in the Header that I Basically want to Display these Two
Entered Dates so the printed(Exported) report Reveals the Reports Date
Range

Thanks for any info on how to do this
John









Reply With Quote
  #5  
Old   
Steven Cheng[MSFT]
 
Posts: n/a

Default Re: Display Parameter Results in Report - 10-11-2007 , 11:17 PM



Thanks for your followup John,

welcome to post here if you get any progress.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Quote:
From: "john" <none (AT) none (DOT) com
References: <#DQBAyBCIHA.4476 (AT) TK2MSFTNGP06 (DOT) phx.gbl
tLqH3YXCIHA.4516 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl
<TxgMR5yCIHA.4200 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl>
Quote:
Subject: Re: Display Parameter Results in Report
Date: Thu, 11 Oct 2007 02:50:21 -0400

Still Reviewing articles you had links for, will try it out ASAP.
Thanks

"Steven Cheng[MSFT]" <stcheng (AT) online (DOT) microsoft.com> wrote in message
news:TxgMR5yCIHA.4200 (AT) TK2MSFTNGHUB02 (DOT) phx.gbl...
Hi John,

Have you got any further ideas on this issue or does the suggestion in my
last reply help some? If there is anything else we can help, please feel
free to post here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------

Organization: Microsoft
Date: Mon, 08 Oct 2007 06:40:51 GMT
Subject: RE: Display Parameter Results in Report


Hi John,

Regarding on the question about mapping the ReportViewrer's LocalReport
parameter to the DataSource's parameter, here are some of my
understanding
and suggestion:

**As the documenet mentioend, for Local Report(RDLC ..), reportviewer
does
not provide parameter area by default. You will need to use your own
controls(on the page) to accept the parameter values and assign it to
report programmatically. Also, it also mentioned that report parameters
can
not be mapped to query parameters since they're used separately and have
no
relation to eachother.

#Defining Report Parameters in a ReportViewer Report
http://msdn2.microsoft.com/en-us/lib...85(VS.80).aspx

#Using report parameters in local mode
http://www.gotreportviewer.com/local...ers/index.html


For your case that the parameters are actually of the datasource
component,
my suggestion here is that you do not need to care about report
parameters.
Just add the TextBoxes onto the page and use them as the parameter source
for the report datasource(object datasource control). Also, since these
TextBoxes are manually added, they're outside of the built-in
reportviewer's toolbar area. I think you may consider set "ShowToolBar"
property of the ReportViewr to "false" so that you can completely provide
the toolbar interface yourself. e.g. You can add code to manually refresh
the report .e.g

=================
protected void Button1_Click(object sender, EventArgs e)
{
ReportViewer1.LocalReport.Refresh();
}
=================

How do you think? Please feel free to let me know if you have any other
ideas or questions here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...efault.aspx#no
ti
f
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent
issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each
follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

==================================================


This posting is provided "AS IS" with no warranties, and confers no
rights.







--------------------
From: "john" <none (AT) none (DOT) com
Subject: Display Parameter Results in Report
Date: Sat, 6 Oct 2007 09:26:24 -0400


Conditions:
Web Control: Report Viewer
The Report.rdlc Dataset query has 2 Date Parameters @Start & @End.
In the Report viewers ObjectDataSource: Configuration, I have them set
them
to 2 Textbox controls.

Report works as expected.

What I would like is to have those two Enter Dates Displayed in the
Reports
Header itself'.
I have tried setting these parameters in the Report.rdlc Report
Parameter
Dialog but do not know how (I assume thru the Expression Builder) to
Reference their Values to those Textboxes on the Report Viewers Form

I have Textboxes in the Header that I Basically want to Display these
Two
Entered Dates so the printed(Exported) report Reveals the Reports Date
Range

Thanks for any info on how to do this
John











Reply With Quote
  #6  
Old   
Quinncd
 
Posts: n/a

Default RE: Display Parameter Results in Report - 10-31-2007 , 10:45 AM



I had the same issue. I am using the business object(BO) method as a
datasource for my local report
(http://msdn2.microsoft.com/en-us/lib...2(VS.80).aspx). An issue
with this method, however, is that the directions state that your business
object should then appear in the report designer view as a web datasource
after compilation. For me,it didn't so I manually created a datatable. I
added the parameters as properties of my business object as well as columns
to the datatable (the names of the columns and of the properties should
match). The newly added columns should now show in the website datasource
view. You can then drag the properties onto your report, but you'll need to
use the First() function =(First(Fields!Date.Value)) since your parameter
values are added to the datatable for each row. HTH.

"john" wrote:

Quote:
Conditions:
Web Control: Report Viewer
The Report.rdlc Dataset query has 2 Date Parameters @Start & @End.
In the Report viewers ObjectDataSource: Configuration, I have them set them
to 2 Textbox controls.

Report works as expected.

What I would like is to have those two Enter Dates Displayed in the Reports
Header itself'.
I have tried setting these parameters in the Report.rdlc Report Parameter
Dialog but do not know how (I assume thru the Expression Builder) to
Reference their Values to those Textboxes on the Report Viewers Form

I have Textboxes in the Header that I Basically want to Display these Two
Entered Dates so the printed(Exported) report Reveals the Reports Date Range

Thanks for any info on how to do this
John




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.