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 2006 > threads for monday july 31

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

Using Shared Variables in Group Footers
Posted by kmishle at 7/31/2006 9:00:01 PM
Hi folks, I’m relatively new to both SQL Reporting Services as well as .Net programming. I come from a Crystal Reports background and I’m running into a problem duplicating a common technique used in my old Crystal reports. The simplified description of the problem I’m having is thisâ...more >>


Expand ALL
Posted by Bob Myles at 7/31/2006 4:55:02 PM
Is it possible to "Expand ALL" levels of a summarized report? I have a report that has 3 levels of detail, with about 10 main items, a couple items under that and 4 or so items each under there, it gets tiresome real quick to click all the little pluses... When I export it to Excel 2000 t...more >>

=?utf-8?B??=
Posted by Bob Meyers [MSFT] at 7/31/2006 3:30:43 PM

Total field includes data from rows that were filtered
Posted by clberk at 7/31/2006 1:44:01 PM
I am having the same problem that Cyndi posted on 5/10/06. I have a group that has a filter on it. The group has a footer that has a Sum field. The sum field is summing all data for the group, not just the rows that are displaying. Has anyone come up with a solution for this problem? Is t...more >>

Security Troubleshooting?
Posted by Aaron Haley at 7/31/2006 1:01:25 PM
We just migrated from 2000 to 2005 on a new box. The migration documentation was wonderful for 2005 and it answered all of our questions. Our main reporting page should allow all users of a group to browse, but it no longer seems to accept the integrated security login for access. It ends up gi...more >>

getting Error: Subreport could not be shown in report viewer
Posted by bharath.mp NO[at]SPAM gmail.com at 7/31/2006 11:31:10 AM
Hi All, I am getting this error - "Error: Subreport could not be shown" only in the report viewer. Strangely, the first row in the parent report has the subreport shown correctly and all the subsequent rows have this error message. The report runs fine when I use the preview in Business Int...more >>

Handling nulls in matrix sub totals
Posted by Andrew Murphy at 7/31/2006 9:47:01 AM
I have a matrix where I am using the inscope function to return different calculations depending on which group it is in (ie the detail is just the value and the sub totals are sum(values)). In for the subtotal group I have used: iif(isnothing(sum(Fields!CurrentCount.Value)), 0, sum(Fiel...more >>

dataset in main report and subreport
Posted by InvalidLastName at 7/31/2006 9:41:45 AM
Hi, We have a main report that calls a subreport. The subreport is being = passed the appropriate parameters. The subreport works correctly in isolation in the preview mode. However, = when it is called in a main report it stops working. I get the message "Error: Subreport could not be shown."...more >>



Reports - IE7?
Posted by John J. Hughes II at 7/31/2006 9:16:56 AM
Are there some major issues with the reports and IE7? One of our systems which is attempting to access the reports via LAN is having the following problems. The system is running IE7 Beta 3 on WinXPPro SP2. 1) When opening report builder the progress window appears showing the download...more >>

Zip file
Posted by Efi at 7/31/2006 9:11:03 AM
Is it possible that the reporting services will send a zipped excel file instead of just the excel file?...more >>

Matrix dataset filter out null
Posted by magendo_man at 7/31/2006 9:11:02 AM
I have a dataset which has a ContractNo column which can take a null value. I cannot carry out the filter on the stored procedure which generates my dataset. This dataset is used in a matrix. I need to filter out all rows with a null ContractNo. I thought I could do this on the matrix prope...more >>

RS 2005 Parameter Syntax
Posted by John Joslin at 7/31/2006 6:39:01 AM
I've written a simple report to get familiar with RS 2005 syntax, etc. The report contains 2 parameters that are input in text boxes before the report is displayed. The select statement works correctly when executed in the query builder but does not display the report in the aspx page. Here is...more >>

Lookup column / combining two datasets
Posted by Jacek at 7/31/2006 5:54:01 AM
I need to display a values from the another dataset. E.g. I have a SQL database with employees details and that is dataset 1; but employees salaries are stored in Excel spreadsheet and that is dataset 2. The question is how can I display a list of employees along with their slaries? Tha...more >>

add totals to a matrix
Posted by florian at 7/31/2006 1:55:45 AM
Hi, I've defined a matrix in a report which looks like this: group by column group by column Description Data Data Description Data Data Now I'd like to add a colum which sums up th...more >>

Reporting on a dynamic recordset
Posted by ElijaTheGold at 7/31/2006 1:27:02 AM
I have my first project with reporting services - 2000 not 2005 and the very first report that I have to generate is based on a dynamic pivot of an SQL table. This means at design time, I don't know how many columns there is going to be - it will vary quite a lot depending on date ranges an...more >>


DevelopmentNow Blog