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 > may 2006 > threads for wednesday may 24

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 31

License Question
Posted by Aussie Rules at 5/24/2006 9:50:48 PM
Hi, If I design a report using Reporting Services in SQL 2005 Enterprise, but then deploy into a SQL2005 workgroup environment, is that ok? Will the report even work ? Thanks ...more >>


How to have parameter accept wildcards
Posted by AmytDev at 5/24/2006 4:08:02 PM
I have a report that selects certain records based on what the user enters for the parameter but I'm trying to allow the user to enter a wildcard and show the relevant records. I used like and had the user add an * or even a % but it still returns nothing. Records are returned only when the us...more >>

Mail Merge application capabilities with SSRS 2005?
Posted by DBguyintheMidwest at 5/24/2006 3:50:01 PM
I was handed an off-the-wall project where my company has a 4 page templated document and approx. 15 fields throughout this doc that need to be populated dynamically from a SQL Server DB for every record that is in the results set from a query against multiple tables. The document needs to be...more >>

Parameters
Posted by André Mattos at 5/24/2006 1:28:01 PM
Hi ! How come i pass olap parameter to my subreport? I have two reports and i'd like link these reports by parameters, but when a put parameter to link the value doen't pass to subreport. I use SSAS 2005 and my parameters are dimension of my cube. Help me !!!! Thanks. -- Mattos...more >>

Eval Edition expired
Posted by Phil McNeill at 5/24/2006 11:10:39 AM
We installed Reporting Services along with SQL 2000 as part of an SMS 2003 deployment (all on the same box). I didn't realize what we were getting was an eval edition at the time, but the 90 days is up I guess as when I try to open my SMS reports now I'm getting the following message: "Thi...more >>

Display .356 as a percentage
Posted by Mark at 5/24/2006 9:50:17 AM
I have several columns of data in a report that have values like .743 or ..253, and I'd like them to display as 74.3% and 25.3%. I'm a reporting services newbie - I didn't see a format option in the properties of a textbox. Suggestions? Thanks in advance. Mark ...more >>

document map
Posted by roadie.girl NO[at]SPAM gmail.com at 5/24/2006 9:46:05 AM
hi all - i am trying to make a document map for my report. now correct me if i'm wrong, but when i click on a link in the document map, the my drill-down menus in my table should 'automatically' expand as needed. well i can't get it to work. i have a bookmark ID set for the drilldown parents ...more >>

Visual .Net 2005 or 2003
Posted by SAM at 5/24/2006 7:56:01 AM
Can SQL Server 2000 Reporting Services use Visual .Net 2005?...more >>



Incorrect measures by hiding a time dimension level
Posted by geert.tholen NO[at]SPAM gmail.com at 5/24/2006 7:27:17 AM
Hello everyone, I'm developing a report, based on an OLAP cube, that shows Budgets and Costs. As a report parameter i use Posting Period, which is a time dimension with the levels Year, Quarter, Month, Date. When you select a value for this parameter, the listbox shows the folowing values: ...more >>

Drill Through From Drill Down
Posted by davyshipley NO[at]SPAM bluebottle.com at 5/24/2006 6:59:49 AM
I have a report grouped that has a drill down, from the drill down records, I can drill through to another report that has the details of the records recorded on the drill through. Example: Location (Drill Down) +York +Cardiff +London Displays: -York Team1 Team2 Team3 -C...more >>

report viewer control
Posted by EyalK at 5/24/2006 5:49:04 AM
Hi, i'm a newbie in using report viewer and having a tough time now building a web app in c# and asp.net.. hope someone can help me on this. i'm using VS2005 and RS2005. can someone direct me to a sample i can use? i want to know how to set parameter and filter the result according to ...more >>

Export to excel error
Posted by vinodsh_82 NO[at]SPAM hotmail.com at 5/24/2006 2:21:46 AM
Hi all, i am not able export to excel, it is showing the below error: Reporting Services Error -------------------------------------------------------------------------------- Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderin...more >>

WebForms.ReportViewer and ReportServerCredentials property?
Posted by Asaf at 5/24/2006 1:40:02 AM
Hi, I have an ASPX web form with a WebForms.ReportViewer on it. I have created a new ReportServerCredentials class form this site http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx My code for the report viewer is: rvBlackListReport.ProcessingMode = ProcessingMode.Remote; ...more >>

When does 0 <> 0?
Posted by Azrael Seraphin at 5/24/2006 12:00:00 AM
This is really weird. I want to divide Amount by Units to get the average amount per unit. So I used this: =IIF(Fields!UnitsBilled.Value = 0, Nothing, Fields!AmountBilled.Value / Fields!UnitsBilled.Value) Pretty standard stuff. I have three other calculations on the same report that do muc...more >>

SQL Server 2005 Reporting Service Backwards Compatible?
Posted by Brooke at 5/24/2006 12:00:00 AM
I have to develop a SQL Server 2000 database applications with reporting services but I only have Visual Studio 2005 and SQL Server 2005. I know that I can develop the database as a SQL Server 2000 database, but what about the reporting services? Can I develop everything in 2005 but run it ...more >>

Publish reports to SQL 2000 RS using VS2005
Posted by jagb at 5/24/2006 12:00:00 AM
We are migrating to SQL Server 2005 (and also RS shipped with SQL 2005) but in the middle of the process we have still some servers still not upgraded (and running SQL Server 2000 and RS2000). Can we deploy reports to RS servers running SQL Server 2000 using Visual Studio 2005? It seems we ...more >>


DevelopmentNow Blog