Print Name (field from dataset) On Every Page (Page Header)

Hello,

I am using the ReportViewer control and Client-Side Processing to display a Training Report that works great.

However, I need find a way to have one of the fields of my dataset display on every page of the report (Page Header).

I receive this message "The Value expression for the textbox FName refers to a field. Fields cannot be used in page headers or footers".

Is there a way to get this field to appear on every page of the report (preferably at the top).

Thanks for any help that you can provide me.

This is easy all what you need to to is to add ne parameters which get his value from your dataset fileds and then use this parameters in your page header or footer read this turtorial it will help you

http://technet.microsoft.com/en-us/library/bb508810.aspx

read the section titled " Assigning report parameter values using consolidated fields "

|||

hey

I told the answerin different post ( http://forums.asp.net/t/1160246.aspx ), but repeat it for you

you should define a Parameter for your report from Layout section ,then ( right click insome empty place in outeside of your report table, you'll see a context menu with 4 Items , select the Report Parameter) ,then create a Textbox inside your Header or Footer , then rightclick onthe textbox and and select Expression , then put the followingcode in it .

=Parameters!ReportFooterParameterName.Value

goodluck ,|||

I appreciate the help. I am not quite sure what to do when setting up the Report Parameters to fill this textboxt with the field from my dataset. Would you mind giving me a little guidance in this area?

I am getting the message A Value expression used for the report parameter 'Name' refers to a field. Fields cannot be used in report parameter expressions.

Thanks again!

|||

ok ,

let me describe it for you

there is 2 different type of value in reporting server ,

1 ) the filed that you provide by DataBase that will display like Filelds!DBFiledName.Value

2 ) the filed that you provide by getting information fromuser or from yourexisting Query this type of values called Parameters and will display asParameters!ReportFooterParameterName.Value

when you want to show oneparameter inHeader orFooter ,you can't useFields it means all the textbox that you put in header / footer , shouldcomplete byParameters ,

for sending parameters to header or footer , you have2 option ,

Take it FromUser or programmatically fill the Parameter , in commonly uses , we set the parameters Programatically , like

@.myParameter = "hello world!"

when I use the myParameter in Header, itwill display thehello world! ,

but if youuse the Fields inHeader or Footer it cousean error thatyou taken it .

for sending a parameter to your header , pleaseread the post above ,

Thank you , 7 Goodluck

Print event in ReportViewer?

Hi All,

How can I use the Print event of ReportViewer control in my web application? I am trying to print a server report automatically so that the user does not have to click on the Print button in the tool bar of the report viewer.

I came across one article that talks about the Print event -

http://msdn2.microsoft.com/en-us/library/ms318531.aspx

But I could not find it in VS2005 version that I am using.

Please let me know if there is a method to print the report automatically other than exporting it to some file and printing it from there.

Any help will be greatly appreciated!!!

I am trying Using System.Drawing.Printing, but failed!

Anyone help me!

|||

You only get the Print event in the WinForms version of the ReportViewer control, not in the WebForms version. Perhaps you are in a web-app?

Take a look at the sample printer delivery extension that ships with the product: It will allow you to send a report to a printer without even first viewing it (although you could view it, too, if you wanted to...)

http://msdn2.microsoft.com/en-us/library/ms160778.aspx

sql

Print event in ReportViewer?

Hi All,

How can I use the Print event of ReportViewer control in my web application? I am trying to print a server report automatically so that the user does not have to click on the Print button in the tool bar of the report viewer.

I came across one article that talks about the Print event -

http://msdn2.microsoft.com/en-us/library/ms318531.aspx

But I could not find it in VS2005 version that I am using.

Please let me know if there is a method to print the report automatically other than exporting it to some file and printing it from there.

Any help will be greatly appreciated!!!

I am trying Using System.Drawing.Printing, but failed!

Anyone help me!

|||

