Display Totals Only 1

[Auguy]

This may be a dumb question, but here goes. I have a sales report already completed that has each invoice's data on one line with a totals row at the bottom. I have been asked to add an option to just show the totals row. Can this be done without changing the report layout through some parameter passing or changing the way I execute the report? I am calling this report from a vb.net app. If this can't be done, what type of grouping could I add to include all of the detail lines and then let the user collapse(+/-) when needed?

Auguy
Sylvania, Ohio

 

[xlbo]

You can group your detail lines and show them as collapsed or Expanded. The "Collapse State" option can be controlled by an expression. an expression can refer to a parameter (=Parameters!ParamName)

So yes, you can control the initial collapse state of any groupings by a parameter

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Auguy]

Thanks Geoff. I guess I'm still confused as to exactly what grouping would I use. On another note, can I pass the "Hide Details" setting as a parameter?

Auguy
Sylvania, Ohio

 

[xlbo]

yes - anything where you can use an expression rather than a constant can refer to a paramter

All you need to do for the grouping is to create a group on your table (sounds like a group on invoice number would work for you). You then just set the "Initial Visibility" property as an expression e.g.

=iif(Parameters!ParamName = "Collapsed",TRUE,FALSE)

bear in mind that this property is actually referering to the HIDDEN property of the object so the logic is reversed from what you might expect.

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Auguy]

Thanks again. I solved some of my problem by passing the "HideDetail" parameter. It is still coming up with multiple pages of nothing but the header text, but I can click on the last page and get the totals to show. Combined with your help I think I can get this to work.

Auguy
Sylvania, Ohio

 

[xlbo]

How have you added the "Totals" ?

Did you use the shortcut on the right click menu or add them yourself as a new row ?

Also - how is the report laid out ? this can have a massive effect on the final look - personally I would use a standard table for this with a couple of groups to then subtotal on - this will work nicely for Totals to Detail reporting

I have done this myself on a few tables and it is certainly possibler to set it up so you don't have the white space!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Auguy]

If I remember correctly, I added the totals row manually. The white space doesn't bother me for now. I saved it to a PDF file and only one page was created. Will have to play around and see if I can eliminate the white space. Maybe I have something wrong in the page header text controls.

Auguy
Sylvania, Ohio

 

[xlbo]

Best way to do it would be to create a table

Put Invoice number as the far left column and then all data elements to the right of that.
Add subtotals from the Right Click menu
Add a Group from the properties menu of the table - Create the Group on Invoice Number.
Set the Initial Visibility property of the group to be dependant on a parameter

et voila (hopefully) !

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Auguy]

Geoff, thanks for all of the help, have a star!

Auguy
Sylvania, Ohio

 

[xlbo]

No probs - hope you get / got it working

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question