Can't export to PDF with hidden group

I have a report that uses a matrix control to display the data. After
spending hours on the report getting it to look right in Report Manager, I
went to export to PDF and could not. I got the error "Internet Explorer
cannot download format=PDF".
So I proceeded to recreate the report step by step. At each step, I
deployed, ran, and try to export to pdf.
The problem comes when I have a group make the visible property=false.
My work around is to change the Font color to white and disable growing.
Is this a known issue and is being worked on or should I report this to MS?Please email me a copy of your .rdl and .rdl.data file so I can take a look.
Also, please send me a copy of the error you're seeing in the latest log
file in your /ReportServer/LogFiles directory.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"David" <David@.discussions.microsoft.com> wrote in message
news:AC2E1B8D-CB2F-4AF5-BEF9-F72A470BC626@.microsoft.com...
>I have a report that uses a matrix control to display the data. After
> spending hours on the report getting it to look right in Report Manager, I
> went to export to PDF and could not. I got the error "Internet Explorer
> cannot download format=PDF".
> So I proceeded to recreate the report step by step. At each step, I
> deployed, ran, and try to export to pdf.
> The problem comes when I have a group make the visible property=false.
> My work around is to change the Font color to white and disable growing.
> Is this a known issue and is being worked on or should I report this to
> MS?|||I would but I need your email. You can send it to:
david_perkins a t concentra d o t com
"Donovan Smith [MSFT]" wrote:
> Please email me a copy of your .rdl and .rdl.data file so I can take a look.
> Also, please send me a copy of the error you're seeing in the latest log
> file in your /ReportServer/LogFiles directory.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:AC2E1B8D-CB2F-4AF5-BEF9-F72A470BC626@.microsoft.com...
> >I have a report that uses a matrix control to display the data. After
> > spending hours on the report getting it to look right in Report Manager, I
> > went to export to PDF and could not. I got the error "Internet Explorer
> > cannot download format=PDF".
> >
> > So I proceeded to recreate the report step by step. At each step, I
> > deployed, ran, and try to export to pdf.
> >
> > The problem comes when I have a group make the visible property=false.
> >
> > My work around is to change the Font color to white and disable growing.
> >
> > Is this a known issue and is being worked on or should I report this to
> > MS?
>
>|||David sent me a copy of his report and I'm investigating. A second repro
certainly wouldn't hurt anything so please email me a copy of your .rdl and
.rdl.data file so I can take a look.
Thanks.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Goncalo" <Goncalo@.discussions.microsoft.com> wrote in message
news:87CB2105-49AB-440C-9DA9-7415FCE8BD55@.microsoft.com...
> I'm having the same problem. Is there any solution to this?
> Goncalo
>
> "Donovan Smith [MSFT]" wrote:
>> Please email me a copy of your .rdl and .rdl.data file so I can take a
>> look.
>> Also, please send me a copy of the error you're seeing in the latest log
>> file in your /ReportServer/LogFiles directory.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "David" <David@.discussions.microsoft.com> wrote in message
>> news:AC2E1B8D-CB2F-4AF5-BEF9-F72A470BC626@.microsoft.com...
>> >I have a report that uses a matrix control to display the data. After
>> > spending hours on the report getting it to look right in Report
>> > Manager, I
>> > went to export to PDF and could not. I got the error "Internet Explorer
>> > cannot download format=PDF".
>> >
>> > So I proceeded to recreate the report step by step. At each step, I
>> > deployed, ran, and try to export to pdf.
>> >
>> > The problem comes when I have a group make the visible property=false.
>> >
>> > My work around is to change the Font color to white and disable
>> > growing.
>> >
>> > Is this a known issue and is being worked on or should I report this to
>> > MS?
>>

Can't export report to CSV,XMl correctly, sql 2005 reporting service

Hi all,

I am developing reports using sql2005 report service. I can export reports in excel and pdf format, but can't export to csv and xml correctly.

The exported csv and xml files only contain some thing like the textbox,..., but no report content are there.

Anybody can help? thanks in advance.

BTW, all reports are matrix, is martrix can cause some issues?

Hi,

For most items on your report, you can define how it needs to be rendered to XML. For example the xml output for an item in a matrix can be set as follow:

select the item in the matrix|||

Thanks, Greert.

Your reply is really helpful. Now I know how to export report in xml format. But, how about CSV? I still can't export report to csv.

Thanks again

|||

Hi,

The same goes for CSV. For example if you set the Output of a column to No, you will see that the column is not included in the CSV file.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||Hi Geert,

Thanks a lot.

When I set th output of a column to yes, it works. Before, the the output of column was set to Auto.

Cant Export Fields w/ over 255 characters

I have a query where I am trying to export a column that has around
2000 characters and it is truncated. What is not setup in MS SQL
correctly so that DTS will export the csv correctly.

Thanks,
John<quinniii@.yahoo.com> wrote in message
news:1109013962.276779.70380@.o13g2000cwo.googlegro ups.com...
>I have a query where I am trying to export a column that has around
> 2000 characters and it is truncated. What is not setup in MS SQL
> correctly so that DTS will export the csv correctly.
> Thanks,
> John

This might be the issue:

http://www.sqldts.com/?297

If that doesn't help, then I suggest you post more information - what
version of MSSL, what data source and target types do you have, what sort of
task/transformation are you using to move the data etc.

Simon

Can't copy/export a database with identity *NEWBIE*

I have a database where some tables have the IDENTITY = YES.
If I copy or export from ServerA to ServerB, the IDENTITY gets set to No.
This has to be a simple problem.
How is it fixed?
If you are simply doing an export/import you need to create the table with
the desired format on the subscriber/destination/target side - i.e. with the
identity property on the column. Then before you do your import set
identity_insert on for that table, i.e.
SET IDENTITY_INSERT MyTableName ONIf you are using bcp use the -E parameter.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jeffrey Brandt" <jdbrandt@.verizon.net> wrote in message
news:lO7fi.268$XH5.206@.trndny02...
>I have a database where some tables have the IDENTITY = YES.
> If I copy or export from ServerA to ServerB, the IDENTITY gets set to No.
> This has to be a simple problem.
> How is it fixed?
>
|||You were SOO right.
I ended up using snapshot replication, and pushed it to the other machine.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OBM0x%23YtHHA.1728@.TK2MSFTNGP06.phx.gbl...
> You can use queued updating subscribers or merge replication both with
> automatic identity range management.
> HTH,
> Paul Ibison
>