Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > april 2006 > threads for tuesday april 11

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Adding Comments to Query
Posted by Mike Harbinger at 4/11/2006 8:01:59 PM
Since I compose my query in Query Analyzer and paste it into RS, I am trying to add comments to the top of my query to preserve my QA parameters as follows: /*Testing parameters declare @FromPostDate varchar(10), @AgingDate varchar(10) Set @FromPostDate='1/1/2005' Set @AgingDate= '11/1/2005'...more >>


Disable pagination in HTML reports
Posted by Maxwell2006 at 4/11/2006 7:54:12 PM
Hi, Is there any way to disable page breaks in HTML reports? I have a long list and SSRS puts page breaks within report. I need the whole report in one page. I cannot put a large number for the report page height because I don't know how big is my list and also I prefer to h...more >>

Can I export a report as PDF files within a DOS batch file?
Posted by Maxwell2006 at 4/11/2006 7:50:53 PM
Hi, Is there any command line tool that helps me to export a report into a PDF file? I need to do that within a batch file. I am trying to avoid C# coding to do that. Any help would be appreciated, Max ...more >>

Installing reporting services
Posted by Dean Garrett at 4/11/2006 6:58:01 PM
Hi, I installed SQL Server 2005 with Reporting Service, but when I try to run Reporting, I get the error below. I try using: http://computername/reports and http://ipaddr/reports Any clues??? Thanks!! Exception Details: System.Web.HttpException: The current identity (NT AUT...more >>

SRS 2005 Install
Posted by sullins602 at 4/11/2006 4:26:17 PM
Just need to confirm that I can install SRS 2005 from the SQL 2005 CD... Thanks ...more >>

Failure to Deploy
Posted by Don Olsen at 4/11/2006 3:53:02 PM
I am running VS 2005 and get the following error for several Report Models I am trying to deploy: Error 1 System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. ---> System.Web.HttpException: Maximum request length exceeded. ...more >>

Transaction log viewing
Posted by Byron Wilkinson at 4/11/2006 3:09:01 PM
I am looking for a symple transacvtion log viewing product that is capable of viewing multiple database types. Specifically SQL, Oracle and Sybase. Has anyone got any information on this. Any help will be appreciated....more >>

Drilldown in parameter pick lists.
Posted by Jan at 4/11/2006 2:59:49 PM
Is it possible to get drilldown functionallity in a parameter pick list? So that it is possible to expand/collapse items just like in e.g pivot table? Like: + All Time - 2000 - Jan - Feb - Mar etc - 2001 - Jan - Feb - Mar etc ...more >>



Request Length Exceeded
Posted by Mark Lauser at 4/11/2006 1:43:02 PM
I'm re-posting under an updated subscriber ID so Microsoft techs will answer... I am working in Visual Studio 2005. I have a Report Model project with a data source, a data source view which contains all of the tables in my database (SQL Server 2005), and a Report Model that contains the i...more >>

Multi-record wrapping textbox?
Posted by rpresser NO[at]SPAM gmail.com at 4/11/2006 12:09:31 PM
I know that the subject is badly expressed, but hopefully I can get the point across... I'm a total newbie at MS Reporting services and I have a question. I have a dataset something like this: Customer Box Item Qty A 1 X1 50 A 1 X2 50 ...more >>

Filter table
Posted by Jens Winter at 4/11/2006 10:09:42 AM
Hi, I want to filter a table. Unfortunately it doesn't work as I expected. My dataset contains a Number column. I want a table to display all rows with Number <= 27. When I insert a filter expression (Fields!Table.Number <= 27) in the properties dialog of the table the resulting table is...more >>

Multi-value Parameters not displaying correctly in the report
Posted by Jack Bender at 4/11/2006 10:07:02 AM
I have a report that uses multi-value parameters and the parameters are working correctly. However if I try to display the parameter values in the page header of the report with an text box expression formula like... ="Activity = " & Parameters!Activity.Value(0) ....it displays correct if...more >>

export to power point
Posted by Helen at 4/11/2006 9:21:01 AM
Is it possible to export the report to the Power Point? If it's possible How? I don't know if I can change the file rsreportserver.config in C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer can be changed. Thanks. ...more >>

Multi-Value Parameters
Posted by Doris at 4/11/2006 9:08:02 AM
When creating a dataset that uses multi-value parameters. what is the correct syntax for entering multiple values for the parameter to execute the query? ...more >>

Q: record in the dataset
Posted by JIM.H. at 4/11/2006 8:31:02 AM
How can I check if there is any record in the dataset in my report?...more >>

Report is cached
Posted by Markgoldin at 4/11/2006 7:54:02 AM
Is it possible that the report is cached and I see outdated data?...more >>

Displaying various instances of the same report in one report
Posted by Mathias at 4/11/2006 7:42:46 AM
Here's my problem. I have a report that displays information for one office. The users are now asking for a master report where they can display all of the offices in their group. I'm thinking I can do this with a sub report but I don't know enough about subreports to set it the passing of mu...more >>

Exception of type Microsoft.ReportingServices.ReportProcessing.bk
Posted by NO[at]SPAM at 4/11/2006 7:11:02 AM
Hi, I am receiving the following error for a new data driven subscription I have setup. Exception of type Microsoft.ReportingServices.ReportProcessing.bk I have searched this newsgroup and google and can't seem to find any description of the error. The RS logs also yield very little oth...more >>

Multi value parameter issue?
Posted by gte401e at 4/11/2006 7:00:02 AM
How do I make a mvp optional? I don't want to always have to select a value for it. Thanks in advance ...more >>

Table Column headings not repeating on new page
Posted by CraigW_Reid at 4/11/2006 6:12:05 AM
Hi Using SQL2000 Reporting services, my report has a table with two columns that when rendered into PDF can sometimes cross over a physical page break. My table has a report header that shows the colum header for each colum, the repeat header rows on each page property is set, however this doe...more >>

Use a button on a report to push insert data in table on sql server
Posted by Policarpo at 4/11/2006 2:14:43 AM
Hi, I'm using Reporting Services as a form of presenting pre-reports so that someone can look at it and validate the report, so when it's valid i want to use something (i was thinking of a button) to push data into another table in SQL Server. Is it possible to include a push button in the re...more >>

SSRS 2005 and MHTM Export Format
Posted by Maxwell2006 at 4/11/2006 12:28:54 AM
Hi, We are using SQL Server Reporting Services 2005. I understand that MHTML is the closest report export format to HTML that I can get from SSRS. We have to extract HTML files from the MHTML files to HTML. Is there any tool, utility or trick that extracts all files with...more >>


DevelopmentNow Blog