Search results for query: *

Hi All, Have a weird situation here. Have this report with 6 parameters, typical string fields. Have dozens of users accessing the report no problem. However 1 user, no matter what she enters in the parameter fields, is never able to have the report work for her, the parameters are always being...

Thanks Geoff, That's exactly the solution that I came up with yesterday. Worked like a charm! I appreciate the reply, Joe

Hi all, hoping someone can help. I have a report that creates a Purchase Order. I'm being asked to attach "Terms and Conditions" page to the report (page 2). This new page can vary based on the sales region, and I've been provided 12 different versions of terms and conditions, already formatted...

Hi All, Is there a way to get a table header to repeat on new pages when exported to Excel? I have the "Repeat header row on each page" selected, and it works fine when exporting to PDF, but in Excel, new pages don't have the table header. I'm using Reporting Services 2005. Any help would...

Right now I pass NT account names to each sub report and each one is validated that way. So I'm able to prevent the actual information from being displayed, but I was really hoping there was a way to simply not have these reports show up at all. Thanks for taking the time to try to help out.

Thanks for the reply. That works fine when you're in the main report trying to filter when the sub-report is displayed. What I'm looking for is when a user goes into in the ReportServer site, and sees the actual physical reports (and sub-reports). I want to prevent them from actually executing...

Hi All, Is there a way to include a sub-report in a report from a url rather than from the same project? Reason I'm asking is because I have a report with 4 sub-reports in it. I want users to access the main report directly, and not the subreports. I've hidden them, but a user just has to...

Hi All, Is is possible to control folder/report access rights directly from the ReportServer table (using SQL Management Studio)? I have a table with hundreds of user names and need to assign different rights to reports/folders for each user. I will obviously prefer to do this through a SQL...

Hi all, Is there a way to have a data-driven subscription that only emails out the report when there is data? I currently have a report that exports to Excel. When there is no data, users are getting blank excel workbooks. I would like for the report to only be sent to users that have data...

Hi all, I've created a report when one of my parameters has 2 non-queried available values (where values=True/False), and my data type is set as boolean. This works fine in the preview, however when I deploy it, my dropdown suddenly becomes two radio buttons labeled true/false. Anybody have an...

Thanks for the suggestion, I'll give it a try. I just thought there was something obvious I wasn't seeing. Thanks!

Hi all, is there a way to have my project images in a separate folder under my project (ie myproject/images)? Right now whenever I add a project image (using the wizard), it places the image in my root project folder with all my report files (RDLs). Now when I deploy the report, my image files...

Hi All, I have this simple report with a table in the layout with two fields in it. When I preview the report, all is fine. When I deploy and view in FireFox, the display area is very small and scroll bars are supplied (vertical), as if a DIV was supplied, limiting my display area for the...

It happens all the time, just more of an obvious issue on the larger files. Haven't specifically searched MSDN, been googling everywhere for any kind of info, seems difficult to find. I'll try MSDN to see if I have any luck. Thanks!

The result of executing the routine we have to export the contents of a datareader to Excel (previously attached code), is a File Download window coming up, with the options to Download, Save, and Cancel. The file type listed on the window is Microsoft Excel Worksheet, 11.5mb I hit download...

The resulting file once I save as XLS looks exactly the same, it's just about half the size. Unfortunately, this is happening on a large scale (hundreds of exports/day) and is definitely hurting our servers. I don't know why the file being sent is so much larger, and not defaulting to XLS, even...

Hi all, Hoping someone can shed some light on this one... We have a web page that exports the contents of a datareader to Excel, using the attached code. All works well most of the time, except for larger extracts. For some reason, the resulting spreadsheet is quite large (ie 11.5mb). When we...

Hi all, I'm having a problem with one of my DTS jobs. Basically it runs a query and exports the results to an Excel template I have created for the report. The DTS works fine, but in my resulting excel workbook, numeric fields are being formatted as text, even though they're clearly numeric...

If I were to create a web service to process the Excel requests, am I better off processing it pretty much the same way I am right now? Basically user clicks the export to excel button, a web service grabs this requests, processes the query into a SQLDatareader, and uses a function similar to...

Thanks for you reply. I am paging the data, I only display 15 records at a time on-screen, showing page x of y. When the user chooses to go to the next page, the stored proc is executed again returning the next 15 records. The paging is being handled at the stored proc level. This is often ok...