.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Want to show a group header item only when the group value changes

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :Sql Server
Hi,    We have a couple of reports that show lines for a customer order. We were told to add notes for each line that were entered in our oe portal so our manufacturers and shippers could see them. I've done this but the group header for an order ine is set to repeat so the note shows on every page.Each line can take up several pages due to the fact that lot pick information is displayed for each line.     When the notes are long, it can create a report that is very long, simply due ot the extra space need on each page. We would like the line note to to appear ONLY when the value of the line number changes and we are on a new line and not after. Is there a way to detect that the line group value has changed and to print the note then but not after until a new line number is reached?    Any help would be appreciated. fig000

View Complete Post

More Related Resource Links

Group By With Collapse="TRUE" doesn't show list item.


I created a SharePoint Page.  I then inserted an XsltListViewWebPart web part via SharePoint Designer 2010.  I then modified the CAML to include a couple of filters.  I then added a start date and end date parameter.  Then I saved my page and went into SharePoint.  I added two date filters (start date and end date) and I connected them to the  XsltListViewWebPart web part.  Then I selected a start date and end date and the list is correctly filtered.  The list is grouped by district and location.  However, when I expand the district and then I expand the location, it says "Loading...." but then it never loads anything.  If I change it to Collapse="FALSE" everything works fine???  Any help would be greatly appreciated.




         <FieldRef Name="Created"/>
         <Value Type="DateTime">{StartDate}</Value>

RDLC Group Header to show the first not null value of a field.


I have a group header that's generated from a Field that comes from the database.

Like this: 


Cab04R	Val04R	Cab05R	Val05R

AV Rec	100,753	NULL		NULL

AV Rec	101,753	NULL		NULL

AV Rec	102,753	NULL		NULL

AV Rec	103,753	NULL		NULL

AV Rec	104,753	NULL		NULL

AV Rec	105,753	NULL		NULL

AV Rec	106,753	NULL		NULL

AV Rec	107,753	NULL		NULL

AV Rec	108,753	Ferias Rec	653,675



Where the Cab04 and Cab05 refers to Table Headers and Val04 and Val05 to Table Details.


The thing is, I want that Cab05 to show the first not null value (in this case, "Ferias Rec") and if it is null, no problem I already have a Hidden Expression for that.


Can you help me?


Adding group header in the cascading dropdown

Hi,   I have a cascading drop down, and in one of the dropdown i want to add a group header.    i,e suppose if i list the names (of girls and boys) i want to group them in a dropdown say(Girls and Boys as header under them the names)   Girls aaa bbb ccc Boys ddd gggt   Can anybody please help me

adding row group header after the fact

I am aware that when adding a row group, a prompt asks you if you want to add the header and footer.  On my report, all the groupings are already created and do not want to have to recreate them again;  how can I add just the row group header? I can't seem to find the option   Thanks!Javier Guillen

New Item Added to List/Library trigers Alert to non-AD Security Group

I am trying to implement an alert when a new item is added to a list. Idealy this alert would be sent to either a SharePoint Group or a AD Distribution Group. I do not have access/authroization to create security groups. The research I have found so far tells me that I can only add AD users and AD mail-enabled security groups through the alert GUI. My questions is first is this a valid finding? Second, if I create a custom workflow can I have the workflow triger on new item added and have it send a notification to the specified SharePoint/Distribution group? Thank you in advance for your assistance.  

Repeat Group Header on subsequent pages of the same group

Hi, I am using a free-form list. I need the group header row to repeat on every subsequent page corresponding to the same group. If the subsequent pages still contains footer data from the current group, I want to be able to repeat the header of that said group until the group data changes. I have 2 groups, both have header and footer and I also have one detail line. The header portion  that I need to repeat is actually inside the inner group2 header.  I've tried setting RepeatOnNewPage and FixedData to true for the static row group as suggested in many blogs about this issue to no avail. I have also tried setting KeepWithGroup to both Before and After, but nothing works. I am using BIDS for SSRS 2008

Hide a measure group in excel 2007 'Show Fields Related to'


Hi All,

