Print Date and Time

I am currently using the global execution time in my reports, but I would
also like to show the user what time they view the report. I guess in
Crystal they distinguish between the two as "Data Date" which would be the
execution time and then "Print Date" which is the date and time the report
is viewed. Does any one know if there a way to show this is RS?
Thanks,
LisaPlease review .Net's DateTime functionality (Search on DateTime in MSDN).
In your case your could place, in a textbox, an expression like
=DateTime.Now.
You could also use the Now() function.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
news:OnOBSRDZEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I am currently using the global execution time in my reports, but I would
> also like to show the user what time they view the report. I guess in
> Crystal they distinguish between the two as "Data Date" which would be the
> execution time and then "Print Date" which is the date and time the report
> is viewed. Does any one know if there a way to show this is RS?
> Thanks,
> Lisa
>|||Thank you!
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:O%23oBowEZEHA.712@.TK2MSFTNGP11.phx.gbl...
> Please review .Net's DateTime functionality (Search on DateTime in MSDN).
> In your case your could place, in a textbox, an expression like
> =DateTime.Now.
> You could also use the Now() function.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
> news:OnOBSRDZEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > I am currently using the global execution time in my reports, but I
would
> > also like to show the user what time they view the report. I guess in
> > Crystal they distinguish between the two as "Data Date" which would be
the
> > execution time and then "Print Date" which is the date and time the
report
> > is viewed. Does any one know if there a way to show this is RS?
> >
> > Thanks,
> >
> > Lisa
> >
> >
>|||You can try =now().
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
news:OnOBSRDZEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I am currently using the global execution time in my reports, but I would
> also like to show the user what time they view the report. I guess in
> Crystal they distinguish between the two as "Data Date" which would be the
> execution time and then "Print Date" which is the date and time the report
> is viewed. Does any one know if there a way to show this is RS?
> Thanks,
> Lisa
>

Print data from an ASP.NET ReportViewer that contains multiple pages from FireFox?

Hi,

I have this application in which I am using a number of reports containing one or more pages. When using IE as explorer, the printing button is be?ng displayed properly. When clicking that button, everything works as it should. But when using Firefox as browser, the print button doesn't show up. So I thought about going to the menu of the browser and choose File > Print. The result looks just like a printscreen and when the report contains multiple pages, I am not able to print them in a decent way.

On the internet I read the main reason for this is that Firefox does not work with ActiveX-Objects. In this way it would not be possible to print out the pages!

Can anyone help me out?

Thx a lot!

Recloose!

Anyone?

Print custom page in asp.net

How could i print a custom page (8.5in X 5.5in) in asp.net 2.0 ?

If you are using ssrs to do the report you can set the margin size by right clicking on the gray area of the body of your report this will bring up properties click on the layout tab you can set the size of your report here.

Please mark as answered if this helps you

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 command Not Working For Database Client

Hello,

The PRINT command works fine on Query Analyzer.
However, when I used it with other Database Client,
eg: Aqua Data Studio, nothing got printed out.

Is there a way to make it work?

Thanks in advance.ehchn1@.hotmail.com (James) wrote in message news:<46fb4b22.0405272205.4e2e0bd4@.posting.google.com>...
> Hello,
> The PRINT command works fine on Query Analyzer.
> However, when I used it with other Database Client,
> eg: Aqua Data Studio, nothing got printed out.
> Is there a way to make it work?
>
> Thanks in advance.

I don't know anything about Aqua Data Studio, but the client has to
handle the PRINT output correctly - see "Using PRINT" in Books Online
for more details. The message is returned as an error, so perhaps Aqua
is treating it as an error, and doing something else with it. But you
should probably ask whoever makes the product.

Simon|||[posted and mailed, please reply in news]

James (ehchn1@.hotmail.com) writes:
> The PRINT command works fine on Query Analyzer.
> However, when I used it with other Database Client,
> eg: Aqua Data Studio, nothing got printed out.
> Is there a way to make it work?

Just like Simon, I have never heard of Aqua Data Studio before, but
a quick search on the net indicates that this is some of sort of
multi-platform Query Analyzer. If that sort of tool does not handle
PRINT correctly, this is a big defeciency, and you should raise an
issue with the vendor.

It could be, however, that the problem is in the JDBC driver, so trying
another driver could be worth a try. Then again, Aquafold says on
http://www.aquafold.com/docs-jdbcdrivers.html: "Microsoft SQL Server JDBC
Drivers - The SQL Server JDBC drivers included with ADS work across all
versions of SQL Server. There is no need to change or update this driver."

So you should probably talk to the vendor in this case too.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||
Erland Sommarskog wrote:

> [posted and mailed, please reply in news]
> James (ehchn1@.hotmail.com) writes:
>>The PRINT command works fine on Query Analyzer.
>>However, when I used it with other Database Client,
>>eg: Aqua Data Studio, nothing got printed out.
>>
>>Is there a way to make it work?
> Just like Simon, I have never heard of Aqua Data Studio before, but
> a quick search on the net indicates that this is some of sort of
> multi-platform Query Analyzer. If that sort of tool does not handle
> PRINT correctly, this is a big defeciency, and you should raise an
> issue with the vendor.
> It could be, however, that the problem is in the JDBC driver, so trying
> another driver could be worth a try. Then again, Aquafold says on
> http://www.aquafold.com/docs-jdbcdrivers.html: "Microsoft SQL Server JDBC
> Drivers - The SQL Server JDBC drivers included with ADS work across all
> versions of SQL Server. There is no need to change or update this driver."
> So you should probably talk to the vendor in this case too.

If the product uses JDBC, it is likely that the PRINT output will
be available to the JDBC driver via the Connection and Statement
getWarnings() call. You may get quicker turnarouond from the product
vendor if you include this fact.
Joe Weinstein at BEA