.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

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

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server

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.

View Complete Post

More Related Resource Links

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

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

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

Reorder List Header Columns Issue

Hello to all, Today my senior told me to add functionality of Drag N Drop inside the GridView then i googled it and i found that Reorder List is the Same control i am looking for. But after doing Analysis on that i found that these templates are there in ReOrder List Control DragHandleTemplate EditItemTemplate EmptyListTemplate InsertItemTemplate ItemTemplate ReorderTemplate Its same as gridview or listview control but its dosent support paging in that.But i am not able to found Header Template inside that Control.   So Can any 1 Tell me how can i add header Template inside ReOrder List so Each Column will have its Rows. My sample example 1 Column is Eating all my columns and the rest of the columns are blank. I am looking any solution for this.   Waiting for a Solution   Regards    

Dynamic columns on row group page

Hi, I have a SSRS (2008 R2) report on an Olap data source. On rows I have Agents (as a row group), on columns I have Stores (as a column group) and a measure, let's say SeelOutValue. I want to see sales from agents to stores. I added a page break between each group instance on the Agent row group => one page for an Agent, but the column stores are not filtered by the Agent. I want to see on an Agent page only the stores with values. My question: can I filter the columns (Stores column group) for each Agent (row group)?  Example Dataset:             Store1 Store2 Store3 Store4 Store5  Agent1     1                   1                    1     Agent2     2         2 Agent 3  .... Now an each Agent page there are all 5 stores columns (on Agent1 page column Store2 and Store4 without data). It is possible to see on Agent1 page only Store1, Store3 and Store5 columns, on Agent2 page Store1 and Store2 columns ... ?   Thanks in advance for your help!

Unable to Merge columns outside Group ? Unnecessary Row height ?

HI , In a matrix tablix , I'm unable to merge columns outside the group . Heres a quick screen shot . http://img843.imageshack.us/img843/366/samplema.png The top 3 columns is what i meant [ Unable to Merge columns outside Group ]  and Row height of the first row ? Thanks in Advance !!Rajkumar Yelugu

group only selected columns of tablix

i have a simple tablix, with item in rows and sales per year in columns...so depending upon the data available, the columns will be shown..from year 2010 back to any number of years..                   year item    2010      2009    2008    current yr   current yr + last yr 123     50           80        10            50            50+80=130 abc      119          29       40         119          119+29 = 148 now, i want to have a calculated columns ( current year sales ie first column value), (last two year sales ie first two column sum) how to achieve this.

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

FieldTypes for Multi Text and Person or Group Columns?


i am trying to insert an Item through List Web service.

i am able to insert, Text column fields. But unable to  insert an Image in Multi text line, and inserting dates for Date column,Person or Group  fields

Please suggest me on this

 XmlDocument doc = new XmlDocument();
           XmlElement batch = doc.CreateElement("Batch");
           batch.SetAttribute("OnError", "Continue");
           batch.SetAttribute("ListVersion", "1");
           batch.InnerXml = "<Method ID='1' Cmd='New'>" +
              "<Field Name='Title'>"+strTitle+"</Field>" +
               "<Field Name='MultiTextAnnouncement'>"+Announcement+"</Field>" +
                "<Field Name='StartDate' Type='DateTime'>" + DateTime.Now + "</Field>"

gridview header formatting



Using C# to develop a web application. Have a gridview to display data from the a sql table.

The headers of the gridview is achieve using a table. Need to format the header cells to align with the columns of the gridview.

Currently I'm using a trial an error method to set the width of the header to align with the gridview columns. Can I align the Table header to concide with the gird view column width progarmatically?

Here is my ASPX code

<div id="ProjectTableHeader" runat="server"
        style="background-color: #993300; height: 40px; width: 300; margin: 0; padding: 0">
        <table cellspacing="0" cellpadding="0" rules="all" border="1" id="tblHeader" style="font-family: Arial;font-size: 10pt; width: 300; color: white; border-collapse: collapse; height: 100%;">
                <td style="width: 64px; text-align: center">
                    Project Owner

Group Parent-Child attributes with same display value


Hi all, I am very new to SSAS and have a question that I can't seem to answer anywhere

I may want to implement a parent-child attribute (depending on limitations). If I have the following hierarchical structure




Cost Centre




Display columns in matrix based on a group even if data don't exist in resultset


I am trying to create columns in a matrix for data that currently does not exist.  I created a matrix that groups on office name (ROWS) and Month of Appointment Date (Columns).

For example, the matrix currently looks like this.....

  January February March April

SQL MAX() function selecting ALL columns and not only those in the GROUP BY clause


A school has classes. Each class has students. Each student may take up one or several courses.

One only table with thousands of rows contains the following columns (and some others):

  1. Student´s class
  2. Student id-number
  3. Student's course
  4. Student's grade (in the course)
  5. Some other rows. This table has about 25 rows

I need an only SELECT that brings ALL ROWS for each student's highest grade (grades are numbers, not letters).

In the example bellow, I have listed a fragment of the table and I have emphasized with bold and italic characters the rows that are supposed to be selected:

          Class       ID-number     Course     Grade     Row5   Row6   Row7... 

  1. Class-A         100001     Math&n

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  

     +   &

Gridview Header Columns


I want to change the text in headers in gridviews based on information in a database.  I want to databind to a gridview heading 

Group by on external data columns



I created an external content type "Auction" from a SQL table. I added an external data column "Auction" to my document library and selected a few fields to be shown as additional information on "Auction". I would like to create a view where the documents are grouped by one of those additional fields, but the field I need is not shown in the view settings... Is it possible to sort/group on the additional columns comming from from my external data column?





Combine Column Group Columns Into One?


I have a dataset like this:



1........... 09-2010................25,000




I have a report that shows this data by pivoting on the month and giving the remaining amount, like this:

BID......Aug-2010 Remaining........Sep-2010 Remaining.......Oct-2010 Remaining........Nov-2010 Remaining



This all works just fine. However now, I want to take a date that's given, and make a "Past Due" column for anything less than the first of the month of that date.


I have this partially working, as I can filter my column group to be >= CDate(Month(Parameters!CurrentDate.Value) & "/01/" & Year(Parameters!CurrentDate.Value)).


This would give me this:

BID.......Oct-2010 Remaining........Nov-2010 Remaining

1.......... 25,000..............................100,000


How do I combine the previous months into one column? Like this:

BID......Past Due Remaining.......Oct-2010 Remaining........Nov-2

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