I know that if a I want to hide a measure group to users I have to set the properties 'Visible' to false for all the measure of the measure group.

But when I open a connection to the cube with Excel 2007 I see again the measure group in the drop down list 'Show Fields Related to' in the 'Pivot Table Fields List'.

I don't see it in the measure group list when I choose 'All' in the 'Show Fields Related to', but i don't want to see it in the list 'Show Fields Related to' too.


How I can do to hide permanently the measure group?


Thank you all,


Show users based on ad-security group or OU


Will it somehow be possible to show members of a AD group ?

We have some superusers, and they all have the ad-group: super_users.

Can i show all members somehow ?

Maybe by a search flag, so it is just a link to a search result ?

Jakob Olsen

How to add frozen header under group header?



I whant to add another header in report.


         Name         LastName              Store

     +    test             test1                     a 

            text             text                                  New Frozen header

               a               b                         c  

     +   &

How to show group totals only at the last page?


Hi All,

I am facing difficulty to show the group totals in the SSRS 2008.

I have group on feilds country,state,city with details group suppose i have choosen country as India,then the state have two values then i need show the report with totals like below.

O/p for state1




col1 col2 col3 col4

city totals

State totals

O/p for state 2




col1 col2 col3 col4

city totals

State totals

Country totals

the difference b/w two outputs is like i need to show the country totals only at the last state totals.

thanks in advance.

Veeren :)

Formatting -- Tucking the child columns under the group header:


I seem to have missed something somewhere.

How do you get a report organized like:


Rather than:


You can't be successful at this unless you're at least 1/2 a bubble off level.

Restict access to page fields. How to show field value to members of certain group?


I have the fields that should be shown for members of one group. How to implement this behavior?

Also i need to restrict access to editing other field for all except of limited amount of persons. How to do this?


All these questions are related to Site Content Types and Page Layouts.

Show/Hide fields on InfoPath based on context User Group Membership

I am reading a book on SharePoint 2010 Development by Wrox and although it is a good book, the InfoPath section is limited. I am Googling to see if I can find anywhere where i can perhaps have this type of functionality to hide and show a specific field based on their Group Membership?
Victor Palma

How to show correct info in dataview group footer



I think this is more of an xslt type question. Still learning more about it everyday. Just need some help or a guide to the right direction.

I've created a dataview that has grouping enabled. There's just 1 level grouping. I've enabled both "Show group header" and "Show group footer".

In the group header section, I manually inserted the following to get certain info

 <xsl:value-of select="@Cost" />

I've added the same thing in the group footer. The group header shows the correct info, but in the group footer, it shows the info of the next group header. So, I believe in the group footer, I need to enter the xslt to get info from the previous node/row. Just not sure how to put that as xslt. Would you be able to help?



Reporting Services 2005 - Scatter Report Unable to show category group



  I am using scatter chart to create some sort like


Quantity  Time  Machine Name

12 2010-09-10 04:21:11         M1

22 2010-09-10 19:21:11  M1

100 2010-09-11 05:21:11  M1

89 2010-09-11 07:21:11  M1


66 2010-09-12 07:21:11  M2

18 2010-09-13 07:21:11  M2


68  2010-09-12 07:21:11  M3


X-axis show me the quantity, Y-axis shows me the time and then machine name group its time and qty under different category group. How to make it.

I have tried to use scatter chart to display but I can only see the X and Y -axis and without category group shown...  

Deploying new group in elements doesn't show


When I run the feature my web parts create the group just fine. But when I deploy the wsp file to the server, my groups are not created.

  <File Path="WebpartName.webpart" Url="vpDashboard_DCSSales.webpart" Type="GhostableInLibrary" >
   <Property Name="Group" Value="SalesCharts"

Matrix group by row with multiple vlaues - Problem in header visibiltiy


since i have dynamic columns ,i used matrix control.

My data is given below.

AssessmenttypeId | SectionName | FieldName | value | PersonName |

4                          |  SecA           |  A1           | 0        |  Pers1

4                          |  SecA           |  A2          | 0        |  Pers1

4                          |  SecA           |  A3           | 1       |  Pers1

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend