all groups > sql server reporting services > october 2007 > threads for october 29 - 31, 2007
Filter by week: 1 2 3 4 5
Optional filtering by parameter
Posted by Dmitry Duginov at 10/31/2007 2:13:05 PM
Can anybody suggest the easy way to add an optional parameter to the report?
Example: Without this "feature" the report contains records for the groups
A, B, C, etc. I'd like to add the parameter "SingleGroup". By default it is
null and the report should work exactly as before. If I set the v... more >>
loading a report in a windows application using reportviewer
Posted by billyburditt NO[at]SPAM gmail.com at 10/31/2007 10:56:13 AM
I have a windows application which displays a remote report using the
reportviewer. It works fine except on the form load it runs the
report. I rather the report just display instead of running. This is
a problem for two reasons:
1. My report has parameters. Since no parameters have been ... more >>
Creating SSRS folders?
Posted by jobs at 10/31/2007 10:13:45 AM
New ssrs istall.
When I attempt to open report manager, i just get
SQL Server Reporting Services
Home
with no option for creating a folder etc, like i have on development
When I attempt to deploy to ther server I get :
Deploying to http://amsqlclusterxx/reportserver/
Error rsItemAlr... more >>
Speed up software.
Posted by Scott Burke at 10/31/2007 9:59:07 AM
I use Microsoft Visual Studio 2005 to write my reports.
When I run the reports in VS it takes forever to run.
I checkec the task manager and the System Idle Process is 70% while the
reports are being processed.
Question:
Does anyone else have this problem?
Does Microsoft Visual Studio 200... more >>
Change Subreport Name while running
Posted by Harry Leboeuf at 10/31/2007 9:46:37 AM
Is there a way to change the subreport name while running a report.
Depending on the user that runs the main report i would like to present
another subreport.
The subreportname can't be changed by an expression.
I could place all subreports on it and then hide the ones that arn't needed
but... more >>
Can't deploy report on the reporting server
Posted by andys at 10/31/2007 9:26:00 AM
Please help -
I am trying to deploy report on the server - getting following:
===================================
A connection could not be made to the report server
http://169.35.137.96/ReportServer/. (Microsoft Report Designer)
===================================
The server committ... more >>
Chart error: Parameter is not valid
Posted by Rolf Smeds at 10/31/2007 5:52:03 AM
Hi,
I'm using Reporting Services 2005, trying to design a report in Visual
Studio 2005.
I have a chart in the report that seems to work just fine when I test it
with Preview.
However, every now and then, if I change some trivial detail in the chart
properties, such as the title font, ... more >>
SQL SERVER 2003 - Report Server
Posted by Logger at 10/30/2007 4:22:01 PM
Does Microsoft keep a previous version of the .rdl if you deploy a report in
Visual studio 2003? If so, how do you retrieve it?
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to add a calender with a user parameter
Posted by rampaleee NO[at]SPAM gmail.com at 10/30/2007 3:11:33 AM
Hello evry one,
Can any one help me how to add a calender as a list of
values,to an user parameter in reports. I am passing a parameter
called effective date. for that parameter i need calender as a list of
value. Please any one help on this..
thanks
Balaji
... more >>
Image not displayed in report
Posted by Kirk at 10/30/2007 12:00:00 AM
I am creating a very simple report in VS 2005. I dragged an image
control to the report surface and set it's value property to the
virtual path of my image (like "~/SubPage/Trademark.jpg"). However,
the image is never displayed - either at design time, when the report
viewer runs, or when the ... more >>
How to Block a System Administrator in RS
Posted by Harry Leboeuf at 10/30/2007 12:00:00 AM
My machine is in a domain.
The local group Administrators had a member that is the Domain Admins.
Our Tech Support has configured this like that.
Now, in the Home directory i've deleted the BUILTIN\Administrators from the
users and groups that can access the tree. Even on some directories i'v... more >>
Excel Report - Large File
Posted by Madhan Raj J at 10/29/2007 10:46:01 PM
SQL Server 2005 reporting service is being used to generate a large excel
report with about 30,000 rows. The size of file generated is ~15MB. but if
the same file is opened in Excel 2003 and saved back in XLS format itself,
the size of the file reduces to approximately 50% of the original size... more >>
Reporting Services - Local Report - Memory & Session Usage
Posted by Antony at 10/29/2007 8:19:00 PM
Hello there, I'm currently experiencing some issues with Reporting
Services' ReportViewer Control. When running the control without a Reporting
Server in 'Local' processing mode we cannot serve very many simultaneous
requests. Worse, if a single user opens several reports one after the oth... more >>
Published Report Not Showing Correctly in Report Manager webpage
Posted by RBS at 10/29/2007 11:56:02 AM
have a report that in the designer in Visual Studio it displays correctly on
the preview tab.
The report has 5 subreports and one of the subreports is a matrix.
On the report I have a parameter for the user to choose rather to see the
matrix subreport or not.
When I view the rep... more >>
I want duplicates in my matrix!
Posted by Mike Austin at 10/29/2007 10:41:13 AM
I have a very simple report that allows users to extract data to an excel
spreadsheet and work with it. It consists of a single matrix with 3 row
groups, 1 column group and 1 "fact" cell. When it is run, either in preview
or deploy mode, the report is hiding duplicate values in the first colum... more >>
Using parent datatable row in the report table object
Posted by Sanjin at 10/29/2007 7:32:00 AM
I have the dataset with the following tables, Products and OrderDetails.
The structure (simplified):
CREATE TABLE [dbo].[OrderDetails] (
[Id] [int] NOT NULL ,
[ProductId] [int] NOT NULL ,
[Quantity] [numeric](18, 2) NOT NULL ,
[Price] [numeric](18, 2) NOT NULL
) ON [PRIMARY]
GO
CREATE T... more >>
Dynamic Parameters
Posted by brinda.shree NO[at]SPAM gmail.com at 10/29/2007 1:58:46 AM
I need to build a report in which every field of the dataset acts as a
Parameter to filter data in the report, so that the user is not binded
only to a fixed set of filters.
Based on the datatype of the filter; the condition should be specified
and the user will only supply the value for which... more >>
|