PDF to RDL conversion

I have a project that we need to dynamically output a PDF document.
The format I have it in now is PDF. I want to be able to bring this
PDF into the Visual Studio report designer as a starting point. I will
the drop report parameters on to the report to add the dynamic data.
Is there any way I can convert a PDF document into an RDL file?I haven't heard of an automatic converter that will take a PDF and create an
RED, not sure how it would be able to do that anyway.
--
Floyd
"Paul Hester" <phester@.gmail.com> wrote in message
news:1123797876.993952.76350@.g44g2000cwa.googlegroups.com...
>I have a project that we need to dynamically output a PDF document.
> The format I have it in now is PDF. I want to be able to bring this
> PDF into the Visual Studio report designer as a starting point. I will
> the drop report parameters on to the report to add the dynamic data.
> Is there any way I can convert a PDF document into an RDL file?
>|||Nope, Floyd is correct, there is no way to do this...Start from scratch...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul Hester" <phester@.gmail.com> wrote in message
news:1123797876.993952.76350@.g44g2000cwa.googlegroups.com...
>I have a project that we need to dynamically output a PDF document.
> The format I have it in now is PDF. I want to be able to bring this
> PDF into the Visual Studio report designer as a starting point. I will
> the drop report parameters on to the report to add the dynamic data.
> Is there any way I can convert a PDF document into an RDL file?
>

pdf size due to images

We have a report with a number of external images. When the report is run
and exported to pdf, the resulting document is over 2mb (regardless of
whether the report is run in VS or the ReportManager). When the images are
changed from external to embedded, the resulting pdf document is around
500kb. This is great since the 2mb was causing issues with our client's
email server. When the modified rdl is imported to our client's system, the
resulting document is still around 500kb.
When the original rdl is modified on the client's system using
ReportDesigner - and all of the images are changed from external to embedded
- the resulting pdf document is still over 2mb!! I've verified any number
of times that the images are of type embedded.
Both systems are have reporting services at sp1. The only obvious
difference is that our environment is a developer edition of SQL Server and
the client's is Standard.
Is the difference in SQL the reason? Any other ideas/suggestions'
ThanksThis is NOT an issue between external vs. embedded images. During testing
the wrong image file was being used.
It DOES appear to be an issue with the way images are rendered to PDF.
Using other document types such as Word results in a smaller overall document
size.
Any suggestions/ideas for rendering to pdf are appreciated.
"PD" wrote:
> We have a report with a number of external images. When the report is run
> and exported to pdf, the resulting document is over 2mb (regardless of
> whether the report is run in VS or the ReportManager). When the images are
> changed from external to embedded, the resulting pdf document is around
> 500kb. This is great since the 2mb was causing issues with our client's
> email server. When the modified rdl is imported to our client's system, the
> resulting document is still around 500kb.
> When the original rdl is modified on the client's system using
> ReportDesigner - and all of the images are changed from external to embedded
> - the resulting pdf document is still over 2mb!! I've verified any number
> of times that the images are of type embedded.
> Both systems are have reporting services at sp1. The only obvious
> difference is that our environment is a developer edition of SQL Server and
> the client's is Standard.
> Is the difference in SQL the reason? Any other ideas/suggestions'
> Thanks|||The issue was resolved by: (1) upgrading to SP2 AND (2) reducing the size of
jpg images that are used in the report. ONLY upgrading to SP2 DID NOT solve
the problem - the original images were simply distorted/gray AND without a
reduction in overall pdf document size. The size of the images were reduced
using MS Photo Editor, although other editors seem to work also.
"PD" wrote:
> This is NOT an issue between external vs. embedded images. During testing
> the wrong image file was being used.
> It DOES appear to be an issue with the way images are rendered to PDF.
> Using other document types such as Word results in a smaller overall document
> size.
> Any suggestions/ideas for rendering to pdf are appreciated.
>
> "PD" wrote:
> > We have a report with a number of external images. When the report is run
> > and exported to pdf, the resulting document is over 2mb (regardless of
> > whether the report is run in VS or the ReportManager). When the images are
> > changed from external to embedded, the resulting pdf document is around
> > 500kb. This is great since the 2mb was causing issues with our client's
> > email server. When the modified rdl is imported to our client's system, the
> > resulting document is still around 500kb.
> >
> > When the original rdl is modified on the client's system using
> > ReportDesigner - and all of the images are changed from external to embedded
> > - the resulting pdf document is still over 2mb!! I've verified any number
> > of times that the images are of type embedded.
> >
> > Both systems are have reporting services at sp1. The only obvious
> > difference is that our environment is a developer edition of SQL Server and
> > the client's is Standard.
> >
> > Is the difference in SQL the reason? Any other ideas/suggestions'
> > Thanks

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 Error: Urgent

