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 2007 > threads for tuesday may 1

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

Report Activity Tracking
Posted by AD at 5/1/2007 11:38:34 PM
Hi, We would like to track user activity on our reports, has anyone done this before? Are there any best practicies available? We are considering a couple of options but I thought I'll ask the clever people as well :) (If this is a duplicate post, please ignore, I'm battling with IE7...) ...more >>


Installing report server
Posted by Faiz at 5/1/2007 10:22:39 PM
Hi All, I am using SQL Server reporting services for the first time through SQL server 2005 evaluation version. I am using windows xp and when I Start reporting services configuration manager it ask me to coonect to a machine. When I click on the find option, which is displaying my machines naem,...more >>

Reference report outside of current project
Posted by MarkusJNZ NO[at]SPAM gmail.com at 5/1/2007 6:52:16 PM
Hi, I am migrating across some reports from 2000 and some of the reports reference reports outside of the current project when a person clicks on a value. In the report designer under Navigation -> Jump to report the report has the following value \parentFolder\Report Name Under 2005, wh...more >>

datetime parameter
Posted by gv at 5/1/2007 5:33:23 PM
Hi all, Is there a way to not allow a date older then a certain amount of time in datetime paremeter in a report? like from date not to allow anything older then 6 months. thanks gv ...more >>

duplicate rows in drill down
Posted by gv at 5/1/2007 5:02:40 PM
Hi all, I have a report that drills down some, and is showing duplicate rows. How can remove the duplicate rows? Cannot do this on the initial sp because they are not duplicates. do I need to have an DISTINCT expression in there? thanks gv ...more >>

Group Sum over multiple pages with IIF
Posted by Michael C at 5/1/2007 10:34:01 AM
I am using an IIF statement to sum a group of detail records that spans more than 1 page. The sum looks like this: Sum(IIf(Fields!MySwitch.Value = 'A', Fields!MyValue.Value,0)) Im doing the sum in the table1_group1 footer and it works fine if all the data in the group remains on the sam...more >>

Hiding Table Grid Lines
Posted by John Wright at 5/1/2007 10:27:09 AM
I have a table that duplicate data in some of the columns. I have the property set to hide the duplicates, but I also want to turn off the borders for those cells that are duplicated so I gives the same appearance as a Matrix report when it has duplicated items in a column. Does anyone have ...more >>

Run report automatically when a parameter changes
Posted by Stephanie at 5/1/2007 8:05:00 AM
I have a report with 6 parameters. They all have defaults so it is run immediately when opened. Is there a way to run the report automatically when any of the parameters is changed by the user instead of requiring the user to click on the View Report button? Stephanie...more >>



embedding RS into a java (j2ee) application
Posted by Stephanie at 5/1/2007 8:01:02 AM
Can anyone point me to some useful information on embedding reports into a java (J2EE) application? Stephanie...more >>

SQL 2000 RS and Vista
Posted by Mark Goldin at 5/1/2007 7:02:52 AM
I am trying to install SQL 2000 RS on my Vista box. Installation refuses to run. This is my home computer and I dont care if I have to tweak something. Anyone got it working on Vista? ...more >>

custom code to populate parm default
Posted by ppbedz at 5/1/2007 5:24:03 AM
I am using custom code to retrieve the current year to populate the default year parameter for a report. The custom code correctly retrieves the year when tested within the body of the report. However, when referenced as an expression code.CurYr in the "default" seection of the report parame...more >>

how to count rows in field
Posted by nicknack at 5/1/2007 1:44:58 AM
Hello. I built a report with one field as a group. I want to count the number of rows in each field so I can add it to the group field or somw where in the report. How can I count how many rows do I have in each group? Thanks. ...more >>

Reporting Services Rendering is Slow
Posted by Namshub at 5/1/2007 12:00:00 AM
I use the web service as well as intergrated url link to display, but both display the same characteristics. The first run is extreemly slow. We could be talking up to 1 minute to generate a pretty basic report. When the same report with a differnet parameter or even a different report i...more >>

Unable to Select All
Posted by Todd Stoltz at 5/1/2007 12:00:00 AM
I'm sure someone else has experienced this: I am writing a report in Visual Studio 2005/reporting services for SQL 2005 and a parameter is designated as 'multi-value'. When I attempt to run the report in the preview pane of Visual Studio, I do not see the select all option. I actually hav...more >>


DevelopmentNow Blog