You only get the Print event in the WinForms version of the ReportViewer control, not in the WebForms version. Perhaps you are in a web-app?

Take a look at the sample printer delivery extension that ships with the product: It will allow you to send a report to a printer without even first viewing it (although you could view it, too, if you wanted to...)

http://msdn2.microsoft.com/en-us/library/ms160778.aspx

Print control stops working

I have a few reports that suddenly stopped printing.

Nothing changed on the report server, and one minute they could print, the other they couldn't

I have one report that is 4 pages in preview and six when it prints. The users press the print control on the web page and the print dialog comes up, they select a printer and the printing messagebox comes up. Then it will print a couple of pages VERY SLOWLY... and eventually will hang at the 3rd page.

IT appears it is just spooling in the printer control viewer...

Other similiar reports that use the same query but a different parameter, work just fine.

I have rebuilt and redployed the report. The problem is happening on both my live and test environments.

I have looked through this forum but not found an answer. I did delete and re-isntall the client print control.

I have turned the client logging on. But no errrors show up anywhere.

I am running ssrs 2005 on both machines. test machine has win2003 sp1 , sql 2005 sp2 AND hotfix's

live machine has win2003 and sql 2000 latest sp.

I need help!

TIA

Daryl

bump|||

Does anyone have a clue as to why this is happening?

I have seen this problem posed as different quesitons all over the place, but, no answers.

sql

Print control stops working

I have a few reports that suddenly stopped printing.

Nothing changed on the report server, and one minute they could print, the other they couldn't

I have one report that is 4 pages in preview and six when it prints. The users press the print control on the web page and the print dialog comes up, they select a printer and the printing messagebox comes up. Then it will print a couple of pages VERY SLOWLY... and eventually will hang at the 3rd page.

IT appears it is just spooling in the printer control viewer...

Other similiar reports that use the same query but a different parameter, work just fine.

I have rebuilt and redployed the report. The problem is happening on both my live and test environments.

I have looked through this forum but not found an answer. I did delete and re-isntall the client print control.

I have turned the client logging on. But no errrors show up anywhere.

I am running ssrs 2005 on both machines. test machine has win2003 sp1 , sql 2005 sp2 AND hotfix's

live machine has win2003 and sql 2000 latest sp.

I need help!

TIA

Daryl

bump|||

Does anyone have a clue as to why this is happening?

I have seen this problem posed as different quesitons all over the place, but, no answers.

Print Control

Hi guys
The Print control - printing directly from the Report Manager - have a
default setting. Is there a way to change this default setting'
Our problem is that the default is 5*8 letter format whereas here we use A4
format. Preferable it would pickup the report format in regards to portrait
or landscape.
Thanks.
Regards
JonasIt should pick this up. Check and see what your page layout size is.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
news:CB2C2B3D-CAD3-4565-AB2F-8E134D8D0243@.microsoft.com...
> Hi guys
> The Print control - printing directly from the Report Manager - have a
> default setting. Is there a way to change this default setting'
> Our problem is that the default is 5*8 letter format whereas here we use
> A4
> format. Preferable it would pickup the report format in regards to
> portrait
> or landscape.
> Thanks.
> Regards
> Jonas|||I have a report that have this:
<PageHeight>29.7cm</PageHeight>
<PageWidth>42cm</PageWidth>
Which matches A3 landscape but ends up as 8,5 by 11". This report does have
page header and footer does that matter?
I must admit that it does pickup A3 & A4 formats on some other reports.
Thanks.
Regards
Jonas
"Bruce L-C [MVP]" wrote:
> It should pick this up. Check and see what your page layout size is.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
> news:CB2C2B3D-CAD3-4565-AB2F-8E134D8D0243@.microsoft.com...
> > Hi guys
> >
> > The Print control - printing directly from the Report Manager - have a
> > default setting. Is there a way to change this default setting'
> >
> > Our problem is that the default is 5*8 letter format whereas here we use
> > A4
> > format. Preferable it would pickup the report format in regards to
> > portrait
> > or landscape.
> >
> > Thanks.
> >
> > Regards
> > Jonas
>
>|||Weird, it picks it up for some but not all. All I can suggest is to see if
there is anything different between the reports that work and those that
doesn't.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
news:33FEE50C-2C84-41D9-A23E-998C30BCDB10@.microsoft.com...
>I have a report that have this:
> <PageHeight>29.7cm</PageHeight>
> <PageWidth>42cm</PageWidth>
> Which matches A3 landscape but ends up as 8,5 by 11". This report does
> have
> page header and footer does that matter?
> I must admit that it does pickup A3 & A4 formats on some other reports.
> Thanks.
> Regards
> Jonas
> "Bruce L-C [MVP]" wrote:
>> It should pick this up. Check and see what your page layout size is.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
>> news:CB2C2B3D-CAD3-4565-AB2F-8E134D8D0243@.microsoft.com...
>> > Hi guys
>> >
>> > The Print control - printing directly from the Report Manager - have a
>> > default setting. Is there a way to change this default setting'
>> >
>> > Our problem is that the default is 5*8 letter format whereas here we
>> > use
>> > A4
>> > format. Preferable it would pickup the report format in regards to
>> > portrait
>> > or landscape.
>> >
>> > Thanks.
>> >
>> > Regards
>> > Jonas
>>

