RunningValue in Drilldown problem



  • 1. Custom Assembly Error.
    Hi All, I am using custom assembly in my report which will connect to the database. Here I have two methods in my class. First method will connect the database, then this method will assign datas in public variables which are decalared in class level and it will return number of records to my report. If records available, i will call second method from my report to get those values with out connecting to the database once again. First method is working fine. But the second method is not returning the values..[i mean the public variables not maintaining those values.]. This same class When I access from any ASPX page, its working fine. I am wondering if the report is creating new instances everytime! Can any one help me to resolve problem
  • 2. Machine Resources
    is SQL Server Reporting Services particularly demanding on machine resources ? I know, it's rather broad question, but your general input would be appreciated ... Thanks .....
  • 3. Dynamic Sorting
    Is there a way to use parameters for a user to select how a report is sorted?
  • 4. How do I make Field_B and Field_G to look at Field_A?
    My Current Table Field_A Field_B Field_G 100 Memo Memo -50 Memo Memo 200 Memo Memo -100 Memo Memo How do I make my Field_B and Field_G to Reference/Evaluate Field_A For Example: If Field_A > 0 then Field_B and Field_G = Debit Memo If Field_A < 0 then Field_B and Field_G = Credit Memo I would like to see the result in this Format Field_A Field_B Field_G 100 Debit Memo Debit Memo -50 Credit Memo Credit Memo 200 Debit Memo Debit Memo -100 Credit Memo Credit Memo Thanks, John

RunningValue in Drilldown problem

Postby TWljaGFlbA » Sat, 08 Oct 2005 00:03:05 GMT

   We are using RunningValue function to alternate color for displaying rows.

Here is the property value for backgrond color:
=iif(RunningValue(Fields!Row_Date.Value, CountDistinct,Nothing) Mod 2, 
"white", "#E4E7E6")

We are having a problem with using that and a drill down at the same time.  
The first drill down works fine, but the second does not.  Any thoughts?


RE: RunningValue in Drilldown problem

Postby V2F5bmUgU255ZGVy » Thu, 15 Dec 2005 05:12:03 GMT

I am in the middle of installing the gold bits, so I don';t have books on 
line, but we use the rownumber function instead of runningvalue... See if 
that works for you.
Wayne Snyder MCDBA, SQL Server MVP
Mariner, C{*filter*}te, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.

Similar Threads:

1.Problem using runningvalues on different group level


I've a chart with 2 groups + a detail group

Niv 1 header
Niv 2 header 
Detail 1      value 200
Detail 2      value 200
Niv 2 footer (expected value 200, an average will do)
Niv 2 header 
Detail 1      value 300
Niv 2 footer (expected value 300)
Niv 2 header
Detail 1      value 500
Detail 2      value 500
Detail 3      value 500
Niv 2 footer (expected value 500)
Niv 1 footer (expected value 200 + 300 + 500 = 1000)

i.e. i'm trying to make a sum of average but i find no way to do that, 
either with runningvalue on different scope or anything else that i tried.

(N.B all details lines of a same niv 2 group have the same value)

Any miracle solution ??

2.Matrix "Group" and RunningValue Problems

I have 2 problems at the moment and hope I'll be able to get some help

My first problem:
I need some help on presenting data in a matrix.
I have data like below :
1-Jan	1
2-Jan	2
3-Jan	3
1-Feb	1
2-Feb	2
3-Feb	3

Is it possible for me to "group" my data to be like the following:

Jan	6
Feb	6

My Second problem is with runningvalue.

My data has multiple records for one ID. But I only want to have a
runningtotal based on one value from each ID and grouping by area.

To illustrate my problem,

Area 1
ID 1  4
ID 1  4
ID 1  4
ID 1  4
ID 1  4

ID 2  1
ID 2  1
ID 2  1
ID 2  1

I would like to have the runningtotal to be equal to 5 and not 24.
If I use =RunningValue(Fields!Amt.Value, sum, "Area"), I will be
getting 24.

Currently I'm using a custom code to get the value but I can't pass
the value to the "Area" group footer.
I tried using ReportItems to pass the value out but received an error.
The error message is given:
"The Value expression for the textbox 'textbox100' refers to the
report item 'textbox28'.  Report item expressions can only refer to
other report items within the same grouping scope or a containing
grouping scope."

Can anybody help me?

3.Drilldown problem

Hi everyone

I have problem using driildown in Analysis service 2005, the problem is 
I have cube which has 1 facta table and few dimension tables, this cube has 
some account information

When viewing the cube on account level, for example for each month the cube 
summarize the amount to accounts.

My problem is when using drilldown to see how many records are in the 
summarization on the first level, in some case it summarizes some records for 

it summarize the record which has been inserted into the database on same 
account number, on same day, on same departments etc....

Is there some settings in the cube to show me all the records when using 
drilldown in Analysis service 2005

When using drilldown in some cases you want to see all the records which 
create the sum on the first level

Jn sveinsson

4.Reporting Services : Problem using drilldowns on reports rendered via report SOAP API

5.Performance problems with drilldown report

We have a drilldown report which hides several rows and other report items. 
When we click the + signs the report performs slowly when it needs to refresh 
from the Report Server. Is there anyone who has any suggestions how we could 
gain better performance with the same functionallity ?? ( When you render the 
report in Visual Studio it's much faster to drilldown ).


6. HTTPS problem - DrillDown Report - Toggle Icon

7. drilldown problem

8. Reporting Services runningValue



Who is online

Users browsing this forum: No registered users and 32 guest