Solved

Is it possible to put group by information in the header

Posted on 2012-04-04
6
351 Views
Last Modified: 2012-08-13
In my reports, I have a field (businessID), that I want to group by. Per each businessid group, I want to 1) put the value of the businessid in the header and then 2) break to the next page per
each instance of a new group.

Is this possible? If so, how would i got about doing so.
0
Comment
Question by:vbnetcoder
  • 3
  • 3
6 Comments
 
LVL 1

Accepted Solution

by:
Just-Joe earned 500 total points
Comment Utility
Hi vbnetcoder,

Try this:
1) Group by businessID in your Table/Tablix , make it Hidden (you can alos make it small as possible if it messes up your format) and select "page break per each instance..."
2) Reference the textbox that you just hid in the report header with another textbox with an expression ReportItems!<name of first textbox>.value

~Just-Joe
0
 

Author Comment

by:vbnetcoder
Comment Utility
I get an error:

Reportitem is a type and cannot be used as and expression.

This is what i put in the expression for the textbox that is in the header:

=ReportItem!TextboxCompanyHidden.value
0
 

Author Comment

by:vbnetcoder
Comment Utility
ooops i figured it out i was saying ReportItem i should have said ReportItems
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Closing Comment

by:vbnetcoder
Comment Utility
ty
0
 
LVL 1

Expert Comment

by:Just-Joe
Comment Utility
What is the name of the textbox in the group? "TextboxCompanyHidden"?  For our example let's use "Textbox1" as the name of the grouping textbox and "Textbox2" as the textbox in the report header:

In the Report Header, the textbox2 expression should be:   =ReportItems!Textbox1.Value".

(sorry I misspelled before.  ReportItem should be ReportItems, with an "s")

and make sure to check the group properties for Page Break to "Between each instance of a group"

I've tested this and it works for me.
0
 
LVL 1

Expert Comment

by:Just-Joe
Comment Utility
Sorry -I was posting as you were posting it seems.  Glad you got it working.

Best regards.

JJ
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now