Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







RunningValue ?


I am having problems with the following -

 











this represents the dataset

Date
Customer
Voucher Number
Document Amount
Check Amount

 



 

7/15/2006
Company G
101
15.00
45.00

7/15/2006
Compnay G
101
25.00
45.00

7/15/2006
Compnay G
101
5.00
45.00

7/18/2006
Company A
102
35.00
35.00

7/25/2006
Company M
103
45.00
50.00

7/25/2006
Company M
103
15.00
50.00

 














This represents the final report
this is what I am getting

 

Date
Customer
Voucher Number
Document Amount
Check Amount
Check Amount

(Hidden)
Group 1 Header = Voucher Number



 
 

(Hidden)
Detail
7/15/2006
Company G
101
15.00
45.00
45.00

(Hidden)
Detail 
7/15/2006
Company G
101
25.00
45.00
45.00

(Hidden)
Detail 
7/15/2006
Company G
101
5.00
45.00
45.00

 
Group 1  Footer
7/16/2006
Company G

45.00
45.00
135.00

(Hidden)
Group  1Header = Voucher Number



 
 

(Hidden)
Detail
7/18/2006
Company A
102
35.00
35.00
35.00

 
Group 1 Footer
7/19/2006
Company A

35.00
35.00
35.00

(Hidden)
Group 1 Header = Voucher Number



 
 

(Hidden)
Detail 
7/25/2006
Company M
103
45.00
50.00
50.00

(Hidden)
Detail 
7/25/2006
Company M
103
15.00
50.00
50.00

 
Group 1 Footer
7/25/2006
Company M
103
60.00
50.00
100.00

 
Report Footer

Grand Total:
140.00
130.00
270.00

 
 
 
 
 
 
 
 

(I am using a table)

I can get the correct total for the Group 1 Footer Check Amount by dividing the Total by a count of the Voucher Numbers, but I have not been able to add the Group 1 totals of the Check Amount for the Grand Total in the footer.  I have made various attempts using RunningValue with the Group 1 Check Amount Total field, but always getting a error - mostly that the scope was not correct. 

Any suggestions will be appreciated.

 


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
RunningValue()
I have a report that I has a dataset that has a column that can have high and low values.  If a row has a value that exceeds either of these values I would like to do a running value on these values.  For example, 300 records , 10 high , 3 low.

 

I know I can do a SQL query that can grab that data and then do a countrows on that dataset but I thought there should be a way of doing a runningvalue for each value.

 

Anyone have an idea on what the syntax is to do this?

View Replies !   View Related
RunningValue Problem
I have a question about using 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 in the ID group footer 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." I also tried using code.Total (Total is the global variable holding the sum) at the "Area" group footer but the value is "delayed". Meaning total of Area1 = 0, Area2 = Total of Area1 and so on.Any idea on how to shift the total up?

I also tried RunningValue(Fields!Amt.Value, MAX, "Area"), it only gives me
the maximum value in the Area group, not the running total of all the
maximum values of each ID.


As for RunningValue(Fields!Amt.Value, Count, "Area"), it gives me the
total rows in the Area group.


Is there a way to sum on distinct ID in the Area group? Or inserting
an iif condition in the runningvalue? I tried
Runningvalue(iif(First(Fields!ID.value), Fields!Amt.Value, Nothing),
sum, "Area") since I wanted the first value of each ID but it says it
cannot have an aggregate function within an aggregate.


Is there a method to write something along the line of >>> iif(Fields!
ID.Value = distinct, Fields!Amt.Value, Nothing).

Using Select Distinct in the query doesn't help because the other fields are different and I need to display all the records.



Can anybody help me?

View Replies !   View Related
Using RunningValue Question
I have a couple of columns in a table where I would like to summarize the total value of that column in the group's footer.  I also want to filter that total just by that column, so I am creating a RunningValue statement like this:

 

=RunningValue(iif(Fields!TypeClass=351154, Fields!ValueAmount.Value, 0), Sum, Nothing)

 

This works great with zero (0) values, however on the column that filters by the number 351154, the expression produces #error.

 

Is this because you cannot have a RunningValue in a group footer?

 

Thanks for the information.

View Replies !   View Related
RunningValue In Matrix
Hello, I was wonder if it is possible to have a RunningValue per row on a
matrix? I want to Sum a number onto itself and show in each columnfor the
first row and reset for the second row and start all over again. I am going
to use conditional statements to control what value is being summed based on
the rowgroup I am at, but that number will have to sum onto itself for every
column in each row.

