• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

Is it possible to put group by information in the header

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
vbnetcoder
Asked:
vbnetcoder
  • 3
  • 3
1 Solution
 
Just-JoeCommented:
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
 
vbnetcoderAuthor Commented:
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
 
vbnetcoderAuthor Commented:
ooops i figured it out i was saying ReportItem i should have said ReportItems
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
vbnetcoderAuthor Commented:
ty
0
 
Just-JoeCommented:
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
 
Just-JoeCommented:
Sorry -I was posting as you were posting it seems.  Glad you got it working.

Best regards.

JJ
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now