Solved

ssrs data field in header

Posted on 2011-03-21
9
803 Views
Last Modified: 2012-05-11
I have a SSRS2005 report and one of the datasets has two data elements in it. The first is a report parameter and the second is a comment. This comment repeats for all of the report parameters. What I want to do is have this comment appear in the header. When I try using the 'First' directive SSRS tells me that fields cannot be in the header or footer. Is there any way to get around this restriction?
0
Comment
Question by:rwheeler23
[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
  • 5
  • 4
9 Comments
 
LVL 27

Expert Comment

by:planocz
ID: 35186151
The data has to be in the main body of the report. So the next step is to hide (if you do not want to see it) the textbox that has the data that you want in the header and then in the header textbox use this type of code.
=ReportItems!MytextBoxName.Value
MytextBoxName is the name of the textbox that has the hide data in it.
The hidden textbox code will be something like:  =Fields!Comments.Value
0
 

Author Comment

by:rwheeler23
ID: 35195176
ReportItems!MytextBoxName.Value
It does not appear to know what the directive ReportItems is. Is this something that works in SSRS 2008?
0
 
LVL 27

Expert Comment

by:planocz
ID: 35195237
It works in 2005 I think it would work in 2008
0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

Author Comment

by:rwheeler23
ID: 35195239
Nevermind, I see that it is case sensitive. However, this is the text field I placed in the body. Even though I know that bchcomnt has a value, it always comes back blank.

=First(Fields!bchcomnt.Value, "BatchNumber")

0
 

Author Comment

by:rwheeler23
ID: 35195273
This is drinving me nuts. I just deployed the report and there is the comment. When I preview it under BIDS I do not see the comment.
0
 
LVL 27

Accepted Solution

by:
planocz earned 500 total points
ID: 35195287
with it being visible =true in your body that way you know that data is where.
if you have the the header right you should see the same data for testing
0
 
LVL 27

Expert Comment

by:planocz
ID: 35195293
Oh yea I forgot in 2005 you do not need to use the word  ---- First       in your code. only in 2008.
0
 
LVL 27

Expert Comment

by:planocz
ID: 35195316
If you use First in 2005 you will only get the first record and thats all. If the record is empty you will never see any data.
0
 

Author Comment

by:rwheeler23
ID: 35195370
Well I will live with in not appearing in BIDS because all the users will see is what appears in their browser. This comment, if it exists, is part of a batch in which all the transactions belong. So all I need is to see the first one. My report is set to give them a lookup by batch ID and that dataset contains the batch comment. Once they choose the batch, all the transactions in that batch are included on the report. I used the same technique for four other reports and the comment appears in all four of them in BIDS. It is just the first version where I do not see it in BIDS.

Thanks for all your help!
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

756 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