Solved

Underlay following section option in Sql Server Reporting Services

Posted on 2010-08-26
6
1,383 Views
Last Modified: 2012-05-10
Dear Experts,

I have one report made in reporting services.
I want to display details section of report with group header section.  Is there underlay following section
feature in SSRS like crystal reports.

In the attached file, i want to display vessel name in the same line of CPIC name

Thanks and Regards
Subodh Anant Mestry
Report-CPIC-Individual-Details.pdf
0
Comment
Question by:swarajya
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:tickett
ID: 33532810
How have your got the report canvas configured/laid out which is causing the vessel name to be below and not in-line?

L
0
 

Author Comment

by:swarajya
ID: 33534342
Thanks for your prompt answer.

Vessel Name is kept in detailed section and all the other fields in group header section.

Thanks
0
 
LVL 11

Expert Comment

by:tickett
ID: 33535190
Ahh- i see. As mentioned, i'm new to SSRS but i expect there is some form of "first record of group" expression. Try looking at the definition of: RowNumber()

http://msdn.microsoft.com/en-us/library/ms157328.aspx

You can then place the vessel field in both the group header and the detail section. The conditionaly hide the detail section where RowNumber(groupname)=1

Hope that helps!

L
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 10

Expert Comment

by:itcouple
ID: 33540548
Hi
First is the function which should take first item from a group of items. Subreports are also quite useful where you want to embed certain elements based on the group data (used as subreport parameters).

Regards
Emil
0
 

Accepted Solution

by:
swarajya earned 0 total points
ID: 33548489
Dear Experts,

Thanks for replies. I found the solution.  

I took one List object from reporting services toolbox.  

Right Click on list -> Properties -> General Tab -> Edit Details Group -> In expression select field to group on.

In my case it is CPIC Name


Then add table in that list from toolbox

In details section of table, add field which is from transaction table (in my case it is vessel name)

Format the table properly and drag that list control to the header part of parent table.

That will do the trick.

Anyways thaks for your reply.
0
 
LVL 11

Expert Comment

by:tickett
ID: 33552513
Thanks for the update :) If you haven't already, click on the "accept" link against your own solution.

L
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
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…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

896 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

17 Experts available now in Live!

Get 1:1 Help Now