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 monday may 22

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

How to reset a RunningValue on Change of an Field without a group
Posted by Daniel Doerfel at 5/22/2006 10:57:01 PM
Hi All, how can i make it that a running value is reseted when a value field is changing (first 2 digits of a postal code). The Report prints with a list with 3 rows of Labels. There is no group in there and in the list i can only define a detailgroup whitch brings the wrong result. T...more >>


Display top N records and its total
Posted by Nergock NO[at]SPAM gmail.com at 5/22/2006 7:02:36 PM
For a given dataset, I know how to display the top-N records. Is there a way in reporting services to then show the total of those top-N records? For example, let's suppose I have a dataset of sales people and their sales totals. By grouping on the sales person, I am able to display the top...more >>

Rendering a report to a specific form location within a page
Posted by T.Stanley at 5/22/2006 4:15:02 PM
Hi. This seems like a silly question, as I am sure it can be done. When I render a SSRS 2000 report to a page from the Page_Load event, it simply streams it ahead o all oher HTML. I would like to place this report within a content section of a page that is associated with a master page (obviou...more >>

how can i install reporting services 2005
Posted by RP at 5/22/2006 2:12:01 PM
Hi, I installed sql server 2005 enterprise edition and visual studion 2005 professional. but i am unable to create any projects. how can i create a report project ?? (i cant find a business intelligence project anyw here thanks in advance...more >>

FormatPercent Crashes
Posted by Gummy at 5/22/2006 1:36:53 PM
Hello, When I try to view my result as a percent (using FormatPercent) and then preview the report, it crashes. Any ideas? I am running SQL Server 2005 (no Service Packs) on XP Pro. Thanks. ...more >>

An attempt has been made to use a rendering extension that is not registered for this report server.
Posted by vovikdrg NO[at]SPAM gmail.com at 5/22/2006 11:32:56 AM
Hi guys. A have create the simply CSV rendr extesion using System.IO; using Microsoft.ReportingServices.ReportRendering; using System.Reflection; namespace CSVPsrExtesion { public class CsvExtesion: IRenderingExtension { private const string DEF_EXTENSION_NAME = "CSV (comma delimited)...more >>

Matrix Column Totals and Grouping
Posted by Andrew Murphy at 5/22/2006 10:09:02 AM
I am new to matrix reporting, andam trying to recreate a piviot table report with counts of number of documents by location, pivoted against doc type (horizontal axis). I have created this ok but there are two outstanding issue; firstly i cannot get the group total to diplay at the bottom...more >>

Problem setting variable in SQL Server Query statement Dataset
Posted by terry beckman at 5/22/2006 10:01:01 AM
I am having a problem getting a piece of code to work and looking for an answer. I keep getting various SQL Server errors when I try variations of this following code. @DetailSelected is a boolean field and I want to set variables for a checkbox report based on the selection. Code follows: ...more >>



Fileshare Data Driven subscription - Setting up report manager fil
Posted by Mark at 5/22/2006 7:21:01 AM
I am trying set up a data driven subscription that will render reports as PDFs to specific folders in Report Manager. I have setup a fileshare to which I am pushing reports, but I am having trouble relating specific Report Manager folders to the fileshares and there is little documentation abo...more >>

Is SSRS 2000 compatible with any version of VS 2005??
Posted by tlyczko at 5/22/2006 7:07:28 AM
I am awaiting my free VS 2005 Standard that I'm supposed to get for viewing online videos on an MS website, and I am curious if SSRS for SQL Server 2000 can be used with VS 2005?? Thank you, Tom ...more >>

Export to PDF only showing 1 Page
Posted by Chris Hoare at 5/22/2006 4:16:02 AM
Hello, I have a simple report (rdl available but the ms browser wont let me upload it) that runs and displays fine on screen; when a user does an export to pdf they only get the first page. On screen we are seeing 18 pages in total in IE. When we export to PDF we only get the first page...more >>

Group By Problem RS2005 using Report-Parameter?
Posted by Classgenerator at 5/22/2006 3:09:04 AM
Hi all, my Report shows not the correct values, if i choose more than one Products from my Parameter-Object (Products). Does RS2005 is having a problem with GROUP BY? The SqlProfiler does not show the filtered query which the Report is executing??? I just want to have a small Report to show ...more >>

exporting to pdf without generating report
Posted by ter at 5/22/2006 2:02:01 AM
hi I am calling a report from asp and if i click the button the report has to be be stored in a specified location given by the user and report window should not be generated. It is very urgent please help me to solve the problem thanks terrance ...more >>

Allow Null Value
Posted by Pieter Coucke at 5/22/2006 12:00:00 AM
Hi, A given column of my Report (reporting services 2005) contains clients or null values. I want the user to be able to chose one or more clients for the parameter, and than show only those records of this client. I also want to be able to chose "NULL", which will show the records with the...more >>


DevelopmentNow Blog