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.
vbnetcoderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

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.