Hi,
I got a report with page Width 11.6 and Height 8.2 and Body Width 11.1 and
all margins are 0.25.
I want to print it in A4 landscape format. Unfortunately if I set for
default printer HP Desk Jet printer it prints as A4/Landscape correctly, but
if I set for default printer any HP LaserJet printer it tries to print in
Letter/Landscape format and of course it prints empty pages after every page.
I use direct print, SQL2005 Reports
Is there a way to set the printer page Letter or A4? Or to set up all
reports to print at A4 not Letter format?
ThanksHi Ivailo,
it seems that standard settings to printers are to be configured via Control
Panel/Printers and Faxes/<your printer>/Printing Preferences
And this to be repeated for each and any printer.
Saludos, Henrique
Showing posts with label format. Show all posts
Showing posts with label format. Show all posts
Sunday, March 25, 2012
A4 printing
Hi,
I have problems with A4 printing from the RSClientPrint activex.
I defined the size of my report to 21cm x 29,7cm (the A4 format) but
when printing the printer is set on a "personalized paper" format
instead of "A4" format.
So the user need to specify the A4 format each time he need to print a
report.
When I set the format to 8,5in x 11.5in the format is correctly
detected by the printer as a "letter(8,5"x11")". So if it's possible to
make understand to the printer that the format is "letter" it could be
possible to make it understand the A4 format, but I don't see how.
For me it's the last thing I need to make Reporting Services a valid
end user reporting tool.
I try this on several printers with several reports and they all do the
same thing.
Thanks for your responses.I don't think there is really much you can do here. The ActiveX control
passes the report sizes to the printer and let's the printer driver
determine what to do with these values. For some reason the driver is not
matching the values up with the A4 paper size, but it does for 8.5 X 11.
Does it work for other paper sizes, like legal, or 11 x 17?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sébastien Guillot" <s.guillot@.gmail.com> wrote in message
news:1126536856.799335.33940@.z14g2000cwz.googlegroups.com...
> Hi,
> I have problems with A4 printing from the RSClientPrint activex.
> I defined the size of my report to 21cm x 29,7cm (the A4 format) but
> when printing the printer is set on a "personalized paper" format
> instead of "A4" format.
> So the user need to specify the A4 format each time he need to print a
> report.
> When I set the format to 8,5in x 11.5in the format is correctly
> detected by the printer as a "letter(8,5"x11")". So if it's possible to
> make understand to the printer that the format is "letter" it could be
> possible to make it understand the A4 format, but I don't see how.
> For me it's the last thing I need to make Reporting Services a valid
> end user reporting tool.
> I try this on several printers with several reports and they all do the
> same thing.
> Thanks for your responses.
>|||Thanks for your response.
I tried 8.5 x 11, it takes me Legal (8,5" x 14"),
11"x17" -> Personalized paper format
8.5"x14" -> Personalized paper format
21cm x 29.7cm -> Personalized paper format
210mm x 297mm -> Personalized paper format
As you said it depend on how the printer interpret the values.
This problem appears most of time on multifunctionnal laser printers
how can receive multiple paper formats. On inkjet printer with only A4
paper it works better.
But, I think it's possible to make understand to the printer the right
format. All the rest of applications like Word, Excel,... managed to do
this so there's no good reason for the activex to not managed to do
this.
I see while searching answers thru several forums and newsgroup that
this problem occurs to a number a person all over the world.
So, it could be usefull to have a clear answer on how we need to set
page heigth and width for the A4 format.
(Sorry for my poor english, I tried to be as clear as possible)|||Yes, it would have been possible to do paper size detection in the print
control code. We sampled several printers and each printer handled
different paper sizes correctly. We have however noted the response from
customers regarding this issue and will consider adding it in a future
release.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sébastien Guillot" <s.guillot@.gmail.com> wrote in message
news:1126594138.934122.74600@.f14g2000cwb.googlegroups.com...
> Thanks for your response.
> I tried 8.5 x 11, it takes me Legal (8,5" x 14"),
> 11"x17" -> Personalized paper format
> 8.5"x14" -> Personalized paper format
> 21cm x 29.7cm -> Personalized paper format
> 210mm x 297mm -> Personalized paper format
>
> As you said it depend on how the printer interpret the values.
> This problem appears most of time on multifunctionnal laser printers
> how can receive multiple paper formats. On inkjet printer with only A4
> paper it works better.
> But, I think it's possible to make understand to the printer the right
> format. All the rest of applications like Word, Excel,... managed to do
> this so there's no good reason for the activex to not managed to do
> this.
> I see while searching answers thru several forums and newsgroup that
> this problem occurs to a number a person all over the world.
> So, it could be usefull to have a clear answer on how we need to set
> page heigth and width for the A4 format.
> (Sorry for my poor english, I tried to be as clear as possible)
>
I have problems with A4 printing from the RSClientPrint activex.
I defined the size of my report to 21cm x 29,7cm (the A4 format) but
when printing the printer is set on a "personalized paper" format
instead of "A4" format.
So the user need to specify the A4 format each time he need to print a
report.
When I set the format to 8,5in x 11.5in the format is correctly
detected by the printer as a "letter(8,5"x11")". So if it's possible to
make understand to the printer that the format is "letter" it could be
possible to make it understand the A4 format, but I don't see how.
For me it's the last thing I need to make Reporting Services a valid
end user reporting tool.
I try this on several printers with several reports and they all do the
same thing.
Thanks for your responses.I don't think there is really much you can do here. The ActiveX control
passes the report sizes to the printer and let's the printer driver
determine what to do with these values. For some reason the driver is not
matching the values up with the A4 paper size, but it does for 8.5 X 11.
Does it work for other paper sizes, like legal, or 11 x 17?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sébastien Guillot" <s.guillot@.gmail.com> wrote in message
news:1126536856.799335.33940@.z14g2000cwz.googlegroups.com...
> Hi,
> I have problems with A4 printing from the RSClientPrint activex.
> I defined the size of my report to 21cm x 29,7cm (the A4 format) but
> when printing the printer is set on a "personalized paper" format
> instead of "A4" format.
> So the user need to specify the A4 format each time he need to print a
> report.
> When I set the format to 8,5in x 11.5in the format is correctly
> detected by the printer as a "letter(8,5"x11")". So if it's possible to
> make understand to the printer that the format is "letter" it could be
> possible to make it understand the A4 format, but I don't see how.
> For me it's the last thing I need to make Reporting Services a valid
> end user reporting tool.
> I try this on several printers with several reports and they all do the
> same thing.
> Thanks for your responses.
>|||Thanks for your response.
I tried 8.5 x 11, it takes me Legal (8,5" x 14"),
11"x17" -> Personalized paper format
8.5"x14" -> Personalized paper format
21cm x 29.7cm -> Personalized paper format
210mm x 297mm -> Personalized paper format
As you said it depend on how the printer interpret the values.
This problem appears most of time on multifunctionnal laser printers
how can receive multiple paper formats. On inkjet printer with only A4
paper it works better.
But, I think it's possible to make understand to the printer the right
format. All the rest of applications like Word, Excel,... managed to do
this so there's no good reason for the activex to not managed to do
this.
I see while searching answers thru several forums and newsgroup that
this problem occurs to a number a person all over the world.
So, it could be usefull to have a clear answer on how we need to set
page heigth and width for the A4 format.
(Sorry for my poor english, I tried to be as clear as possible)|||Yes, it would have been possible to do paper size detection in the print
control code. We sampled several printers and each printer handled
different paper sizes correctly. We have however noted the response from
customers regarding this issue and will consider adding it in a future
release.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sébastien Guillot" <s.guillot@.gmail.com> wrote in message
news:1126594138.934122.74600@.f14g2000cwb.googlegroups.com...
> Thanks for your response.
> I tried 8.5 x 11, it takes me Legal (8,5" x 14"),
> 11"x17" -> Personalized paper format
> 8.5"x14" -> Personalized paper format
> 21cm x 29.7cm -> Personalized paper format
> 210mm x 297mm -> Personalized paper format
>
> As you said it depend on how the printer interpret the values.
> This problem appears most of time on multifunctionnal laser printers
> how can receive multiple paper formats. On inkjet printer with only A4
> paper it works better.
> But, I think it's possible to make understand to the printer the right
> format. All the rest of applications like Word, Excel,... managed to do
> this so there's no good reason for the activex to not managed to do
> this.
> I see while searching answers thru several forums and newsgroup that
> this problem occurs to a number a person all over the world.
> So, it could be usefull to have a clear answer on how we need to set
> page heigth and width for the A4 format.
> (Sorry for my poor english, I tried to be as clear as possible)
>
Tuesday, March 20, 2012
a toughy!
Hey all,
I have a bunch of data files that currently come to my shop in an EBCDIC format from IBM midrange machines and I currently use a Borland application to convert them to ASCII. I would like to ditch the Borland piece and do everything with a DTS package and get the data into my SQL2000 server...but how do I convert the EBCDIC to ASCII?
Please help!there are more ways and everything depends on how often you do it, how big files you have, how automated process you want...
I can tell you that the best is Informatica PowerCenter... for $200,000
I'm just kidding :)
you can use command-line conversion tool or ActiveX or your own function.
You can have your own function and use it in FIELD to FIELD mapping in DTS. The problem is, that it will take lot of time and for larger TXT files it is not the best solution.... Better would be to convert text file from EBCDIC to ASCII. There are some free command line programs ActiveX components (text file conversions). Check Google.com
I'd start with small function and you will see if it is really slooooow.
http://www.crystalsoftware.com.au/textpipe.html
http://www.guysoftware.com/parserat.htm
jiri|||Thanks, but I was really hoping to get my hands on some source so I could see how this works. I am not to keen about buying a 3rd party tool from a small developer because it will lead to a support nightmare 3 years down the road.
Has anyone out there tackled this ground up? I would love to see some source, even if its slow...heck I'd even be willing to taske a crack at some Perl.
-d
Originally posted by playernovis
there are more ways and everything depends on how often you do it, how big files you have, how automated process you want...
I can tell you that the best is Informatica PowerCenter... for $200,000
I'm just kidding :)
you can use command-line conversion tool or ActiveX or your own function.
You can have your own function and use it in FIELD to FIELD mapping in DTS. The problem is, that it will take lot of time and for larger TXT files it is not the best solution.... Better would be to convert text file from EBCDIC to ASCII. There are some free command line programs ActiveX components (text file conversions). Check Google.com
I'd start with small function and you will see if it is really slooooow.
http://www.crystalsoftware.com.au/textpipe.html
http://www.guysoftware.com/parserat.htm
jiri
I have a bunch of data files that currently come to my shop in an EBCDIC format from IBM midrange machines and I currently use a Borland application to convert them to ASCII. I would like to ditch the Borland piece and do everything with a DTS package and get the data into my SQL2000 server...but how do I convert the EBCDIC to ASCII?
Please help!there are more ways and everything depends on how often you do it, how big files you have, how automated process you want...
I can tell you that the best is Informatica PowerCenter... for $200,000
I'm just kidding :)
you can use command-line conversion tool or ActiveX or your own function.
You can have your own function and use it in FIELD to FIELD mapping in DTS. The problem is, that it will take lot of time and for larger TXT files it is not the best solution.... Better would be to convert text file from EBCDIC to ASCII. There are some free command line programs ActiveX components (text file conversions). Check Google.com
I'd start with small function and you will see if it is really slooooow.
http://www.crystalsoftware.com.au/textpipe.html
http://www.guysoftware.com/parserat.htm
jiri|||Thanks, but I was really hoping to get my hands on some source so I could see how this works. I am not to keen about buying a 3rd party tool from a small developer because it will lead to a support nightmare 3 years down the road.
Has anyone out there tackled this ground up? I would love to see some source, even if its slow...heck I'd even be willing to taske a crack at some Perl.
-d
Originally posted by playernovis
there are more ways and everything depends on how often you do it, how big files you have, how automated process you want...
I can tell you that the best is Informatica PowerCenter... for $200,000
I'm just kidding :)
you can use command-line conversion tool or ActiveX or your own function.
You can have your own function and use it in FIELD to FIELD mapping in DTS. The problem is, that it will take lot of time and for larger TXT files it is not the best solution.... Better would be to convert text file from EBCDIC to ASCII. There are some free command line programs ActiveX components (text file conversions). Check Google.com
I'd start with small function and you will see if it is really slooooow.
http://www.crystalsoftware.com.au/textpipe.html
http://www.guysoftware.com/parserat.htm
jiri
Thursday, March 8, 2012
A simple question on the connection string format on sql server 2005!
Hi everyone!
I am new to visual studio 2005 and sql server 2005.
Up to now i was using visual studio 2003 and ms access.
I am new to visual studio 2005 and sql server 2005.
Up to now i was using visual studio 2003 and ms access.
When i wanted to create a web application that communicates withan access database, i just had to take the *.mdb file and put itinto a specific folder inside my application's folder and then useServer.MapPath on the connection string (so it can run on any pc).
Now, i want to do the same with sql server 2005 and visual studio 2005.I use the connection string: "Server=MYSERVER;InitialCatalog=test_db;Integrated Security=SSPI".
My problems are:
1) Can i just take the *.mdf file put it inside the App_Data folder like i did on access?
2) What should be the connection string so that my application can run on any pc (with sql server 2005)?
Thanx in advance guys!Right click the app_data folder in solution explorer, say add new item. Choose the SQL Database, give it a name, and click ok. Drop a sqldatasource on a form, and choose the correct connection string from the dropdown, and when it asks if you want to put the connection string in web.config, say yes.
Subscribe to:
Posts (Atom)