question

WayneEmminizer-1503 avatar image
0 Votes"
WayneEmminizer-1503 asked WayneEmminizer-1503 commented

Report Custom Export Type Problem

I have inherited an SSRS report that is exported to an "ASC" report format which is nothing really more than a text file. When logged into the server as an Administrator the export works perfectly fine. Any other login however generates the missing xslt error and I have no idea where to go to make this work. Any direction would be greatly appreciated. Thanks!

85363-image.png

85345-image.png


sql-server-reporting-services
image.png (99.2 KiB)
image.png (129.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

WayneEmminizer-1503 avatar image
0 Votes"
WayneEmminizer-1503 answered WayneEmminizer-1503 commented

Thanks for the response @Zoehui-MSFT . That link was extremely helpful. I queried the Catalog and there is an entry for the xslt in the table. We have another server with the same setup and it works fine for all users. I checked the catalog entry for both xslt entries and they seem the same. The "Path" field indicates the xslt is in the same folder as the report. I checked the server that's working and I don't see that file in the online display of the folder. Do you know if there's a way to "see" this file?

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sorry that I haven't found a ready-made way to "see" the file.😢

0 Votes 0 ·

This led me on the path to the solution which was actually a duh moment. The xslt file exists on the server and the whole time I knew it had to be a rights issue in SSRS but didn't know why or how. Turns out the xslt file was put up to the site and assigned Adminstrator only rights so it was only accessible to the actual Administrator login. I reverted security and bam, works like a charm. Thanks!

0 Votes 0 ·
ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @WayneEmminizer-1503,

May I know if you export the report to other format such as excel, pdf and so on will re-produce the issue or not?

Not familiar with XSLT and I did some online research.

As mentioned here , someone said that the XSLT file must be placed in the same folder as the report.

You may have a try to see if it could give you some idea.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.