HI, 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? Michael
RunningValue in Drilldown problem
2 posts
• Page 1 of 1
- MS WORD
- DATABASE
- linux
- robots
- MS OFFICE OUTLOOK
- javascript
- WINDOWS VISTA
- MS Office Access
- python
- Windows Me
Jump to:
- 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
Next
RunningValue in Drilldown problem
by TWljaGFlbA » Sat, 08 Oct 2005 00:03:05 GMT
RE: RunningValue in Drilldown problem
by 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
Hi, 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 here My first problem: I need some help on presenting data in a matrix. I have data like below : Amt 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: Amt 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?
Hi everyone I have problem using driildown in Analysis service 2005, the problem is following 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 example. 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 Regards -- 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 ). Thanks
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 32 guest