Ie. 38, 76, 114, 152, 190 in first row
second row: 38, 76, 114, 152, 190

These are based on the variable Fields!WC_TOTALS_DIVIDEND_ROUNDED.Value

Thanks,

BJ

View Replies !   View Related
RunningValue Question
I have a form that uses some header information (like client ID with name, address, etc) and then uses a table for orders that customer has placed.  I now need to print something like a page number (but not in the header or footer).  When I try RowNumber, this does not work as the dataset is returning multiple records for the first customer and then the next item in the list (the next customer ID) skips the number of records from the first.  So I need the first one to have 1, the second to have 2 and so on.  I tries RunningValue, but for each record it starts back at 1.  What I need is like a counter.

How would I go about this and thanks for the help.

View Replies !   View Related
RunningValue() In Dataset
I've created a CalculatedField in my dataset, set to:

        =RunningValue(Fields!Quantity.Value,Sum)

...however when I Preview the report, VS returns the error:

An error occurred during local report processing.
An internal error occurred on the report server. See the error log for more details

...and then blows up, requiring a restart.  I've tried this on several different reports with same results.

I must have the RunningValue() as a Field for purposes of creating something like a ReverseRunningValue() (which adds from bottom-to-top instead of top-to-bottom).  This stems from the need to perform a Previous() call, which requires a field as a parameter.  (If I could use Previous() to refer to a textbox object, then I could put RunningValue() in a texbox instead, but this doesn't seem to work).


Any ideas?

Thx,
Mojo

View Replies !   View Related
Multiple RunningValue
Hello,

I am trying to create sequential running totals based on the months.  I have included the two expression I've been trying to use.  I have one group created called table1_MO_NUMBER and four sequential fields that need individual running totals.  I am using Reporting Services 2005.  The Totals column is the result of the expression.  I added an additional column that displays what the running totals should be.  Any suggestions would be helpful.  Barb
 
 











JANUARY
 
 
 


 
 
 

 
1
MTD NET ACTUAL
2,235




 
2
PLAN
3,158




 
3
FCST
3,200




 
4
LY MTD NET ACTUAL
1,853
Totals
Totals should be.





Act Bldgt
10,447
2235
iif(Fields!SEQ_NO.Value=1,RunningValue(Fields!BLDGT.Value, sum, Nothing ),0)



JANUARY RunningTotals
Plan Bldgt
#Error
3158
RunningValue(iif(Fields!SEQ_NO.Value=2, Fields!BLDGT.Value, 0), sum, Nothing)




Fcst Bldgt
 
3,200





Pr Bldgt
 
1,853


FEBUARY
 
 
 


 
1
MTD NET ACTUAL
2,512




 
2
PLAN
3,580




 
3
FCST
3,200




 
4
LY MTD NET ACTUAL
5,744







Act Bldgt
25,483
4748




FEBUARY RunningTotals
Plan Bldgt
#Error
6739





Fcst Bldgt
 
6,400





Pr Bldgt
 
7,597


MARCH
 
 
 


 
1
MTD NET ACTUAL
3,887




 
2
PLAN
3,780




 
3
FCST
3,200




 
4
LY MTD NET ACTUAL
4,494







Act Bldgt
40,843
8635




MARCH RunningTotals
Plan Bldgt
#Error
10518





Fcst Bldgt
 
9,600





Pr Bldgt
 
12,091

View Replies !   View Related
Using RunningValue In Charts With Subreports
Hi,
I am creating some earned value reports that display project budget, actual cost to date, projected cost, and earned value. I have all of the data stored by month so I am using the Running Value function to display the data on a graph such that at any given point on the graph, it is showing total dollars as of that date. This works great for a single project or a summation of projects.

I also want the ability to create a batch set of reports for a series of projects, basically they input a list of project numbers, and a new graph is generated for each one. To do this, I created a "batch report" that has a subreport in a table's group with project id being the grouped on field, it passes that project id to the subreport as input.

I get exactly what I want - a new report for each project, but the problem is, running value on the graphs is not working across the projects. It's fine for the first project, but all subsequent projects are getting messed up. For instance, one project with a max budget of 200K is showing with a max budget of 400K, actuals are getting nulled out, etc. It's as if for some reason, the RunningValue isn't getting reset across the subreport....

An example of my value field on one of the lines (not copy and pasted so forgive any syntax errors - I'm not on my development box):


 


Code Snippet= Iif(MAX(Fields!actual_de.Value + Fields!actual_work.Value) >0, RunningValue(Fields!actual_de.Value + Fields!actual_work.Value, Sum, FakeSeries), Nothing)

 

(The point of the max is so that the graph stops on months without actuals - that is months that haven't occured yet)

My FakeSeries is just on projectID and is just for the purpose of resetting the Running Value (or so I thought).

Does anyone have any input or advice on how to get this working? Why is RunningValue getting messed up across subreports? If I only give the batch report one project ID, the data is great. (I know it's the running value because if I take out running value and just graph the SUM - all the values are correct).  If anyone has an alternate way of doing this sort of batch report I'm all ears as well!

Thanks much!
Jen

View Replies !   View Related
Aggregate On Expressions Which Use RunningValue
Is there any work-around to be able to do any form of aggregation (such as a sum or count) on a column that has an expression using RunningValue?  It appears that you cannot add RunningValue as a calculated column in a dataset, nor am I aware of a way to reference a textbox that is using RunningValue in it's expression.

Business example:  Our users want a way to be able to quickly identify what items sold in a previous month make up the top 50% of sales, followed by the next 30% then the bottom 20%.  They are labeled A, B and C categories respectively.  Here is the generic expression I am using:

=IIF(RunningValue(Fields!ActualDollars.Value, sum, "MainQuery") <= Fields!TotalDollars50Percent.Value, "A",

IIF(RunningValue(Fields!ActualDollars.Value, sum, "MainQuery") >= Fields!TotalDollars80Percent.Value, "C", "B"))

Next, in short, they want to be able to have a count of the the number of items which make up each category.  As the above cannot be a calculated column in the dataset, it is a calculated table cell expression.  Issue now is you cannot reference that cell in another cell.

So, how would you create an expression which references the above expression, and do an aggregation on it?

View Replies !   View Related
Runningvalue In Group Expression
Hi

My customer want's to get product ABC analysis report. And product groups are determined as A - 50% of total sales, B - 20% of total sales and so on...
By using expressions I can get the A B C D values but I cannot group them.
It seems also not possible to calculate this in sql statement beacause I cannot create any view nor stored procedure for culumative calculation.

Can anybody help me with this matter, how to "Cheat" the group to accept aggregated values to get calculated expression value as a group?





<?xml version="1.0" encoding="utf-8"?>

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<DataSources>

<DataSource Name="MovexDataSource">

<DataSourceReference>MovexDataSource</DataSourceReference>

<rd:DataSourceID>c9a3a444-cc12-43b8-b9c9-7330b1500981</rd:DataSourceID>

</DataSource>

</DataSources>

<BottomMargin>2.5cm</BottomMargin>

<RightMargin>2.5cm</RightMargin>

<PageWidth>21cm</PageWidth>

<ReportParameters>

<ReportParameter Name="parameter1">

<DataType>String</DataType>

<AllowBlank>true</AllowBlank>

<Prompt>Report_Parameter_0</Prompt>

</ReportParameter>

<ReportParameter Name="parameter2">

<DataType>String</DataType>

<AllowBlank>true</AllowBlank>

<Prompt>Report_Parameter_1</Prompt>

</ReportParameter>

</ReportParameters>

<rd:DrawGrid>true</rd:DrawGrid>

<InteractiveWidth>8.5in</InteractiveWidth>

<rd:GridSpacing>0.25cm</rd:GridSpacing>

<rd:SnapToGrid>true</rd:SnapToGrid>

<Body>

<ColumnSpacing>1cm</ColumnSpacing>

<ReportItems>

<Textbox Name="textbox1">

<rd:DefaultName>textbox1</rd:DefaultName>

<ZIndex>1</ZIndex>

<Width>12.69841cm</Width>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>20pt</FontSize>

<Color>SteelBlue</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.91429cm</Height>

<Value>ABC-analysis</Value>

</Textbox>

<Table Name="table1">

<Footer>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="textbox11">

<rd:DefaultName>textbox11</rd:DefaultName>

<ZIndex>26</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox12">

<rd:DefaultName>textbox12</rd:DefaultName>

<ZIndex>25</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox14">

<rd:DefaultName>textbox14</rd:DefaultName>

<ZIndex>24</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox13">

<rd:DefaultName>textbox13</rd:DefaultName>

<ZIndex>23</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox21">

<rd:DefaultName>textbox21</rd:DefaultName>

<ZIndex>22</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox20">

<rd:DefaultName>textbox20</rd:DefaultName>

<ZIndex>21</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox15">

<DataElementOutput>Output</DataElementOutput>

<rd:DefaultName>textbox15</rd:DefaultName>

<ZIndex>20</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontWeight>700</FontWeight>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<DataElementStyle>ElementNormal</DataElementStyle>

<CanGrow>true</CanGrow>

<DataElementName>totalSales</DataElementName>

<Value>=Sum(Fields!SALES.Value, "MovexDataSource")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox16">

<rd:DefaultName>textbox16</rd:DefaultName>

<ZIndex>19</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox17">

<rd:DefaultName>textbox17</rd:DefaultName>

<ZIndex>18</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.63492cm</Height>

</TableRow>

</TableRows>

</Footer>

<DataSetName>MovexDataSource</DataSetName>

<Top>1cm</Top>

<TableGroups>

<TableGroup>

<Footer>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="textbox29">

<rd:DefaultName>textbox29</rd:DefaultName>

<ZIndex>17</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox30">

<rd:DefaultName>textbox30</rd:DefaultName>

<ZIndex>16</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox31">

<rd:DefaultName>textbox31</rd:DefaultName>

<ZIndex>15</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox32">

<rd:DefaultName>textbox32</rd:DefaultName>

<ZIndex>14</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox33">

<rd:DefaultName>textbox33</rd:DefaultName>

<ZIndex>13</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox34">

<rd:DefaultName>textbox34</rd:DefaultName>

<ZIndex>12</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox35">

<rd:DefaultName>textbox35</rd:DefaultName>

<ZIndex>11</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox36">

<rd:DefaultName>textbox36</rd:DefaultName>

<ZIndex>10</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox37">

<rd:DefaultName>textbox37</rd:DefaultName>

<ZIndex>9</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.63492cm</Height>

</TableRow>

</TableRows>

</Footer>

<Header>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="textbox8">

<rd:DefaultName>textbox8</rd:DefaultName>

<ZIndex>35</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox19">

<rd:DefaultName>textbox19</rd:DefaultName>

<ZIndex>34</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox22">

<rd:DefaultName>textbox22</rd:DefaultName>

<ZIndex>33</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox23">

<rd:DefaultName>textbox23</rd:DefaultName>

<ZIndex>32</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox25">

<DataElementOutput>Output</DataElementOutput>

<rd:DefaultName>textbox25</rd:DefaultName>

<ZIndex>31</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<DataElementName>ABC</DataElementName>

<Value>=IIF((RunningValue(Fields!SALES.Value,Sum,Nothing)/Sum(Fields!SALES.Value))*100&lt;50, "A", IIF((RunningValue(Fields!SALES.Value,Sum, Nothing)/Sum(Fields!SALES.Value))*100 &lt; 80, "B", IIF((RunningValue(Fields!SALES.Value,Sum, Nothing)/Sum(Fields!SALES.Value))*100&lt;98, "C", "D")))</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox24">

<rd:DefaultName>textbox24</rd:DefaultName>

<ZIndex>30</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox26">

<rd:DefaultName>textbox26</rd:DefaultName>

<ZIndex>29</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox27">

<rd:DefaultName>textbox27</rd:DefaultName>

<ZIndex>28</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox28">

<rd:DefaultName>textbox28</rd:DefaultName>

<ZIndex>27</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value />

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.63492cm</Height>

</TableRow>

</TableRows>

</Header>

<Grouping Name="table1_Group1">

<GroupExpressions>

<GroupExpression>=IIF((RunningValue(Fields!SALES.Value,Sum,Nothing)/Sum(Fields!SALES.Value))*100&lt;50, "A", IIF((RunningValue(Fields!SALES.Value,Sum, Nothing)/Sum(Fields!SALES.Value))*100 &lt; 80, "B", IIF((RunningValue(Fields!SALES.Value,Sum, Nothing)/Sum(Fields!SALES.Value))*100&lt;98, "C", "D")))</GroupExpression>

</GroupExpressions>

</Grouping>

</TableGroup>

</TableGroups>

<Details>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="txtRowNr">

<ZIndex>8</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=RowNumber("MovexDataSource")</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="CODE">

<rd:DefaultName>CODE</rd:DefaultName>

<ZIndex>7</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!CODE.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="LABEL">

<rd:DefaultName>LABEL</rd:DefaultName>

<ZIndex>6</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!LABEL.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="txtPrcWholeSale">

<DataElementOutput>Output</DataElementOutput>

<ZIndex>5</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<Format>P</Format>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<DataElementStyle>ElementNormal</DataElementStyle>

<CanGrow>true</CanGrow>

<DataElementName>elemPrecent</DataElementName>

<Value>=Fields!SALES.Value/Sum(Fields!SALES.Value)</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="txtABC">

<ZIndex>4</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<Format>P</Format>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=IIF(ReportItems!txtCulumPrc.Value*100&lt;50, "A", IIF(ReportItems!txtCulumPrc.Value*100 &lt; 80, "B", IIF(ReportItems!txtCulumPrc.Value*100&lt;98, "C", "D")))</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="txtCulumPrc">

<ZIndex>3</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<Format>P</Format>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=RunningValue(Fields!SALES.Value,Sum,Nothing)/Sum(Fields!SALES.Value)</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="SALES">

<rd:DefaultName>SALES</rd:DefaultName>

<ZIndex>2</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!SALES.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="AVERAGEONHAND">

<rd:DefaultName>AVERAGEONHAND</rd:DefaultName>

<ZIndex>1</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!AVERAGEONHAND.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="SHELFLIFE">

<rd:DefaultName>SHELFLIFE</rd:DefaultName>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>=Fields!SHELFLIFE.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.8584cm</Height>

</TableRow>

</TableRows>

</Details>

<Header>

<TableRows>

<TableRow>

<TableCells>

<TableCell>

<ReportItems>

<Textbox Name="textbox7">

<rd:DefaultName>textbox7</rd:DefaultName>

<ZIndex>44</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>11pt</FontSize>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>No</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox2">

<rd:DefaultName>textbox2</rd:DefaultName>

<ZIndex>43</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>11pt</FontSize>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Code</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox3">

<rd:DefaultName>textbox3</rd:DefaultName>

<ZIndex>42</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>11pt</FontSize>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Label</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox9">

<rd:DefaultName>textbox9</rd:DefaultName>

<ZIndex>41</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>11pt</FontSize>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>% kogu m??gist</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox10">

<rd:DefaultName>textbox10</rd:DefaultName>

<ZIndex>40</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>11pt</FontSize>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>ABC</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox18">

<rd:DefaultName>textbox18</rd:DefaultName>

<ZIndex>39</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>11pt</FontSize>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Kulumatiivne %</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox4">

<rd:DefaultName>textbox4</rd:DefaultName>

<ZIndex>38</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>11pt</FontSize>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Sales</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox5">

<rd:DefaultName>textbox5</rd:DefaultName>

<ZIndex>37</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>11pt</FontSize>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Average on hand</Value>

</Textbox>

</ReportItems>

</TableCell>

<TableCell>

<ReportItems>

<Textbox Name="textbox6">

<rd:DefaultName>textbox6</rd:DefaultName>

<ZIndex>36</ZIndex>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>11pt</FontSize>

<BorderColor>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Value>Shelf life</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

<Height>0.8916cm</Height>

</TableRow>

</TableRows>

<RepeatOnNewPage>true</RepeatOnNewPage>

</Header>

<TableColumns>

<TableColumn>

<Width>4.45cm</Width>

</TableColumn>

<TableColumn>

<Width>4.45cm</Width>

</TableColumn>

<TableColumn>

<Width>4.45cm</Width>

</TableColumn>

<TableColumn>

<Width>3.75cm</Width>

</TableColumn>

<TableColumn>

<Width>5cm</Width>

</TableColumn>

<TableColumn>

<Width>4cm</Width>

</TableColumn>

<TableColumn>

<Width>4.45cm</Width>

</TableColumn>

<TableColumn>

<Width>4.45cm</Width>

</TableColumn>

<TableColumn>

<Width>4.45cm</Width>

</TableColumn>

</TableColumns>

</Table>

</ReportItems>

<Height>4.65476cm</Height>

</Body>

<rd:ReportID>6f110699-9d81-4892-b485-e376555cff74</rd:ReportID>

<LeftMargin>2.5cm</LeftMargin>

<DataSets>

<DataSet Name="MovexDataSource">

<Query>

<rd:UseGenericDesigner>true</rd:UseGenericDesigner>

<CommandText>SELECT MMITNO as Code, MMITDS AS Label, SUM(UCIVQT) As Sales, MBAVST as AverageOnHand, MBSLDY as ShelfLife

FROM MVXJDTATIG.MITMAS --MM Item

,MVXJDTATIG.OSBSTD --UC Sales statistic

,MVXJDTATIG.MITBAL --MB Item balance

WHERE UCCONO = 1

AND MMITNO=UCITNO

AND MMITNO=MBITNO

AND UCDIVI='230' AND UCFACI='230' AND UCWHLO='230'

AND UCDLDT BETWEEN ? AND ?

GROUP BY MMITNO, MMITDS, MBAVST, MBSLDY

ORDER BY SUM(UCIVQT) DESC

FETCH FIRST 100 ROWS ONLY</CommandText>

<QueryParameters>

<QueryParameter Name="?">

<Value>=Parameters!parameter1.Value</Value>

</QueryParameter>

<QueryParameter Name="?">

<Value>=Parameters!parameter2.Value</Value>

</QueryParameter>

</QueryParameters>

<DataSourceName>MovexDataSource</DataSourceName>

</Query>

<Fields>

<Field Name="CODE">

<rd:TypeName>System.String</rd:TypeName>

<DataField>CODE</DataField>

</Field>

<Field Name="LABEL">

<rd:TypeName>System.String</rd:TypeName>

<DataField>LABEL</DataField>

</Field>

<Field Name="SALES">

<rd:TypeName>System.Decimal</rd:TypeName>

<DataField>SALES</DataField>

</Field>

<Field Name="AVERAGEONHAND">

<rd:TypeName>System.Decimal</rd:TypeName>

<DataField>AVERAGEONHAND</DataField>

</Field>

<Field Name="SHELFLIFE">

<rd:TypeName>System.Decimal</rd:TypeName>

<DataField>SHELFLIFE</DataField>

</Field>

</Fields>

</DataSet>

</DataSets>

<Width>39.45cm</Width>

<InteractiveHeight>11in</InteractiveHeight>

<Language>en-US</Language>

<TopMargin>2.5cm</TopMargin>

<PageHeight>29.7cm</PageHeight>

</Report>

View Replies !   View Related
RunningValue In Data Field
I want to calculate a cummulative total and store it in a data field.  I have tried the following formula in the Data Field.

Name: CUMMSTKS

Calculated Field: =RunningValue(Fields!STKS.value, sum, nothing)

Every time I do that, Visual Studio 2005 crashes.

Any suggestions?

View Replies !   View Related
RunningValue Or Cache Problem
Hello all,
 
I have a problem with RunningValue, or at least I think that€™s the problem.
 
The Report
I developed a General Ledger Report that uses a table control and it has a column called Account Balance which has a running total.  The report has a date range parameter consisting of Year/Month (e.g. 2006/02 €“ 2006/06), and the report is sorted by date with totals the balance at the end of each month.  From the beginning period (say 2006/02), I can determine the previous month€™s totals that I use to start the opening balance for this Account Balance column.  The opening balance value (control cell name txtAccountBalance_Grp4Hdr) is found on the detail header line and the running value (control cell name txtAccountBalance_Dtl) is found on the detail line. 
 
txtAccountBalance_Grp4Hdr
=Fields!PrevMonthBalance.Value
 
txtAccountBalance_Dtl.Value
=RunningValue(Fields!Amount.Value, Sum, "grpGroup2") +
    iif(Code.GetBeginingPeriod()=Fields!Period.Value,Fields!PrevMonthBalance.Value,0)
 
Public Function GetBeginingPeriod() As Integer
    Return Month(CDate(Report.Parameters!pstrPeriodBeg.Value))
End Function
 
Hopefully this is enough info to describe the report.  Think of it as a checking account with running values to determine what your balance is.
 
The Problem
For txtAccountBalance_Dtl.Value, The report correctly adds the opening balance to the first row of the first monthly group, but it then erroneously adds this value again in the first row of the second monthly group.  From that point on the running value is correct if you off-set the error I just described.  As you can see for the value property of txtAccountBalance_Dtl, I need to check to see if it is the beginning period, and if so add it, if not ignore it. 
 
I have run the report numerous times and I am getting the same error pattern.  For example, If I select the data range starting from the beginning of the year, the opening balance will always be zero in which case the report works out correctly, because it is adding zero twice which of course has no effect.
 
My theory is that when the report investigates the value for Fields!Period.Value (which determines whether it is the first month) the value has not been flushed out before it is displays txtAccountBalance_Dtl.Value
 
???
 
Hope this makes sense.

View Replies !   View Related
Row Number Assigned Via RunningValue But Without Grouping
I have a report where certain columns have values that get repeated, but the client has a rigid requirement for not wanting these columns as groups in the reports (other programs and exports doing specific tasks with those values).  In these reports, the "hide duplicates" value is checked, so as to give an aesthetic sense of grouping.

The data for the report, in raw form is:








Value 1
A

Value 1
B

Value 1
C

Value 2
D

Value 2
E

Value 2
F

Value 3
G

Value 3
Hetc...

In its aesthetic form, it is:








Value 1
A


B


C

Value 2
D


E


F

Value 3
G


H

My question is, how can I use RunningValue() to give me the following row numbers based upon those repeated values acting as grouping, since I'm not using formal grouping in the report design?

 









Value 1
1
A


2
B


3
C

Value 2
1
D


2
E


3
F

Value 3
1
G


2
H

 

Thanks for any input!

View Replies !   View Related
Sum Or RunningValue Incorrect From Group Footer
I've read a bunch of threads and can't seem to find an exact problem as what I'm having.
 
I believe my problem is simple enough to understand, but might not be that simple to solve. I'm hoping otherwise.
 
My report shows columns:
 
CustomerNumber
CustomerName
SummedInvoiceAmounts (summed from SQL query)
Region
 
The problem is that we have the same CustomerNumber with multiple CustomerNames:
 
CustomerNumber      CustomerName      Sum        Region
ABC                         advancedballoon    1000        East
ABC                         AdvancedBall.       1000        East
 
As you can see they are the same company but in our Accounting system they show up mulitple times (about 20 companies like this). This is from clerks adding in multiple ways or misspelling, etc. Can't fix, but have to work around.
 
Anyhow, I have my detail row that shows two lines for the companies like this and one line for the companies that are correct. I have this report I have added two groups "Region", "CustomerNumber".
 
If I put all the detail Fields down in the CustomerNumber footer and hide the detail row the report looks fine to the eye. When adding a Sum down in the Region footer field though; it pulls in the added amount and makes the total wrong.
 
I tried running value, but it's basically the same as the sum for what I need and it doesn't work. Is there a simple way to do this using the reporting tool? In Crystal this was very easy, but I haven't figured this out yet. Any help would be greatly appreciated. Thanks.

View Replies !   View Related
Chart With RunningValue In A SubReport In A Table Doesn't Work Correctly.
I have a chart, based on an MDX query. The chart includes three data series, one of which is a RunningValue calculation.  That chart, as a standalone report, works just fine with every combination of parameters I can throw at it.
 
I have another report which contains a table, based on another MDX query.  The result rows from that MDX query are the parameter values that drive the chart.
 
I've dropped a SubReport targeting the chart report into the Table, expecting to see my chart executed once for each row of the table, with parameters being driven by the data in the table.
 
Indeed, that's exactly what I do see, except for the data series that uses RunningValue.  It's correct for the first chart on the page, then wrong for every subsequent chart on the page (I think it's possibly showing the data from the first chart, but the scales are different on each chart, so it's hard to be sure).  I echo all of the report parameters in the chart title, so I can see that the sub-report is being invoked with the correct parameters everywhere.  I can watch the report execute using SQL Profiler and see that the correct queries were issued against the database.
 
I've tried two different definitions for the RunningValue expression - they differ only in how the group used as the "scope" is defined.  In both cases, this group is a "SeriesGroup" defined within the chart.  Option 1 simply defines the group-by terms for the group as "1".  For option two, I listed all of the dataset columns that echo the input parameters to the chart.  Both produce the same nonsense results for RunningValue in the second and subsequent instances of the chart on the master report.
 
Any ideas?

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved