Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Yazster

    Parameters not working

    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...
  2. Yazster

    Attaching external PDFs to a report

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

    Attaching external PDFs to a report

    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...
  4. Yazster

    Table Headers not repeating in Excel

    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...
  5. Yazster

    Preventing direct access to sub-reports

    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.
  6. Yazster

    Preventing direct access to sub-reports

    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...
  7. Yazster

    Preventing direct access to sub-reports

    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...
  8. Yazster

    Controlling access rights through ReportServer DB

    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...
  9. Yazster

    Data-Driven subscription with no data

    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...
  10. Yazster

    Dropdown displaying as radio options when deployed

    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...
  11. Yazster

    Project images

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

    Project images

    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...
  13. Yazster

    Table Size

    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...
  14. Yazster

    Need help with Excel Exporting

    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!
  15. Yazster

    Need help with Excel Exporting

    ...server to the client, launching Excel and displaying the file. Once in Excel, if I save the workbook, the current file type displayed is WEB PAGE (*.htm,*.html). If I change this to excel and save, the resulting file is 5mb. So I'm wondering why the original transfer from the web server to...
  16. Yazster

    Need help with Excel Exporting

    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...
  17. Yazster

    Need help with Excel Exporting

    ...For some reason, the resulting spreadsheet is quite large (ie 11.5mb). When we go to save it in Excel, the default type is set to WEB PAGE (*.htm,*.html). When we change this to Excel, and save, the resulting file is now 5mb. Is there any reason why the produced file from the web page would...
  18. Yazster

    DTS package exporting to Excel - Formatting issues

    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...
  19. Yazster

    Export to Excel feature - Need advice please

    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...
  20. Yazster

    Export to Excel feature - Need advice please

    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...

Part and Inventory Search

Back
Top