Add Line for Series Group Total to chart

Have trend chart with lines for monthly costs for individual assets. I need
to add another line for the total each month. When I add a new Value to sum
the costs, I get duplicate lines on the chart. What am I doing wrong?
TIA
DeanIn your new Value set the following value:
= sum(Fields!Yourfield.Value, "DATASETNAME")
Hope this helps.
"Dean" <deanl144@.hotmail.com.nospam> escribió en el mensaje
news:uv2uapZEIHA.3548@.TK2MSFTNGP06.phx.gbl...
> Have trend chart with lines for monthly costs for individual assets. I
> need to add another line for the total each month. When I add a new Value
> to sum the costs, I get duplicate lines on the chart. What am I doing
> wrong?
> TIA
> Dean
>

Add blank lines after end of data on group

I have a report that looks sort of like:
Route: 123
Name: Jim
Name: Sue
Name: Mary
Route: 456
Name: Monica
Name: Steve
which page breaks on "Route". What i need is to have blank lines to
fill to the end of the page like:
Route: 123
Name: Jim
Name: Sue
Name: Mary
Name:
Name:
Name:
Name:
Name:
Name:
Thank you in advance!
Cheers,
SteveOn Dec 4, 4:18 pm, sfp <stevenprev...@.gmail.com> wrote:
> I have a report that looks sort of like:
> Route: 123
> Name: Jim
> Name: Sue
> Name: Mary
> Route: 456
> Name: Monica
> Name: Steve
> which page breaks on "Route". What i need is to have blank lines to
> fill to the end of the page like:
> Route: 123
> Name: Jim
> Name: Sue
> Name: Mary
> Name:
> Name:
> Name:
> Name:
> Name:
> Name:
> Thank you in advance!
> Cheers,
> Steve
Unfortunately, this type of behavior is not supported; however, you
could try using a while loop and determining the number of records per
page in T-SQL (the stored procedure/query that is sourcing the report)
and then return (x - known records per Route) as null/blank rows,
where x is the number of records that will fit on a page when printed/
etc based on your desired export option. Another much less desirable
option would be to modify the report after the fact using a
custom .NET application that utilizes StreamReader, StreamWriter, etc.
With this option, you can control extra text down to the character;
however, this a good deal of work and most likely is not the best
option for you situation. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi
Heres another tip to do what you want , I assume you are using a
table. Place another column in your table and use =rownumber(nothing).
When you render the report, you'll see the number of rows which are
created prior to the page break. Lets say 10 rows are created. Now
write a stored proc or a query , something like this
Declare @.counter int
Declare @.Temp table (rowno int)
Set @.counter=0
While @.Counter<10
Begin
Insert into @.Temp
Select @.Counter
Set @.counter = @.Counter + 1
End
Select * from @.Temp
Now create another table object under the one you have created, with
one column , no header or footer and the above data source. Hardcode
the value "Name:" in the single column . That should do it. Please be
aware that I have not tested the code I have written.
Cheers
Shai
On Dec 5, 11:11 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Dec 4, 4:18 pm, sfp <stevenprev...@.gmail.com> wrote:
>
>
> > I have a report that looks sort of like:
> > Route: 123
> > Name: Jim
> > Name: Sue
> > Name: Mary
> > Route: 456
> > Name: Monica
> > Name: Steve
> > which page breaks on "Route". What i need is to have blank lines to
> > fill to the end of the page like:
> > Route: 123
> > Name: Jim
> > Name: Sue
> > Name: Mary
> > Name:
> > Name:
> > Name:
> > Name:
> > Name:
> > Name:
> > Thank you in advance!
> > Cheers,
> > Steve
> Unfortunately, this type of behavior is not supported; however, you
> could try using a while loop and determining the number of records per
> page in T-SQL (the stored procedure/query that is sourcing the report)
> and then return (x - known records per Route) as null/blank rows,
> where x is the number of records that will fit on a page when printed/
> etc based on your desired export option. Another much less desirable
> option would be to modify the report after the fact using a
> custom .NET application that utilizes StreamReader, StreamWriter, etc.
> With this option, you can control extra text down to the character;
> however, this a good deal of work and most likely is not the best
> option for you situation. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -