Export to Specific Filename

I have a Requisition Report that generates the details for a specific
Requisition ID. This is done by passing a paramater to the report. The
end-user downlads the report as a PDF and saves it to his PC. The problem is
that the default name when he tries to save is the name of the report
(ReqForm.pdf) and he has to manually append the Requisition ID to the
filename (ReqForm-5611.pdf)
I was wondering if there was a way to incorporate the paramater that is
passed to the report into the filename when he goes to save it.
ThanksI don't think so because the report has already been rendered. Have user
open it instead of save and let them name it is one option. The other might
be to render the report as a PDF in your application and maybe you can set
the file name there in a parameter (though I have never done this). HTH.
David
"tigermike" <tigermike@.discussions.microsoft.com> wrote in message
news:DA345A17-0D0C-40FC-9DB7-20B75E4E934F@.microsoft.com...
>I have a Requisition Report that generates the details for a specific
> Requisition ID. This is done by passing a paramater to the report. The
> end-user downlads the report as a PDF and saves it to his PC. The problem
> is
> that the default name when he tries to save is the name of the report
> (ReqForm.pdf) and he has to manually append the Requisition ID to the
> filename (ReqForm-5611.pdf)
> I was wondering if there was a way to incorporate the paramater that is
> passed to the report into the filename when he goes to save it.
> Thanks|||Thanks.
How would I render it in my own application? Can you send me some links?
thanks|||You might start here:
http://msdn2.microsoft.com/en-us/library/ms153586.aspx
"tigermike" <tigermike@.discussions.microsoft.com> wrote in message
news:03DA91F7-DA1B-4E05-B9C7-E13344EA5D69@.microsoft.com...
> Thanks.
> How would I render it in my own application? Can you send me some links?
> thanks

Export to excel problem

Hi,

I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

Thanks!

Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

Thank you,

Nico

|||

We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

Do you have Reporting Services SP2 installed?

Please let me know.

Alison

|||Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.

Export to excel problem

Hi,

I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

Thanks!

Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

Thank you,

Nico

|||

We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

Do you have Reporting Services SP2 installed?

Please let me know.

Alison

|||Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.

Export to excel problem

Hi,

I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

Thanks!

Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

Thank you,

Nico

|||

We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

Do you have Reporting Services SP2 installed?

Please let me know.

Alison

|||Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.

export to excel

Hi,

In my report, I have 3 rows in the details section. I need to show all the 3 rows into a single line when it is exported to excel. Is this possible to do in reports, please help me.

I don't understand what you're trying to accomplish; if you can explain in more detail maybe I can give better guidance.

Each row in RDL will be exported to at least one row in Excel (it may span rows depending on the content of the cells and the position of other report items).|||

Hi,

I want to export every 3 lines in my report into 1 line in an excel sheet. Is there any way to do that.

|||Sorry, no.

export session details

My (pull subscription) replication agents allow me to view each agent's job
history and seasson details in the replication monitor (Enterprise Manager).
How I can export this list to examine more closely outside of EM?
TIA,
Set HistoryVerboseLevel to 3. Now your history will not be overwritten, but
you will have a slight performance degradation. Now as you are using pull
the history will be retained on the Subscribers. DTS is locally. History by
default only hangs around 2 days, you might want to set the history
retention period to something larger. Do this by right clicking on
Replication Monitor and selecting Distributor Properties. Click on the
Properties button and set History Retention to something larger.
Hilary Cotter
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
"TCorp" <tcorpus@.hotmail.com> wrote in message
news:e$aY7jeqFHA.2876@.TK2MSFTNGP12.phx.gbl...
> My (pull subscription) replication agents allow me to view each agent's
job
> history and seasson details in the replication monitor (Enterprise
Manager).
> How I can export this list to examine more closely outside of EM?
> TIA,
>
>