When I try to export it to PDF; I get an error "There was an error opening
this document.This file cannot be found."
The same report was working fine last month.
Export To Excel Works FineClear Temporary Internet Folder
"Sudha" wrote:
> When I try to export it to PDF; I get an error "There was an error opening
> this document.This file cannot be found."
> The same report was working fine last month.
> Export To Excel Works Fine
>

pdf error

When I try to export it to PDF; I get an error "There was an error opening
this document.This file cannot be found."
This happens with Acrobat reader 5.0, 6.0 when the reports are pulled on
the user's machines from the production server. Am I missing something.
The export works well on the staging server.
any help is appreciated.
GaryI have heard of this on other machines. It seems to have something to do
with the browser config / temporary internet files. The file is usually gone
before Acrobat can open it.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary" <gary@.msn.com> wrote in message
news:eaxxMHMnEHA.2612@.TK2MSFTNGP15.phx.gbl...
> When I try to export it to PDF; I get an error "There was an error opening
> this document.This file cannot be found."
> This happens with Acrobat reader 5.0, 6.0 when the reports are pulled on
> the user's machines from the production server. Am I missing something.
> The export works well on the staging server.
> any help is appreciated.
> Gary
>|||Try After Clearing Temporary Internet Folder
"Gary" wrote:
> When I try to export it to PDF; I get an error "There was an error opening
> this document.This file cannot be found."
> This happens with Acrobat reader 5.0, 6.0 when the reports are pulled on
> the user's machines from the production server. Am I missing something.
> The export works well on the staging server.
> any help is appreciated.
> Gary
>
>sql

PDF Document Map Hierarchy

