?
Solved

Is it possible to put group by information in the header

Posted on 2012-04-04
6
Medium Priority
?
357 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 1

Accepted Solution

by:
Just-Joe earned 2000 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 Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this article I will describe the Backup & Restore 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.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

762 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