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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|