I've notice a couple other posts about this issue, but could not seem
to find any responses/resolutions.
I have a table with multiple groups. In HTML the document map
hierarchy looks fine. In PDF there is no hierarchy.
Thanks for any help with this.
Example - HTML:
- Sex
- Male
- Age
- 35
- 40
- 45
- Female
- Age
- 35
- 40
- 45
Example - PDF:
Sex
Male
Age
35
40
45
Female
Age
35
40
45Hi Bob,
how did you get the hierarchy in HTML and preview? I have no hierarchy at
all.
thanks
Matt
"BobA" <robert.ames@.mercer.com> wrote in message
news:b7b93183.0410051203.4d37c984@.posting.google.com...
> I've notice a couple other posts about this issue, but could not seem
> to find any responses/resolutions.
> I have a table with multiple groups. In HTML the document map
> hierarchy looks fine. In PDF there is no hierarchy.
> Thanks for any help with this.
> Example - HTML:
> - Sex
> - Male
> - Age
> - 35
> - 40
> - 45
> - Female
> - Age
> - 35
> - 40
> - 45
> Example - PDF:
> Sex
> Male
> Age
> 35
> 40
> 45
> Female
> Age
> 35
> 40
> 45|||Thanks, I figured it out. I needed to set the document map against the
group not the element in the table.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> Hi Bob,
> how did you get the hierarchy in HTML and preview? I have no hierarchy at
> all.
> thanks
> Matt
>
> "BobA" <robert.ames@.mercer.com> wrote in message
> news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > I've notice a couple other posts about this issue, but could not seem
> > to find any responses/resolutions.
> >
> > I have a table with multiple groups. In HTML the document map
> > hierarchy looks fine. In PDF there is no hierarchy.
> >
> > Thanks for any help with this.
> >
> > Example - HTML:
> >
> > - Sex
> > - Male
> > - Age
> > - 35
> > - 40
> > - 45
> > - Female
> > - Age
> > - 35
> > - 40
> > - 45
> >
> > Example - PDF:
> >
> > Sex
> > Male
> > Age
> > 35
> > 40
> > 45
> > Female
> > Age
> > 35
> > 40
> > 45
>|||This is still an issue. Are there any ideas on how to fix this
problem?
Matt wrote:
> Thanks, I figured it out. I needed to set the document map against
the
> group not the element in the table.
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> > Hi Bob,
> >
> > how did you get the hierarchy in HTML and preview? I have no
hierarchy at
> > all.
> >
> > thanks
> >
> > Matt
> >
> >
> > "BobA" <robert.ames@.mercer.com> wrote in message
> > news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > > I've notice a couple other posts about this issue, but could not
seem
> > > to find any responses/resolutions.
> > >
> > > I have a table with multiple groups. In HTML the document map
> > > hierarchy looks fine. In PDF there is no hierarchy.
> > >
> > > Thanks for any help with this.
> > >
> > > Example - HTML:
> > >
> > > - Sex
> > > - Male
> > > - Age
> > > - 35
> > > - 40
> > > - 45
> > > - Female
> > > - Age
> > > - 35
> > > - 40
> > > - 45
> > >
> > > Example - PDF:
> > >
> > > Sex
> > > Male
> > > Age
> > > 35
> > > 40
> > > 45
> > > Female
> > > Age
> > > 35
> > > 40
> > > 45
> >
> >|||Hi Bob,
I am facing the same dilema. The Document map hierarchy appears flat when
you export to PDF. Very annoying!!!
Thanks,
Terry
"BobA" wrote:
> This is still an issue. Are there any ideas on how to fix this
> problem?
> Matt wrote:
> > Thanks, I figured it out. I needed to set the document map against
> the
> > group not the element in the table.
> >
> > "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> > news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> > > Hi Bob,
> > >
> > > how did you get the hierarchy in HTML and preview? I have no
> hierarchy at
> > > all.
> > >
> > > thanks
> > >
> > > Matt
> > >
> > >
> > > "BobA" <robert.ames@.mercer.com> wrote in message
> > > news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > > > I've notice a couple other posts about this issue, but could not
> seem
> > > > to find any responses/resolutions.
> > > >
> > > > I have a table with multiple groups. In HTML the document map
> > > > hierarchy looks fine. In PDF there is no hierarchy.
> > > >
> > > > Thanks for any help with this.
> > > >
> > > > Example - HTML:
> > > >
> > > > - Sex
> > > > - Male
> > > > - Age
> > > > - 35
> > > > - 40
> > > > - 45
> > > > - Female
> > > > - Age
> > > > - 35
> > > > - 40
> > > > - 45
> > > >
> > > > Example - PDF:
> > > >
> > > > Sex
> > > > Male
> > > > Age
> > > > 35
> > > > 40
> > > > 45
> > > > Female
> > > > Age
> > > > 35
> > > > 40
> > > > 45
> > >
> > >
>|||Hi,
I have the same issue also. Did anyone ever find a solution to it?
Thanks,
Melissa
"Terry" wrote:
> Hi Bob,
> I am facing the same dilema. The Document map hierarchy appears flat when
> you export to PDF. Very annoying!!!
> Thanks,
> Terry
> "BobA" wrote:
> > This is still an issue. Are there any ideas on how to fix this
> > problem?
> >
> > Matt wrote:
> > > Thanks, I figured it out. I needed to set the document map against
> > the
> > > group not the element in the table.
> > >
> > > "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> > > news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> > > > Hi Bob,
> > > >
> > > > how did you get the hierarchy in HTML and preview? I have no
> > hierarchy at
> > > > all.
> > > >
> > > > thanks
> > > >
> > > > Matt
> > > >
> > > >
> > > > "BobA" <robert.ames@.mercer.com> wrote in message
> > > > news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > > > > I've notice a couple other posts about this issue, but could not
> > seem
> > > > > to find any responses/resolutions.
> > > > >
> > > > > I have a table with multiple groups. In HTML the document map
> > > > > hierarchy looks fine. In PDF there is no hierarchy.
> > > > >
> > > > > Thanks for any help with this.
> > > > >
> > > > > Example - HTML:
> > > > >
> > > > > - Sex
> > > > > - Male
> > > > > - Age
> > > > > - 35
> > > > > - 40
> > > > > - 45
> > > > > - Female
> > > > > - Age
> > > > > - 35
> > > > > - 40
> > > > > - 45
> > > > >
> > > > > Example - PDF:
> > > > >
> > > > > Sex
> > > > > Male
> > > > > Age
> > > > > 35
> > > > > 40
> > > > > 45
> > > > > Female
> > > > > Age
> > > > > 35
> > > > > 40
> > > > > 45
> > > >
> > > >
> >
> >