PDF Rendering troubles

Hi all. I wont create template for my reports with header include logotype
and name of the reports. Logotype and name included to box with green color,
i wont that this box will have 100% width. i set 21 cm width as A4 format
next i create my report use this template and deploy it to RS server. On Rs
server my report look correct, but if i import it to PDF, PDF file render my
header with left and right margins. How i can correct this problem ?
Thank you.Set report margings to 0in
"dmitri" wrote:
> Hi all. I wont create template for my reports with header include logotype
> and name of the reports. Logotype and name included to box with green color,
> i wont that this box will have 100% width. i set 21 cm width as A4 format
> next i create my report use this template and deploy it to RS server. On Rs
> server my report look correct, but if i import it to PDF, PDF file render my
> header with left and right margins. How i can correct this problem ?
> Thank you.

PDF not showing??

I would expect a box showing up, asking me either to open or save the
PDF document. But nothing happens, no errors, no nothing?
private void Button1_Click(object sender, System.EventArgs e)
{
Reportservice.ReportingService rs = new
Reportservice.ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
//rs.Url = "http://localhost/ReportServer/ReportingService.asmx";
Reportservice.ParameterValue [] Parameter;
Reportservice.Warning [] Warnings;
string [] StreamIDs;
string Encoding, MimeType;
rs.Render("/Report Project3/Report1", "PDF", null, "", null, null,
null, out Encoding, out MimeType, out Parameter, out Warnings, out
StreamIDs);
}
Please help, im really stuck!
JimboFrom your code it looks like you are writing windows application. Call to
rs.Render returns you byte array with PDF document in it. You ignore return
value, hence no errors or anything. It is your responsibility to take this
byte array and put it in a file. You may change your code to
byte[] result = rs.Render(...
and then use result as you like.
If you want more automation, you can open web browser and point it at
http://localhost/ReportServer?/Report Project3/Report1&rs:Format=PDF
that way you'll see "Save..." dialog without programming it.
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Jimbo" <jimbo_vr5@.hotmail.com> wrote in message
news:1126178576.968569.12620@.z14g2000cwz.googlegroups.com...
>I would expect a box showing up, asking me either to open or save the
> PDF document. But nothing happens, no errors, no nothing?
>
> private void Button1_Click(object sender, System.EventArgs e)
> {
> Reportservice.ReportingService rs = new
> Reportservice.ReportingService();
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
> //rs.Url = "http://localhost/ReportServer/ReportingService.asmx";
> Reportservice.ParameterValue [] Parameter;
> Reportservice.Warning [] Warnings;
> string [] StreamIDs;
> string Encoding, MimeType;
> rs.Render("/Report Project3/Report1", "PDF", null, "", null, null,
> null, out Encoding, out MimeType, out Parameter, out Warnings, out
> StreamIDs);
> }
> Please help, im really stuck!
> Jimbo
>|||Its actually in a web page, but i got it to work now.
Now i have another problem, ive posted it in this group:
<http://groups.google.dk/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/8de9666b2df2bdc1/6b895696b710b2c0?hl=da#6b895696b710b2c0>
Thanks
Regards
Jimmy

PDF Format Issues

My report was beautiful until I put groups around my two tables... actually
at first it looked fine... then I started changing text box sizes etc...
suddenly every second page in my report is blank... not in the viewer... when
I export to PDF... anyone know a RS exorcist?A bit silly to reply to my own post... but maybe someone else will run into
this problem... and it can be frustrating so here's how I fixed my problem...
1st off... a "page" in html isn't exactly the same size as a page in PDF...
a page in PDF has to be the same size as your paper... or less... I don't
know if html even has an exact page size limit... NEways...
The report designer in Visual Studio will increase your page size... if you
try to move a control outside of the space you have set... a pretty annoying
feature if you ask me... given that you usually want a page size to be
exactly the same forever... and sometimes you are playing with a long text
box, and you might not see the part off to the side increasing your page
width.
Does anyone know... is there a way to lock the page size?
"MER78" wrote:
> My report was beautiful until I put groups around my two tables... actually
> at first it looked fine... then I started changing text box sizes etc...
> suddenly every second page in my report is blank... not in the viewer... when
> I export to PDF... anyone know a RS exorcist?

Patching sp2k sp3a

I have sql server 2000 sp3a installed.
How can I know (and from where can I download) which patches have I to
install on my box?
Any help appreciated.
Regards.
--
Fabrizio Maccarrone
--
YAMSSQLU
(Yet Another MSSQL User)Fabrizio,
There are many hotfixes for SQL2000 SP3A but you would have to at least
contact MS to get them and then they would probably charge you unless you
have the problem that they fix. There has been 1 security patch, MS03-031,
since SP3A came out but you can get this post MS03-031 patch with a download
from here
http://support.microsoft.com/default.aspx?scid=kb;en-us;826161&Product=sql2k
Chris Wood
Alberta Department of Energy
CANADA
"Fabrizio Maccarrone" <fabrizio (at) 7mates (punto) com> wrote in message
news:eTRl$McXEHA.3596@.tk2msftngp13.phx.gbl...
> I have sql server 2000 sp3a installed.
> How can I know (and from where can I download) which patches have I to
> install on my box?
> Any help appreciated.
> Regards.
> --
> Fabrizio Maccarrone
> --
> YAMSSQLU
> (Yet Another MSSQL User)
>