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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|