Print button not showing in Firefox -- ReportViewer control

Hi, I'm having a problem with the ReportViewer control (Reporting Service 2005) in Firefox. Neither the print button nor the Search box are showing up, even when I explicitly set them to be visible. They are showing up fine in IE.

Anyone else had this problem?

When you look at the HTML source, it's clear why it is not showing up. The following code does not even appear in the Firefox version (most important part in bold):

<table cellpadding="0" cellspacing="0" ToolbarSpacer="true" style="display:inline;">
<tr>
<td style="width:20px;"></td>
</tr>
</table>

<div id="RptView_ctl01_ctl07" style="display:inline;font-family:Verdana;font-size:8pt;height:30px;">
<table cellpadding="0" cellspacing="0" style="display:inline;">
<tr>
<td height="28px"><div id="RptView_ctl01_ctl07_ctl00">
<table id="RptView_ctl01_ctl07_ctl00_ctl00" onmouseover="HoverImageRptView_ctl01_ctl07_ctl00_ctl00.OnHover();" onmouseout="HoverImageRptView_ctl01_ctl07_ctl00_ctl00.OnNormal();" title="Print" style="display:none;">
<tr>
<td><input type="image" name="RptView$ctl01$ctl07$ctl00$ctl00$ctl00" src="http://pics.10026.com/?src=/MandateMaker/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=8.0.50727.42&Name=Icons.Print.gif"onclick="ClientToolbarRptView_ctl01.LoadPrintControl();return false;" style="height:16px;width:16px;border-width:0px;padding:2px;" /></td>
</tr>
</table><script>
HoverImageRptView_ctl01_ctl07_ctl00_ctl00.OnNormal();
</script><table id="RptView_ctl01_ctl07_ctl00_ctl01" onmouseout="HoverImageRptView_ctl01_ctl07_ctl00_ctl01.OnNormal();" title="Print" style="display:inline;">
<tr>
<td><img src="http://pics.10026.com/?src=/MandateMaker/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=8.0.50727.42&Name=Icons.Print.gif" alt="Print" style="border-width:0px;" /></td>
</tr>
</table><script>
HoverImageRptView_ctl01_ctl07_ctl00_ctl01.OnNormal();
</script>
</div></td>
</tr>
</table>
</div>

<iframe id="PrintFrameRptView_ctl01_ctl07" src="http://pics.10026.com/?src=javascript:''" style="display:none;"></iframe>

Is the "print control" IE-only?

