I have one textbox(a) that is calculated from other textbox values(b) in
list, and also have one textbox(c) that sums the values of textbox(a).
When all datas are included in one page, the sum value works, but when datas
are divided to many pages, it doesn't work because I need the total sum value
from all datas even if they are divided to many pages. (At the preview, (c)
has the whole sum value, but when try to print, datas are divided by page, so
(c) becomes no meaning value.)
Of course when I save report as "Web archive" file, (c) keeps the whole sum
value because there's no page format. But if possible I want to save as PDF
file and print.
sorry. I forgot the most important info.
The textbox(c) is in page footer, so I can sum the textbox(a) value (=
report item) in list.
By the way, I tried to avoid this problem by another way = changing page
size over 11 inches.
Sure, it works to get the whole sum value, but one page becomes very very
long. So when printing, the sum value goes out of page. :-(
What is the expression that you are using? sum(Fields(<FieldName>).value,<DatasetName>) should do the trick.... [quoted text, click to view] "Koala_mogumogu" wrote:
> I have one textbox(a) that is calculated from other textbox values(b) in
> list, and also have one textbox(c) that sums the values of textbox(a).
>
> When all datas are included in one page, the sum value works, but when datas
> are divided to many pages, it doesn't work because I need the total sum value
> from all datas even if they are divided to many pages. (At the preview, (c)
> has the whole sum value, but when try to print, datas are divided by page, so
> (c) becomes no meaning value.)
>
> Of course when I save report as "Web archive" file, (c) keeps the whole sum
> value because there's no page format. But if possible I want to save as PDF
> file and print.
>
Thank you for response, Kristen! The expression I'm using is sum(ReportItems!textbox_a.value) This is in page footer section, because I can't use this in page body section. If any expression that I can get what I want in page body section, it's perfect. But it seems impossible, so I'm using sum in footer. [quoted text, click to view] "Kristen" wrote:
> What is the expression that you are using?
>
> sum(Fields(<FieldName>).value,<DatasetName>)
>
> should do the trick....
>
> "Koala_mogumogu" wrote:
>
> > I have one textbox(a) that is calculated from other textbox values(b) in
> > list, and also have one textbox(c) that sums the values of textbox(a).
> >
> > When all datas are included in one page, the sum value works, but when datas
> > are divided to many pages, it doesn't work because I need the total sum value
> > from all datas even if they are divided to many pages. (At the preview, (c)
> > has the whole sum value, but when try to print, datas are divided by page, so
> > (c) becomes no meaning value.)
> >
> > Of course when I save report as "Web archive" file, (c) keeps the whole sum
> > value because there's no page format. But if possible I want to save as PDF
> > file and print.
> >
Depends what your requirement is. What is in "Textbox_a"? If it contains a field from a dataset then you would do this to display the sum of a particular field from a dataset in a Header/Footer: - Place a control with the expression =sum(Fields(<FieldName>).value,<DatasetName>) in the body only. - In the header/footer place another control with the expression =First(ReportItems(<ControlName>.Value) [quoted text, click to view] "Koala_mogumogu" wrote:
> Thank you for response, Kristen!
>
> The expression I'm using is
>
> sum(ReportItems!textbox_a.value)
>
> This is in page footer section, because I can't use this in page body section.
> If any expression that I can get what I want in page body section, it's
> perfect.
> But it seems impossible, so I'm using sum in footer.
>
> "Kristen" wrote:
>
> > What is the expression that you are using?
> >
> > sum(Fields(<FieldName>).value,<DatasetName>)
> >
> > should do the trick....
> >
> > "Koala_mogumogu" wrote:
> >
> > > I have one textbox(a) that is calculated from other textbox values(b) in
> > > list, and also have one textbox(c) that sums the values of textbox(a).
> > >
> > > When all datas are included in one page, the sum value works, but when datas
> > > are divided to many pages, it doesn't work because I need the total sum value
> > > from all datas even if they are divided to many pages. (At the preview, (c)
> > > has the whole sum value, but when try to print, datas are divided by page, so
> > > (c) becomes no meaning value.)
> > >
> > > Of course when I save report as "Web archive" file, (c) keeps the whole sum
> > > value because there's no page format. But if possible I want to save as PDF
> > > file and print.
> > >
Thank you so much for response again.
As I wrote in first message, textbox_a has calculated value from other
textboxes, and I can't get the value from dataset directly, because it's like
as follows:
textbox_a.value
= textbox_d.value - textbox_b.value * (textbox_c.value /
sum(textbox_c.value, table1))
One sale has many items. b is total cost of one sale, and c is weight of one
item, and d is sale amount of one item, so textbox_a.value means profit of
one item.
(These items are frozen fish so I have to calculate cost per item by weight)
And also I pick up some specified items with filtering in list (list
includes many sales) by product category, so I get profit sum by product
category.
I tried to get the value from conbined datasets and SQL queries, but it
becomes too complex and excess the number of views limit (256).
So now I'm trying to get the value by reporting service.
Actually I can get it if datas are included in one page, yes it works.
But now I have to avoid another problem, paging by report.
I don't mind any aproach for this problem. Any idea ?
Don't see what you're looking for? Try a search.
|
