Solved

Is it possible to put group by information in the header

Posted on 2012-04-04
6
352 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
ID: 37808235
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
ID: 37808475
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
ID: 37808585
ooops i figured it out i was saying ReportItem i should have said ReportItems
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Closing Comment

by:vbnetcoder
ID: 37808586
ty
0
 
LVL 1

Expert Comment

by:Just-Joe
ID: 37808590
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
ID: 37808604
Sorry -I was posting as you were posting it seems.  Glad you got it working.

Best regards.

JJ
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

910 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

23 Experts available now in Live!

Get 1:1 Help Now