|||I believe that the print controler is an active x controler and that firefox does not suport active x. so yeah the print control would appear to be IE only. however you might be able to find a plugin for firefox that would allow you to run active x|||

Actually, the Microsoft documentation says certain things do not work in non-IE browsers, but the print button is not one of them.

Honest to God, I think Microsoft is just lazy or arrogant sometimes. It's not THAT hard to get printing from a non-IE browser to work. I was able to do it when I had my own custom page to display Reporting Service reports. If I can do it, surely the well-paid gurus at Microsoft can do it!

Grrrrr....I may have to put in code to generate my old custom stuff for non-IE browsers. My custom page does not work as well as the Report Viewer control, so I really would rather not do that.

|||Yeah, it's because they implemented it as an ActiveX control, which is totally the wrong direction to be heading. Microsoft should be moving away from ActiveX since other browsers don't support it (although I think there is a plug-in that allows Firefox to use at least some ActiveX controls). Plus it is a major focal point for security exploits and bugs, it would be better if it was removed from the browser environment entirely.

cs|||

CynthiaD wrote:

Actually, the Microsoft documentation says certain things do not work in non-IE browsers, but the print button is not one of them.

Honest to God, I think Microsoft is just lazy or arrogant sometimes. It's not THAT hard to get printing from a non-IE browser to work. I was able to do it when I had my own custom page to display Reporting Service reports. If I can do it, surely the well-paid gurus at Microsoft can do it!

Grrrrr....I may have to put in code to generate my old custom stuff for non-IE browsers. My custom page does not work as well as the Report Viewer control, so I really would rather not do that.

Hi Cynthia - I know what you are feeling. I moved over most of my clients to LGX Report (www.logixml) because of that issue and similar ones. For most of my clients IE only is not a solution that works. The Logi product is zero footprint and integrates easily with ASP.NET applications. It's also free, but I have one client who needed more features available on their paid version.

Good luck

Steve

|||

Hi,

In my case the print icon is not displayed in the report viewer viewed through the IE.(in the client server)

But able to see the same in our local network

|||Probably security. You are probably allowed to use ActiveX controls in a trusted site (your network), but outside of that the security restrictions prevent using ActiveX controls. If they add your site to the trusted sites in the IE security area, they will likely be able to see the print button. Just my hunch.

cssql

Print Button - ActiveX Installation

