all groups > sql server reporting services > april 2006 > threads for thursday april 20
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
Multi-Select Value dropdown "Select All" in SP1
Posted by Tom.Rally at 4/20/2006 10:29:01 PM
Hi,
With SQL-Server 2005 SP1, the "Select All" in the dropdown does not appear.
Without SP1 the "Select All" in Multi-Select Value did appear. How can I fix
it?
Regards,
Tom
... more >>
display parameter value on Report Builder generated report
Posted by minority at 4/20/2006 7:15:50 PM
hi all,
is it possible to display the parameter value on the report for
parameters which contain multiple selection ?
i can display the parameter value if it has only 1 value. how can i
display the values if there are more than 1 ?
Thanks!
... more >>
next 30 days or all values
Posted by jasrus at 4/20/2006 7:07:11 PM
Hi,
I have a dataset and I need to be able to filter that data based on
Completion Date.
I have created a user parameter is SSRS with the following values:
0 = All Dates
1 = Next 30 days
I am trying to filter my dataset but I don't know how to filter this
based on my user parameter.
He... more >>
Configuration SQL Server 2005 Report Services
Posted by Joe K. at 4/20/2006 4:40:02 PM
I have SQL Server 2005 and SQL Reporting Services installed on my server
with IIS.
I would like to obtain instructions to configure the SQL Reporting Services
on this server.
Thank You, ... more >>
Deploying a Reporting Model
Posted by Justin at 4/20/2006 4:39:01 PM
I'm trying to deploy a Reporting Model (.rmdl), but it continues to give the
standard error message of "The permissions granted to user <me> are
insufficient for performing this operation".
I am an Administrator on the computer and have given myself every possible
permission in the Reportin... more >>
Page Breaks
Posted by ERS Developer at 4/20/2006 3:50:02 PM
Hi,
I am using RS 2000. and have a problem with the Page break.
I have header and footer in my report and a 2Tables in the Body part.
If the number of rows in the table1 exceeds some records(say 100) the page
is printed in 3 sheets.
FristPage :with Header and footer and Table1 75 Records.
Sec... more >>
SQL Server 2005 / MS SQL Server Report Pack for IIS
Posted by Joe K. at 4/20/2006 2:44:01 PM
I have website that uses Microsoft SQL Server 2005 databases for backend
storage.
Listed below Microsoft SQL Server Report Pack for Internet Information
Services (IIS). This package has the capablility to create reports for
number of users connected to the webite and many statistic data.... more >>
2k5: Interactive Sort - Total Line moving
Posted by Steve Funk at 4/20/2006 1:00:02 PM
When using the interactive column sort in a table, I have one report that the
Total (footer) actually moves with the interactive sort. How can I keep the
footer fixed as the footer?
--
Steve Funk
Application Developer
iHomeowners, Inc.... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
image won't show up
Posted by jenr at 4/20/2006 12:20:44 PM
Hey all,
I have an image to put into a report. It's a jpg. I can see it in
layout view, but in preview or when deployed, i get a red "x" - any
idea why or how to fix it? Thanks!!
jenr
... more >>
where are the stored procedures fields in report design?
Posted by SK at 4/20/2006 12:11:02 PM
When I call a stored procedure in the data tab of SQL Server Reporting
Services 2000, The fields do not show up or disappear.
Does anyone know why? How can I drag the fields from the stored procedure
into the layout?
Thanks for your help.... more >>
Clustering Reporting Services
Posted by Alex Anderson at 4/20/2006 10:55:02 AM
Hello,
I'm running a two node cluster, Windows 2003 R2 and SQL 2005. Does anyone
have a white paper or documentation that tells me how to install Reporting
Services as a clustered service? I've never set up a web farm or anyting of
that nature, so any information regarding this would be g... more >>
charlist_to_table for mvp function
Posted by Lisa at 4/20/2006 10:02:02 AM
Hi, I found the following function on this site and am trying to use it my
reports.
The dataset for my mvp is different from my stored proc I'm using.
The data set for my mvp is simple
codes dataset =
select distinct codes from tbl_codes
values are
AAA-2222
BBB-3333
CCC-444
In... more >>
Oracle with Reporting Services
Posted by jdcamp at 4/20/2006 9:32:18 AM
I am trying to connect to an Oracle database using Reporting Services.
I create a new Shared Data Source, give it a name, then hit the edit
button. Set the provider to Microsoft OLE DB Provider for Oracle, on
connection tab I enter
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST =
server.som... more >>
Isstallation - licenses
Posted by MANCHO at 4/20/2006 8:58:02 AM
Hi,
Is there any general recommendation if SSRS should be on the same
server/different server than the SQL Server Database and Analysis services?
Can the SSRS be installed on another(remote ) server than the SSDS andSSAS?
IS there any licensing problems if this is done?
Thanks.
... more >>
can a report read parameters from POST as opposed to GET?
Posted by awtesta NO[at]SPAM gmail.com at 4/20/2006 8:39:30 AM
My scenarios is that I have to have an ADHOC report page, which will
allow the user to select various attributes, and I have to then create
the SQL clause on the fly, based off these selected attributes. I then
have to have the report in reporting services run off of that generated
SQL clause.
... more >>
Calculated Measures
Posted by Al at 4/20/2006 8:34:15 AM
We are presently having an issue where if we use calculated measures an MDX
query that takes about 1-2 seconds to run suddenly takes about 1.5 minutes
to run. These measures are not extremely complicated they are simple like
taking TotalDollars/TotalUnits. TotalDollars and TotalUnits are alr... more >>
Chart borders not hiding when no data is returned
Posted by Rabbit at 4/20/2006 8:18:47 AM
I do not have much experience with reporting services or Visual Studio.
I'm trying to upgrade some reports from reporting services 2000 to
reporting services 2005. One of the reports I'm working on contains 5
charts. In the 2000 environment when no data is returned for a single
chart, the char... more >>
Suppressing Sub-Reports
Posted by mkipiniak NO[at]SPAM hotmail.com at 4/20/2006 8:00:09 AM
I have a report that calls a sub-report if a certain ID is present. I
have code in the visibility property that displays or hides the
sub-report based on that factor. The code is in the Visibility
(hidden) expression of the table row
=IIF(IsValue.Value ="Y",false,true)
Real-Estate is huge... more >>
.Net framework for SSRS 2005
Posted by siaj at 4/20/2006 7:47:02 AM
Hi,
We are plannning to upgrade to SSRS 2005 from SSRS 2000.
Does it mean that our clients/users will have to upgrade to framework 2.0
from framework 1.1 inorder to see the SSRS Reports ?
Thanks in advance !
siaj
... more >>
rs script utility and vbScript
Posted by ghealy NO[at]SPAM gmail.com at 4/20/2006 7:12:46 AM
Hi,
I've modified PublishSampleReports.rss and it is working fine to deploy
reports, set data sources and update parameters. However, there is one
thing I can't seem to get working....
I'm trying to read the list of report names to be deployed from a text
file. To do so I was using the fo... more >>
Forcing '0' to set number of decimal places
Posted by MACNR at 4/20/2006 1:55:01 AM
Ok heres my problem.
Ive got a field that is rounded off to a set number of decimal places that
is defind in another field. Heres the code...
=ROUND (Fields!Transaction_Quan_.Value, Fields!Decimal_Places.Value)
my problem is that when the value is zero, it returns just 0, not 0.00 for
... more >>
Upgrading to 2005 - are there issues?
Posted by Will at 4/20/2006 1:33:38 AM
Hi All,
I'm about to upgrade a SQL server 2000 to SQL 2005, including reporting
services. There's already a lot of reports, that probably use every
feature known to reporting services (which for the reporting services
2000 isn't much ;) ).
I was wondering if anyone had any advice about the ... more >>
Please Help Me !
Posted by Meftah Tayeb at 4/20/2006 12:09:53 AM
I am as Visual Basic 6.0/.Net Developer
Wath Is The Microsoft SQL Server Reporting Service ?
Wath Is The Microsoft SQL Server Analisie Service/Olap?
Wath Is The Microsoft Engleech Query ?
Thank You !
... more >>
Merge cells vertically
Posted by Jens Winter at 4/20/2006 12:00:00 AM
Hello
Is it possible to merge cells of a table control vertically?
See the second column in this example:
+----+---------+
| | |
+----+ |
| | |
+----+---------+
Ciao,
Jens... more >>
ReportViewer not displaying report
Posted by Doug Stiers at 4/20/2006 12:00:00 AM
I'm using the following code to run a report on a simple web page, VS2005,
SQL 2005, RS 2005. For some reason the parameters retreive but when I run
the report there is no data at all displayed. It's a very simple report
reading straight from a table.
Protected Sub Page_Load(ByVal sen... more >>
|