Hello,
I have a simple report (rdl available but the ms browser wont let me upload
it) that runs and displays fine on screen; when a user does an export to pdf
they only get the first page. On screen we are seeing 18 pages in total in
IE.
When we export to PDF we only get the first page; exporting to excel is
showing all the information correctly...
The server is windows 2003, sql 2000 sp4 the clients are windows 2000/ ie6
and either windows xp / ie6 / ie7 and the same is happening for all users.
We are accessing the reports from inside an iframe generally; calling the
report with the required parameters. Though when we try it using the URL the
same export happens.
There are about 40 reports on the server and only this one is affected.
Thanks
ChrisIt might be that some of the report elements are sitting on top of each
other.
Try opening the report in your designer, and move all the elements so that
you make sure none are covering the others. Then upload and see if this
solves it.
Kaisa M. Lindahl Lervik
"Chris Hoare" <choare@.nospam.nospam> wrote in message
news:0004CD40-F271-4AC9-9875-3276DC0B5558@.microsoft.com...
> Hello,
> I have a simple report (rdl available but the ms browser wont let me
> upload
> it) that runs and displays fine on screen; when a user does an export to
> pdf
> they only get the first page. On screen we are seeing 18 pages in total in
> IE.
> When we export to PDF we only get the first page; exporting to excel is
> showing all the information correctly...
> The server is windows 2003, sql 2000 sp4 the clients are windows 2000/ ie6
> and either windows xp / ie6 / ie7 and the same is happening for all users.
> We are accessing the reports from inside an iframe generally; calling the
> report with the required parameters. Though when we try it using the URL
> the
> same export happens.
> There are about 40 reports on the server and only this one is affected.
> Thanks
> Chris
>
>|||No there are no hidden overlapping The only expressions in the report handle
some color formatting on the numbers on the report to highlight exceptions.
We managed to get it to export on a pc running XP SP2 / Office 2003 last
night; but we havent had any luck with other reports.
Also tried deleting it out from reporting services manager, changing the
report history to store 1 copy of the report.|||Hi choare,
Thank you for the post.
Would you pleae send the report file to me? You may send to me directly. I
understand the information may be sensitive to you, my direct email address
is weilu@.ONLINE.microsoft.com (Please remove the ONLINE when you send the
mail), you may send the file to me directly and I will keep secure.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Showing posts with label available. Show all posts
Showing posts with label available. Show all posts
Sunday, March 11, 2012
Sunday, February 19, 2012
Export to Access
Would like to know anyone knows how to create the ability to export to Access
from RS web. Maybe making it available in the dropdown. We are reaching the
limitations of excel and would like to automate it saving as table in access.
ThanksAndrew,
I'm not sure if you can get to access from RS directly but a
possible way round it would be to set up a subscription in RS to save the
output as a csv file on a fileshare at regular intervals. You could then
import the csv file into access as a table.
Hope this helps.
Nick Colebourn
"Andrew" wrote:
> Would like to know anyone knows how to create the ability to export to Access
> from RS web. Maybe making it available in the dropdown. We are reaching the
> limitations of excel and would like to automate it saving as table in access.
> Thanks|||RS doesn't export to MS Access. As Nick said you can export to CSV or since
you are already exporting to Excel then import those files into Access.
"Nick Colebourn" <NickColebourn@.discussions.microsoft.com> wrote in message
news:2A6D94F2-099F-426E-9335-49C779F4747B@.microsoft.com...
> Andrew,
> I'm not sure if you can get to access from RS directly but a
> possible way round it would be to set up a subscription in RS to save the
> output as a csv file on a fileshare at regular intervals. You could then
> import the csv file into access as a table.
> Hope this helps.
> Nick Colebourn
> "Andrew" wrote:
> > Would like to know anyone knows how to create the ability to export to
Access
> > from RS web. Maybe making it available in the dropdown. We are
reaching the
> > limitations of excel and would like to automate it saving as table in
access.
> > Thanks|||I have a similar problem. I want to automatically have an excel file imported
into access without user intervention. Is this possible?
"Brian Bischof" wrote:
> RS doesn't export to MS Access. As Nick said you can export to CSV or since
> you are already exporting to Excel then import those files into Access.
>
> "Nick Colebourn" <NickColebourn@.discussions.microsoft.com> wrote in message
> news:2A6D94F2-099F-426E-9335-49C779F4747B@.microsoft.com...
> > Andrew,
> > I'm not sure if you can get to access from RS directly but a
> > possible way round it would be to set up a subscription in RS to save the
> > output as a csv file on a fileshare at regular intervals. You could then
> > import the csv file into access as a table.
> >
> > Hope this helps.
> >
> > Nick Colebourn
> >
> > "Andrew" wrote:
> >
> > > Would like to know anyone knows how to create the ability to export to
> Access
> > > from RS web. Maybe making it available in the dropdown. We are
> reaching the
> > > limitations of excel and would like to automate it saving as table in
> access.
> > > Thanks
>
>
from RS web. Maybe making it available in the dropdown. We are reaching the
limitations of excel and would like to automate it saving as table in access.
ThanksAndrew,
I'm not sure if you can get to access from RS directly but a
possible way round it would be to set up a subscription in RS to save the
output as a csv file on a fileshare at regular intervals. You could then
import the csv file into access as a table.
Hope this helps.
Nick Colebourn
"Andrew" wrote:
> Would like to know anyone knows how to create the ability to export to Access
> from RS web. Maybe making it available in the dropdown. We are reaching the
> limitations of excel and would like to automate it saving as table in access.
> Thanks|||RS doesn't export to MS Access. As Nick said you can export to CSV or since
you are already exporting to Excel then import those files into Access.
"Nick Colebourn" <NickColebourn@.discussions.microsoft.com> wrote in message
news:2A6D94F2-099F-426E-9335-49C779F4747B@.microsoft.com...
> Andrew,
> I'm not sure if you can get to access from RS directly but a
> possible way round it would be to set up a subscription in RS to save the
> output as a csv file on a fileshare at regular intervals. You could then
> import the csv file into access as a table.
> Hope this helps.
> Nick Colebourn
> "Andrew" wrote:
> > Would like to know anyone knows how to create the ability to export to
Access
> > from RS web. Maybe making it available in the dropdown. We are
reaching the
> > limitations of excel and would like to automate it saving as table in
access.
> > Thanks|||I have a similar problem. I want to automatically have an excel file imported
into access without user intervention. Is this possible?
"Brian Bischof" wrote:
> RS doesn't export to MS Access. As Nick said you can export to CSV or since
> you are already exporting to Excel then import those files into Access.
>
> "Nick Colebourn" <NickColebourn@.discussions.microsoft.com> wrote in message
> news:2A6D94F2-099F-426E-9335-49C779F4747B@.microsoft.com...
> > Andrew,
> > I'm not sure if you can get to access from RS directly but a
> > possible way round it would be to set up a subscription in RS to save the
> > output as a csv file on a fileshare at regular intervals. You could then
> > import the csv file into access as a table.
> >
> > Hope this helps.
> >
> > Nick Colebourn
> >
> > "Andrew" wrote:
> >
> > > Would like to know anyone knows how to create the ability to export to
> Access
> > > from RS web. Maybe making it available in the dropdown. We are
> reaching the
> > > limitations of excel and would like to automate it saving as table in
> access.
> > > Thanks
>
>
Friday, February 17, 2012
Export SQL Server Diagrams
Are there any tools available that can export SQL Server Diagrams. We have
around 50 complex databases whose structure might change periodically. I wan
t
to export those SQL server diagrams to pdfs or image files. If you have any
suggestions, let me know.
Thanks.We use Visio for this at the place I work at (reverse engineer DB)
and then we convert to PDF
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
> want
> to export those SQL server diagrams to pdfs or image files. If you have
> any
> suggestions, let me know.
> Thanks.|||Unfortunately, I have never come across something that does this (and I
think it would be pretty valuble, too.)
What I've ended up doing is either printing out the diagram across multiple
8.5 x 11 pages and taping them together to get a bigger "poster" diagram...
or
in some cases I've been lucky enough to be able to print the diagram out on
a big plotter (usually used for proj. mgmt. graphics/charts) so I don't have
to tape pages together.
You should be able to make PDF's out of them if you have the Adobe PDFWriter
(a.k.a Distiller) printer driver ..it allows you to print to a PDF file.
-Jason
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
want
> to export those SQL server diagrams to pdfs or image files. If you have
any
> suggestions, let me know.
> Thanks.|||You'll need to use ERD tools for that I think, unless you are satisfied with
the PrintScreen button. Database Diagrams do not support an export feature
that I am aware of.
You can use Microsoft's Visio, E/RWin (www.ca.com), Enterprise Architect
(http://www.sparxsystems.com/), probably a host of others I can't think of
off the top of my head.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
want
> to export those SQL server diagrams to pdfs or image files. If you have
any
> suggestions, let me know.
> Thanks.|||If all you require is something that can be printed (say using MS Word) one
method I use is to connect to the database via an MS Access project (.adp
file instead of the normal .mdb). With the diagram open, you then have a
option to copy the diagram to the clipboard and paste it into word as an
image.
Regards
Dazza
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
> want
> to export those SQL server diagrams to pdfs or image files. If you have
> any
> suggestions, let me know.
> Thanks.|||With the diagram open in the MS Access project, click on Edit -- Copy
Diagram to Clipboard.
Regards
Dazza
"Dazza" <Post2Group@.Only.com> wrote in message
news:ekeI3hKMFHA.3328@.TK2MSFTNGP14.phx.gbl...
> If all you require is something that can be printed (say using MS Word)
> one method I use is to connect to the database via an MS Access project
> (.adp file instead of the normal .mdb). With the diagram open, you then
> have a option to copy the diagram to the clipboard and paste it into word
> as an image.
> Regards
> Dazza
> "Pradip" <Pradip@.discussions.microsoft.com> wrote in message
> news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
>|||This is a great idea. This will work for me atleast to export the diagram to
bitmap. Is there a way to do this programatically. Can we develop a program
will automatically connect to all the SQL Server databases and import them t
o
Access and copy the Diagram to Clipboard and export them to JPEG everyday. I
f
this is possible then this would be a huge benefit for me.
"Dazza" wrote:
> With the diagram open in the MS Access project, click on Edit -- Copy
> Diagram to Clipboard.
> Regards
> Dazza
>
> "Dazza" <Post2Group@.Only.com> wrote in message
> news:ekeI3hKMFHA.3328@.TK2MSFTNGP14.phx.gbl...
>
>
around 50 complex databases whose structure might change periodically. I wan
t
to export those SQL server diagrams to pdfs or image files. If you have any
suggestions, let me know.
Thanks.We use Visio for this at the place I work at (reverse engineer DB)
and then we convert to PDF
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
> want
> to export those SQL server diagrams to pdfs or image files. If you have
> any
> suggestions, let me know.
> Thanks.|||Unfortunately, I have never come across something that does this (and I
think it would be pretty valuble, too.)
What I've ended up doing is either printing out the diagram across multiple
8.5 x 11 pages and taping them together to get a bigger "poster" diagram...
or
in some cases I've been lucky enough to be able to print the diagram out on
a big plotter (usually used for proj. mgmt. graphics/charts) so I don't have
to tape pages together.
You should be able to make PDF's out of them if you have the Adobe PDFWriter
(a.k.a Distiller) printer driver ..it allows you to print to a PDF file.
-Jason
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
want
> to export those SQL server diagrams to pdfs or image files. If you have
any
> suggestions, let me know.
> Thanks.|||You'll need to use ERD tools for that I think, unless you are satisfied with
the PrintScreen button. Database Diagrams do not support an export feature
that I am aware of.
You can use Microsoft's Visio, E/RWin (www.ca.com), Enterprise Architect
(http://www.sparxsystems.com/), probably a host of others I can't think of
off the top of my head.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
want
> to export those SQL server diagrams to pdfs or image files. If you have
any
> suggestions, let me know.
> Thanks.|||If all you require is something that can be printed (say using MS Word) one
method I use is to connect to the database via an MS Access project (.adp
file instead of the normal .mdb). With the diagram open, you then have a
option to copy the diagram to the clipboard and paste it into word as an
image.
Regards
Dazza
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
> want
> to export those SQL server diagrams to pdfs or image files. If you have
> any
> suggestions, let me know.
> Thanks.|||With the diagram open in the MS Access project, click on Edit -- Copy
Diagram to Clipboard.
Regards
Dazza
"Dazza" <Post2Group@.Only.com> wrote in message
news:ekeI3hKMFHA.3328@.TK2MSFTNGP14.phx.gbl...
> If all you require is something that can be printed (say using MS Word)
> one method I use is to connect to the database via an MS Access project
> (.adp file instead of the normal .mdb). With the diagram open, you then
> have a option to copy the diagram to the clipboard and paste it into word
> as an image.
> Regards
> Dazza
> "Pradip" <Pradip@.discussions.microsoft.com> wrote in message
> news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
>|||This is a great idea. This will work for me atleast to export the diagram to
bitmap. Is there a way to do this programatically. Can we develop a program
will automatically connect to all the SQL Server databases and import them t
o
Access and copy the Diagram to Clipboard and export them to JPEG everyday. I
f
this is possible then this would be a huge benefit for me.
"Dazza" wrote:
> With the diagram open in the MS Access project, click on Edit -- Copy
> Diagram to Clipboard.
> Regards
> Dazza
>
> "Dazza" <Post2Group@.Only.com> wrote in message
> news:ekeI3hKMFHA.3328@.TK2MSFTNGP14.phx.gbl...
>
>
Subscribe to:
Posts (Atom)