Hello,
How can I deploy the ActiveX to the workstations?
The users don't have administrative privileges, I want to install the active
X control before they click the print button.
Is there a way to download the files of instalation and run some setup?
ThanksRS doesn't supply any mechanism for doing this. What you could do is look
for the rsclientprint.cab file and extract its information. Then copy it to
the users "WINDOWS\Downloaded Program Files" folder. This should allow the
users the ability to use the control without downloading it. Of course you
would need to do all the maintenance for updating the control if it every
changes.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Armand Charles" <armand.charles@.tty.com.br> wrote in message
news:eCG$imXAGHA.2320@.TK2MSFTNGP11.phx.gbl...
> Hello,
> How can I deploy the ActiveX to the workstations?
> The users don't have administrative privileges, I want to install the
> active X control before they click the print button.
> Is there a way to download the files of instalation and run some setup?
> Thanks
>|||Hi Daniel
I can't copy the extract files of rsclientprint.cab to "WINDOWS\Downloaded
Program Files", it doesn't work. This folder looks as read only.
Thank you for your response,
Armand
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> escreveu na mensagem
news:uGHFVdaAGHA.1312@.TK2MSFTNGP09.phx.gbl...
> RS doesn't supply any mechanism for doing this. What you could do is look
> for the rsclientprint.cab file and extract its information. Then copy it
> to the users "WINDOWS\Downloaded Program Files" folder. This should allow
> the users the ability to use the control without downloading it. Of
> course you would need to do all the maintenance for updating the control
> if it every changes.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Armand Charles" <armand.charles@.tty.com.br> wrote in message
> news:eCG$imXAGHA.2320@.TK2MSFTNGP11.phx.gbl...
>> Hello,
>> How can I deploy the ActiveX to the workstations?
>> The users don't have administrative privileges, I want to install the
>> active X control before they click the print button.
>> Is there a way to download the files of instalation and run some setup?
>> Thanks
>|||You can do it, you just need to do it via the command line.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Armand Charles" <armand.charles@.tty.com.br> wrote in message
news:%23RDSW1MBGHA.2320@.TK2MSFTNGP11.phx.gbl...
> Hi Daniel
> I can't copy the extract files of rsclientprint.cab to "WINDOWS\Downloaded
> Program Files", it doesn't work. This folder looks as read only.
> Thank you for your response,
> Armand
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> escreveu na mensagem
> news:uGHFVdaAGHA.1312@.TK2MSFTNGP09.phx.gbl...
>> RS doesn't supply any mechanism for doing this. What you could do is
>> look for the rsclientprint.cab file and extract its information. Then
>> copy it to the users "WINDOWS\Downloaded Program Files" folder. This
>> should allow the users the ability to use the control without downloading
>> it. Of course you would need to do all the maintenance for updating the
>> control if it every changes.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Armand Charles" <armand.charles@.tty.com.br> wrote in message
>> news:eCG$imXAGHA.2320@.TK2MSFTNGP11.phx.gbl...
>> Hello,
>> How can I deploy the ActiveX to the workstations?
>> The users don't have administrative privileges, I want to install the
>> active X control before they click the print button.
>> Is there a way to download the files of instalation and run some setup?
>> Thanks
>>
>|||Would you please tell me what have I missed? I already copied the files to
"WINDOWS\Downloaded Program Files" folder. It still asks me to intall
Reporting Services when I click the PRINT button.
Thanks,
Anna
"Daniel Reib [MSFT]" wrote:
> You can do it, you just need to do it via the command line.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Armand Charles" <armand.charles@.tty.com.br> wrote in message
> news:%23RDSW1MBGHA.2320@.TK2MSFTNGP11.phx.gbl...
> > Hi Daniel
> >
> > I can't copy the extract files of rsclientprint.cab to "WINDOWS\Downloaded
> > Program Files", it doesn't work. This folder looks as read only.
> >
> > Thank you for your response,
> >
> > Armand
> >
> > "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> escreveu na mensagem
> > news:uGHFVdaAGHA.1312@.TK2MSFTNGP09.phx.gbl...
> >> RS doesn't supply any mechanism for doing this. What you could do is
> >> look for the rsclientprint.cab file and extract its information. Then
> >> copy it to the users "WINDOWS\Downloaded Program Files" folder. This
> >> should allow the users the ability to use the control without downloading
> >> it. Of course you would need to do all the maintenance for updating the
> >> control if it every changes.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Armand Charles" <armand.charles@.tty.com.br> wrote in message
> >> news:eCG$imXAGHA.2320@.TK2MSFTNGP11.phx.gbl...
> >> Hello,
> >>
> >> How can I deploy the ActiveX to the workstations?
> >> The users don't have administrative privileges, I want to install the
> >> active X control before they click the print button.
> >> Is there a way to download the files of instalation and run some setup?
> >>
> >> Thanks
> >>
> >>
> >>
> >
> >
>
>|||I got the same problem too. I was using WinInstall and found that it got lots of registry entries. Do anyone know how to deploy it.
From http://www.developmentnow.com/g/115_2005_12_0_0_679249/Print-Button--ActiveX-Installation.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Print Barcodes with the Active X print control

We are having problems printing Reports (when printing by clicking on the AcitiveX print control), where the font for the fields are set to "C39HrP24DhTt" (barcode).

While viewing the report it displays as Barcodes but while printing, the Barcode does not get printed, but the string gets printed.

Environment: SSRS 2005

Using the ReportViewer Control in a .Net 2.0 Web App to render the reports.

