all groups > sql server reporting services > july 2007 > threads for july 29 - 31, 2007
Filter by week: 1 2 3 4 5
Select All and OLAP
Posted by RSDev at 7/31/2007 9:28:42 PM
I am using Reporting Services (2005 sp2) to display data from an Analysis
Services (2005 sp2) cube. I am using parameters and have a few questions in
regards to the Select All option that is available in the multi-select
parameters that I have.
1) Is it possible to remove the Select All fro... more >>
Reporting Services Report Hangs
Posted by Jim B at 7/31/2007 2:14:04 PM
Variable number of subreports
Posted by Eric at 7/31/2007 8:46:24 AM
Hello,
I know this is possible -- I just dont know the best way to address
it. I have a report that takes a month/year. Users enter the month/
year and then how many months to show (so entering 1/07 with 3 months
would show three reports -- 1/07, 2/07, and 3/07).
The report for each month... more >>
Help with layout of a 'details' report
Posted by Canice at 7/31/2007 7:19:15 AM
I'm trying to layout a report with the data from specific rows placed
in TextBoxes, as I want to use the report for printing out details.
My DataSet has 2 colums: 'QuestionID' and 'Answer', eg:
QuestionID Answer
----------------------------------
100 Some text
101 ... more >>
Customizing Report manager
Posted by Deepya at 7/31/2007 4:50:02 AM
Hi,
I want to add a new button to Report Manager toolbar and add some
functionality to it.
Can anyone suggest me how to do this.... more >>
Urgent: How to filter data for each user
Posted by MIB at 7/31/2007 2:48:02 AM
Thanks for your help.
We are using reporting services on a server (B), but the data are on an
another server (B). I have applied security for different type of report,
but i would like to know how could i for one report filter data for each user.
Example: I have a report on Sales USA, only pe... more >>
Get current logged-in username in report
Posted by Alex at 7/31/2007 12:00:00 AM
Hi,
I'm writing a report in VB.Net 2003 for MS SQL 2005 Reporting Services, and
I need to pull in the current user logged into the computer running the
report so this will print on the report. Basically whoever is generating
the report. Is this possible? I wasn't sure if there's a list o... more >>
IF...Then...Else expression
Posted by abz at 7/30/2007 10:39:14 PM
Hello everyone, I'm having trouble writing an IF...Then...Else
expression. I'm still new at vb so all help available is helpful. So
far this is what I have.
=IF [Sum(Fields!HRS.Value) * 14.04] > [Sum(Fields!AMT_EARNED.Value)]
THEN
[Sum(Fields!HRS.Value) * 14.04] - [Sum(Fields!AMT_EARNED.Valu... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ASP.Net ReportingServices & CPU Usage
Posted by Blasting Cap at 7/30/2007 4:23:45 PM
I have a report (stored procedure) that I have set up in SQL 2005
Reporting Services. In a web app, I put a Reportviewer control on the
page, and call the report. After a lot of trial & error, it appears to
work.
Sort of.
What happens is when I open it on that tab (I am using AJAX Tab ... more >>
WEB SERVICE IDENTITY EMPTY
Posted by Mark at 7/30/2007 3:56:00 PM
Hi everyone,
my server windows 2003
sql server 2005 reporting services
when I go to http://server/reports it works fine
when I open Reporting Services Configuration the Web Service Identity is red
The ASP.NET Service Account is blank and I can't type in the box.
I have 2 virtual di... more >>
Prevent overwrite on error
Posted by Shannon at 7/30/2007 3:32:04 PM
We have a report that runs every 15 minutes and saves the results to a file
share that is referenced by a web site.
Is there a way to prevent the previous report from being over written if the
report has an error?... more >>
Can I Use SQL Server 2005 Developer Edition For Client Tools?
Posted by MIA Mark at 7/30/2007 1:46:07 PM
My ISP has me licensed for a production SQL Server 2005 database, yet they
cannot provide me with the client tools that I need, specifically SQL Server
Management Studio and SQL Server Business Intelligence Development Studio.
If I purchase SQL Server 2005 Developer Edition will it have these... more >>
Reports broke from remote
Posted by MSNewsGroup at 7/30/2007 12:06:22 PM
Hello
Recently this one report errors as below when running on any machine except
the actual server hosting the
reporting services.
a.. An error has occurred during report processing.
a.. Cannot create a connection to data source 'databasename.
a.. For more information about this ... more >>
Postal Codes 10001-10005 as a parameter
Posted by Marc at 7/30/2007 6:54:02 AM
Dear all
I like to implement a parameter in SSRS SP2, that accepts values like
10001-10005 as postal code. This should be translated to 10001, 10002,10003,
10004, 10005.
I tried to realize this with the following code:
Function SplittingCodes(ByVal s As String) As String
Dim... more >>
dynamically sort columns?
Posted by paulhux174 NO[at]SPAM hotmail.com at 7/29/2007 9:03:57 PM
Hi,
Can you set up a report so that you can dynamically sort columns.
ie.
When viewing a report you click on a header of a column and sort by
this column.
If so can you point me to an example
Thanks in Advance
... more >>
|