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!

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

Recent content by Yazster

  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

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

Part and Inventory Search

Back
Top