Monday, March 26, 2012
Formatting, pdf, and SP2
on a report that I am exporting to pdf changed when I updated my VS to the
SP2 of the Reporting Services. Here's what I am trying to do and what SP2 did:
I have a report that I created that makes address labels. I made it to where
it has three columns, and it fit 10 rows on one page. It worked great, until
I installed SP2. Now, it will only print three across the top of the page,
then move on to the next page.
So, my questions are: 1) should I reinstall pre-SP2 RS so that I can do this
report the way that I had it, or 2) does anyone know of an example that will
help me to do what I had done in the pre-SP2 installation?
Any help would be greatly appreciated!!!It sounds weird, and at least I don't know if this is either caused by the
SP2. But what you can do is redefine your report's margins
Friday, March 23, 2012
Formatting spoils when export to HTML Format
export to PDF, it works fine. But when exported to HTML, it doesn't hold the
absolute position and renders tables sequentially.
Thanks,
JigneshThe same thing happens when you overlap charts. Charts render as images,
and are placed side-by-side in HTML rather than overlapping. I presume this
is because the HTML code required to overlap these items (charts, images,
tables), especially while maintaining appropriate transparency, would be
very complex, fragile and browser-specific.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jignesh Nakrani" <Jignesh Nakrani@.discussions.microsoft.com> wrote in
message news:068CD644-4EFF-40A6-B2D7-E86205EFC331@.microsoft.com...
>I have problem here. when I overlap two or more tables one on other and
> export to PDF, it works fine. But when exported to HTML, it doesn't hold
> the
> absolute position and renders tables sequentially.
> Thanks,
> Jignesh|||Jeff,
Thanks for the reply. Hope something comes up with the solution.
"Jeff A. Stucker" wrote:
> The same thing happens when you overlap charts. Charts render as images,
> and are placed side-by-side in HTML rather than overlapping. I presume this
> is because the HTML code required to overlap these items (charts, images,
> tables), especially while maintaining appropriate transparency, would be
> very complex, fragile and browser-specific.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jignesh Nakrani" <Jignesh Nakrani@.discussions.microsoft.com> wrote in
> message news:068CD644-4EFF-40A6-B2D7-E86205EFC331@.microsoft.com...
> >I have problem here. when I overlap two or more tables one on other and
> > export to PDF, it works fine. But when exported to HTML, it doesn't hold
> > the
> > absolute position and renders tables sequentially.
> >
> > Thanks,
> > Jignesh
>
>
Formatting PDF (portrait vs. landscape)
report directly to PDF. I'd like the PDF to automatically format the report
in landscape mode.
Is this possible?
Thanks,
BrianFound my answer in the archives.
Thanks.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:euQ%23WDrXEHA.2940@.TK2MSFTNGP09.phx.gbl...
> When calling a report, in the URL i'm using rs:Format=PDF to render the
> report directly to PDF. I'd like the PDF to automatically format the
report
> in landscape mode.
> Is this possible?
> Thanks,
> Brian
>
Monday, March 12, 2012
Formating Reports To Print
manager) but when I either print or convert to .pdf, some of the text boxes
shifts to a second and maybe a third ?
The report is actualy smaller than a regular letter page.
Any ideas ?You will have to build the report to render as a pdf. In doing so the
web formatting may look out of allignment but the pdf file will look
right. It is very difficult to get them both to look good.
Also, sometimes placing rectangles behind your report items will
prevent them from going outside the report boundries.
Another thing to check is to make sure the "report" page size and
"body" size properties are matching or similar (ie. set the report page
size to 11 x 8.5 for a Landscape print and set the body size to 10.75 x
8 to fit within the page boundries) and only work with in these
boundries. Take some time to try out different margin settings as
well. Work with it a little and usually you can come up with something
that works in the web and pdf worlds.
Let me know how it goes!
Sunday, February 26, 2012
format in pdf
Hy,
I would like to convert my report in pdf. Do you have the code to convert it? I found a lot of code for crystal report but not for Reporting service.
thank you
oolon
In fact, I try to use this kind of code
ReportingService rs = new ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
byte[] ResultStream;
string[] StreamIdentifiers;
string OptionalParam = null, filename = "NorthwindCustomers.pdf";
ParameterValue[] optionalParams = null;
Warning[] optionalWarnings = null;
ResultStream = rs.Render("/Northwind Customers", "PDF", null,
"<DeviceInfo><StreamRoot>/RSWebServiceXS/</StreamRoot></DeviceInfo>", null, null,
null, out OptionalParam, out OptionalParam, out optionalParams,
out optionalWarnings, out StreamIdentifiers);
// Creating a verbatim string.
FileStream stream = File.OpenWrite(@."C:\Articles\SQL Server Reporting
Services\SourceCode\RSWebServiceXS\NorthwindCustomers\" + filename);
stream.Write(ResultStream, 0, ResultStream.Length);
stream.Close();
But my code doesn't recognize The class Reporting Service. Why? i put the librairies :
using System;
using System.IO;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
What librairy's missing?
Thank you
|||You need to create the proxy class, if you haven't already done this. Take a look at this page for instructions:http://msdn2.microsoft.com/en-us/library/ms155134.aspx
If you use the Web Reference method, the proxy classes are generated in the default namespace of your project with the reference name you specified in the Web Reference tool.