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 > 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
-- Thanks, Jim...more >>

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 >>



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 >>


DevelopmentNow Blog