Correction: Minor pdf-rendering error.

Hi.

We use RS intensively in our app. However, we have had several reports from our customers, that they cannot open our pdf-files on their macintosh computers. I have investigated the problem, and found that this is due to a very simple omission in the rendered pdf.

Apparently the 1.3 specs requires a "carriage return" (char decimal value 13) after the %%EOF-element. If I add this manually, the files open just fine on mac.

Is this a known issue?

Is there some way to get around it, apart from adding it manually in the code?

- Kristian

(Note: There might be some pdf-readers for mac that can read these files, but we have no way of controlling our customers ap-selection.)

I was a little fast on the trigger there.

After manually adding the carriage return, they still do not open on mac. It only made some of the unix-tools we used for testing stop complaining (pdf2ps).

Are there any known issues with pdf-files from RS and Macintosh compatibility.

|||

We found out, that if we installed Adobe Reader on the Mac, we could view our file.

So it's propably the internal (default) pdf-viewer, that doesn't understand the RS pdf format.

Copying reports to server

What is the best/fastest way of copying lots of user developed reports from
one server to the other.
TIA..Copy the RDL if you have access to it.
"sqlster" <trisha@.nospam.nospam> wrote in message
news:2DE69E99-C99B-4844-8B46-805E0F265E4E@.microsoft.com...
> What is the best/fastest way of copying lots of user developed reports
> from
> one server to the other.
> TIA..|||No, this does not work. At the server the RDL does not exist as a file, it
is stored in the database. You have to either manually extract the RDL using
Report Manager or using scripting. For a lot of reports, scripting is best.
Search Books Online on the word scripting. Also, a variety of people have
posted about scripting this as well. It ships with a scripting example for
publishing reports, need to have a script to extract the reports and then
you are good to go.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Patrick Allmond" <patrick24601@.yahoo.com> wrote in message
news:Y_pIe.65331$5N3.3008@.bgtnsc05-news.ops.worldnet.att.net...
> Copy the RDL if you have access to it.
> "sqlster" <trisha@.nospam.nospam> wrote in message
> news:2DE69E99-C99B-4844-8B46-805E0F265E4E@.microsoft.com...
>> What is the best/fastest way of copying lots of user developed reports
>> from
>> one server to the other.
>> TIA..
>|||Can anyone point me in the direction of a sample script ?
I know reports can be published using the rsutility, but i dont know of any
equivalent to extract or copy the rdl files once they have been uploaded.
Regards
Kamlesh
"Bruce L-C [MVP]" wrote:
> No, this does not work. At the server the RDL does not exist as a file, it
> is stored in the database. You have to either manually extract the RDL using
> Report Manager or using scripting. For a lot of reports, scripting is best.
> Search Books Online on the word scripting. Also, a variety of people have
> posted about scripting this as well. It ships with a scripting example for
> publishing reports, need to have a script to extract the reports and then
> you are good to go.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Patrick Allmond" <patrick24601@.yahoo.com> wrote in message
> news:Y_pIe.65331$5N3.3008@.bgtnsc05-news.ops.worldnet.att.net...
> > Copy the RDL if you have access to it.
> >
> > "sqlster" <trisha@.nospam.nospam> wrote in message
> > news:2DE69E99-C99B-4844-8B46-805E0F265E4E@.microsoft.com...
> >> What is the best/fastest way of copying lots of user developed reports
> >> from
> >> one server to the other.
> >>
> >> TIA..
> >
> >
>
>

Copying Reports in Report Manager

Is it possible to create a copy of a report in the report manager?
I want to be able to deploy one copy of the report and have users create
multliple copies - each with their own default parameter and name.You can use the Web Service CreateReport method.
Check out this link http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/RSPROG=
/htm/rsp_ref_soapapi_service_ak_1xfd.asp
You will have to manipulate the rdl file from code.
>--Original Message--
>Is it possible to create a copy of a report in the report
manager?
>I want to be able to deploy one copy of the report and
have users create >multliple copies - each with their own default parameter
and name.
>.
>sql

Copy SSRS 2005 Reports & Data Sources from Production Server to New Test Server

I need to create a copy of my existing SSRS 2005 reports from SQL 2005 on my production server to my new test server. I am not sure how to port everything over. I may have to just redeploy the reports...that's fine with me, but just windering if there was a tool to tell SQL 2005 to create a separate non-related copy of everything in my current SSRS Production server to my new test server.

Also what's the best way to manage the dev vs. prod reports? If I'm developing a report on my dev server, the datasources will be pointing to that server. Come time to move it to production right now I've having to create another datasource and change all my datasets in a particular report to point to a datasource that points to my production server, then deploy. Is there a better and easier way to do this rather than switching all my datasets to the production server manually then deploying?

You can look into managing it through Management Studio and/or creating RS scripts.

Another option is to use the RS Scripter tool by Jasper Smith: http://www.sqldbatips.com/showarticle.asp?ID=62

-- Robert

Copy Sql Server Reports to Flash Drive

Hi- What do I have to copy to my flash drive to transfer reports from home to work? I am using Sql Server Express w/ advanced services.

Yes, I'm new to this, but learning. Thanks in advance!

JP

You'll need the RDL files and the data source file if using a shared data source.