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 > october 2006 > threads for thursday october 26

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

New Template, open exsisting, any way to call reporting wizard now?
Posted by Jason at 10/26/2006 7:04:42 PM
Any way to load my new template, and then call wizard? seems wizard is not accessable if after I start with open existing item. Can anybody recommend and easy to follow book on on reporting services 2005? dumb question, say I have a grouping report like this group detail detail...more >>


Local reports with ADO.NET Dataset help
Posted by Brian Vallelunga at 10/26/2006 6:18:34 PM
I'm trying to use a local report in a Windows Forms application that uses an ado.net dataset. The trouble is that I'm trying to figure out how to access data within related tables. If the dataset has a table called Customers with two records in it, how do I go about displaying the data from ...more >>

Reporting Services Mode
Posted by Chuck P at 10/26/2006 5:59:01 PM
I need to do an asp.net application that has reports and Forms Authentication (no windows authentication). I have absolutely NO need for centralized reports or load balancing. On my last project I used sql05 reports within asp.net vs05 on a win03/32bit server and used LOCAL reports. The...more >>

Summing a calculated column
Posted by Elmo Watson at 10/26/2006 4:27:54 PM
In my report, one column is a calculated column based on two others ColumnA - Quantity ColumnB - Cost Then, Column C multiplies Column A * Column B =Fields!Quantity.Value*Fields!Cost.VALUE That part works just fine But - I need to (not in Footer), create a cell, that sums up all the valu...more >>

Using UNION in MS SQL vs Oracle
Posted by Peter Manse at 10/26/2006 3:31:02 PM
In SQL, this works beautifully: SELECT 'All' AS RootName, ' All' AS SortValue UNION SELECT DISTINCT RootName, RootName AS SortValue FROM dbo.APP_OnlineReportingRoots ORDER BY SortValue It adds the word "All" to both the RootName ans SortValue columns of the results which I then use for ...more >>

Is there a way to iterate through the Parameters collection in a r
Posted by Chris G. at 10/26/2006 2:48:01 PM
SSRS 2005 I would like to be able to write a function which takes a reference to the Parameters collection in the report and then iterates through the collection to dynamically build a string which outputs the prompts and values for all of the visible report parameters. The only problem ...more >>

Subscription problem when using Analysis Services as the datasource
Posted by Ryan at 10/26/2006 2:00:25 PM
Hello, I've searched this newsgroup and others using google groups and was unable to find a solution to the below problem. I am hoping someone from here can help me out. I've created a simple report in MS Reporting Services 2005. I've created a shared datasource to a Microsoft Analysis s...more >>

Open URL in New Browser
Posted by ME at 10/26/2006 12:11:43 PM
My report has a table that when I click on a cell it jumps to URL and open it in the same browser window. How to open the URL in a new browser instead of current browser window? Thanks. ...more >>



SSRS and Excel
Posted by Murali at 10/26/2006 10:58:01 AM
Hi, I have a report that displays appromiately 100,000 rows. But when I export the report in to excel file, it gives an error because excel sheet cannot exceed 65,000 rows. Documentation says I need to use pagebreaks. Does anyone what exactly I need to do inorder to have the report data dis...more >>

subtotals and parameters questions
Posted by Roberto Peña at 10/26/2006 10:56:08 AM
Hi, I'm working on a report using RS2000 where I have the following questions: 1- How do I change the expression for a subtotal? Let's say I need to change the agreggate function, average instead of sum for example, I dont know if this is even posible. Now, what I really would like to do is se...more >>

RS2K Install Problem ASP.NET
Posted by Todd Lemen at 10/26/2006 10:16:02 AM
I am installing RS2K3 on a WinXP box running IIS. Error message indicates ASP.Net not registered with IIS. Have run aspnet_regiis -i from the %windir%\Microsoft.Net\Framework\v1.1.4322 folder, same message occurs. Suggestions?...more >>

Sort on Matrix Row
Posted by Peter at 10/26/2006 9:06:02 AM
Hi folks, I have a Matrix report as below: Adult Members child Members TX 30 40 AL 10 20 MA 55 11 If I want the row order like AL, MA, TX, what are the steps to achieve. Ple...more >>

help with charts
Posted by aggiechick717 at 10/26/2006 7:10:39 AM
I can't figure out how to turn off the document mapping of my report. I have two charts on my report and that is it. Any ideas? Thanks in advance.. Missy ...more >>

URGENT: Group page count
Posted by Kyriakos at 10/26/2006 12:37:01 AM
Many of us like to be able to create reports that will count the pages per group. For example: I have a 10 page report with 2 clients. Client No 1 has 3 pages, while client no 2 has 7 pages. I would like to create a field (at the page footer) that will count the pages for each client (i...more >>


DevelopmentNow Blog