BarCodes print fine in the following situations:

1. When the Report is exported to Excel and when printed from there

2. When you click on the print button on Internet Explorer

3. When saving as html (from view source) and opening that html document and printing.

BarCodes do NOT get printed in the following situation:

1. When printing by clicking on the "Print" (Active X Control) icon. Even the "Print Preview" does not show the Barcode.

We figured the problem. Here is the solution.

Unlike other printing which happens on the client side, with the Active X print control provided with SSRS, it creates an image of what needs to be printed on the server side and then issues the print command, and the processed image is sent from the client side. So, for the special fonts like barcode to work correctly we have to have it on the client machine (for viewing) and also on the report servers (for printing through the active X print control) .

1. Install the font on the Reporting Services machine using the following steps:

a. Open the C:\winnt\fonts folder directly on the machine. (Do not use a file share to do this operation)

b. Drag and drop the font you want to install into this folder.

c. Do an IISRESET from a command prompt to make sure the font will get loaded correctly when a user views a report.

sql

Print Barcodes with the Active X print control

We are having problems printing Reports (when printing by clicking on the AcitiveX print control), where the font for the fields are set to "C39HrP24DhTt" (barcode).

While viewing the report it displays as Barcodes but while printing, the Barcode does not get printed, but the string gets printed.

Environment: SSRS 2005

Using the ReportViewer Control in a .Net 2.0 Web App to render the reports.

BarCodes print fine in the following situations:

1. When the Report is exported to Excel and when printed from there

2. When you click on the print button on Internet Explorer

3. When saving as html (from view source) and opening that html document and printing.

BarCodes do NOT get printed in the following situation:

1. When printing by clicking on the "Print" (Active X Control) icon. Even the "Print Preview" does not show the Barcode.

We figured the problem. Here is the solution.

Unlike other printing which happens on the client side, with the Active X print control provided with SSRS, it creates an image of what needs to be printed on the server side and then issues the print command, and the processed image is sent from the client side. So, for the special fonts like barcode to work correctly we have to have it on the client machine (for viewing) and also on the report servers (for printing through the active X print control) .

1. Install the font on the Reporting Services machine using the following steps:

a. Open the C:\winnt\fonts folder directly on the machine. (Do not use a file share to do this operation)

b. Drag and drop the font you want to install into this folder.

c. Do an IISRESET from a command prompt to make sure the font will get loaded correctly when a user views a report.

Primary Key

Hi,
I'm looking for a way to make a primary key control in a int column (in othe
r words the app will manage the primary key value).
What's the best way to make that in SQL Server 2005? Most important, there's
a patter that allow many DB systems (like Oracle, DB2,
Firebird...)?
Thanks
MaxIf you're doing it from CLR code, consider using SMO.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Max Andr Bndchen" <nospam@.microsoft.com> wrote in message
news:utIrWfrPGHA.312@.TK2MSFTNGP12.phx.gbl...
Hi,
I'm looking for a way to make a primary key control in a int column (in
other words the app will manage the primary key value).
What's the best way to make that in SQL Server 2005? Most important, there's
a patter that allow many DB systems (like Oracle, DB2,
Firebird...)?
Thanks
Max|||> I'm looking for a way to make a primary key control in a int column (in
> other words the app will manage the primary key value).
If the application will manage (calculate and populate?) the key values,
then all you must do is add the int column and then add the primary key
constraint.

> Most important, there's a patter that allow many DB systems (like Oracle,
> DB2, Firebird...)?
Could you clarify the above question?
"Max Andr Bndchen" <nospam@.microsoft.com> wrote in message
news:utIrWfrPGHA.312@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm looking for a way to make a primary key control in a int column (in
> other words the app will manage the primary key value).
> What's the best way to make that in SQL Server 2005? Most important,
> there's a patter that allow many DB systems (like Oracle, DB2,
> Firebird...)?
> Thanks
> Max
>