Reports

Remove/hide Navigation-Search menu
Is there any way to remove or hide the links (Home/My Subscriptions/Help/Search) in the upper left corner of all pages? Pete ... 8 Mar 2010 15:18

Bypassing parameters in reports
Hi, I have a report that, before it runs, displays a drop-down list of parameters for a user to select. Call it Report01. It would be useful to, from other places, say from Report02, to call Report01, but to pass it a parameter value. In such a case the dropdown list should not appear, and Report01 should b... 9 Mar 2010 06:45

SSRS 2008 working with table of contents
I have the following questions about creating sql server 2008 reports: I am creating a report that will contain the following: a. page header with the title of the report, b. page footers that contain the page numbers, and c. table of contents to tie about 27 subreports together, d. several of the tables i... 6 Mar 2010 11:52

If you can determine the number of records per page this solution isbest
I think the previous solution using code always shows Page 1 of 1, at least in my tests on SSRS 2008. There's another solution is you can determine or customize the number of rows per page. http://www.easkills.com/ssrs/determinepagenumberinssrs20052008 jer wrote: This is an older post, but I tried to fi... 5 Mar 2010 15:06

Incomplete RecordSet rendered in report
When I use the query builder to view a select query I get the expected number of rows returned. When I view this in report mode only records with the first instance of a certain field are rendered. ie: select * from foo order by Field2 Returns all records in the Query Builder Returns only the first instance o... 5 Mar 2010 19:38

Cascading parameter doesn't work right in BIDS, but works fine in
FYI: SSRS 2008 on SQL 2008, VS 2008, BIDS 2008. I have a RDL that is very basic with a cascading parameter. At this stage, it is only parameters because the actual intense data gathering wasn't programmed because of the cascading problem. This problem seems to be different than the other 3rd parameter proble... 5 Mar 2010 12:50

Analysis services connection using Excel
Server- remote win2k3 server running sql2k8 in workgroup setup - no AD. Client - Xp prof connect to server via vpn and rdp I am trying to connect to sql database from Excel , data , from other sources, from analysis services using windows authentication and I am getting an error " Errors in OLD DB provider. ... 5 Mar 2010 12:50

SSRS - Setting Permissions Through Stored Procedure
Is it possible to change the list of reports a user can access through stored procedures? At the moment I run a stored procedure to get a list of all reports a user has access to but then change permissions manually as I don't have a definitive list of all relevant SQL Server tables. SQL Servant ... 5 Mar 2010 11:42

Displaying text into Sql reports
I would like to know what I can use in sql server report 2008 to display several sentences or paragraphs prior to where I have a table generated. Each table in each report will display the data. To display the paragraph(s) and/or sentence(s) before the table containing data what toolbox item would I use? Should... 8 Mar 2010 03:11

The request failed with HTTP status 400: Bad Request.
Try mapping your ID at following location. C:\WINDOWS\system32\drivers\etc\hosts Let me know if that works or not. suresh kumar wrote: The request failed with HTTP status 400: Bad Request. 04-Sep-07 Hey Peter, The problem 'm facing is... After assigning IP address for the default web site in I... 5 Mar 2010 05:04