Is there a MS Report writer expert here?

[arw01]

I hate MS VS report writer compared to Crystal reports.

I want to do some running totals based on if a particular field has one value or the other.

Is there a nice simple tutorial someplace on running sub-totals based on a value in the detail?

 

[arw01]

found the forums on microsoft specific to SSRS but still banging my head against the wall on this one.

 

[tomas]

You might consider setting it up in MS Access. The built-in wizards make a lot of the tasks fairly easy. You can also write programs for Access using VBA, which is a variation of Visual Basic.

Tomas

 

[jimbob91577]

What exactly do you mean - for example do you want to total of all the positive values in a column versus the total of all the values in the column?

Say the column had the following:

1234.56
1234.56
-200.00
1234.56
======
3703.68 (versus 3503.68 if you include the negative number)

PM me some additional information and i'll see if I can help.

 

[arw01]

Will PM, but I basically want to count how many A things happen vs B things and have a total that I can print out in the group header.

Visual Studio Reports don't seem to have a natural running total function like crystal does.

 

[arw01]

With some help on the ms forum I now have a total running on the detail lines with:

=sum(iif(Fields!objet.Value = "Estimate Given",1,0)) working. Have asked how to get that to print into the header/footer of the group so I get the total where I need it, and not on the detail lines.