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

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

Subreports within table/matrix cells are ignored.

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :Sql Server
I have Report with subReport,

in the designer its looked well, but when I export  the report to excell format

I get this error,

is it poosible export report with sub report to excell?


View Complete Post

More Related Resource Links

Super Complex Table/Matrix



I'm in a situation where I have to build a super complex table or rather matrix

This is how the table/matrix should look like: 




The complex thing is that everything is taken from a database.


I will try to explain the color sections one by one.


SERIE (Green area)

If we start with the top columns; SERIE 1, SERIE 2, SERIE 3

These values are coming from a table column value. If this column has the value 3 then I will need to print 3 table cells, just like in the image.




Then there is the outer left columns, that goes like this;

Behandlingsdag (meaning day of treatment)

Osplatin (100 mg/m2)

Leucovorin (x)

And so forth.


All these values are also coming from 3 different tables



One Column (Yellow area)

These cells are getting their values from a table. According to some true og false values.



1, 2, 3, 4 (Red area)

Then there is the table cells below the SERIES. These table cells goes like this

First there is a 1, then there are the tables cells 1 to 18 all below

Matrix (or table) like form: questions

Hi! I have to build a form to allow user to submit data; in some cases user should have to fill "matrix" forms, or table... I mean, I will have to define some columns, to be filled with data by user row by row (with the number of rows predefined too). So, I'm wondering if there's a smarter method to create a "matrix" like form than manually creating a grid with labels and textboxes. At first it seems that, at least visually speaking, datagrid could work; but i've always used it binded to some data source, so its population was automatic. Anyone knows if a datagrid could be created "blank", without any databinding, to be real-time populated? Or if there's a better solution? Thanks! ;)

Empty/blank group at top of matrix table

I'm having trouble creating a report with matrix tables.  I've got all the data showing up properly, but the first line in the preview is always blank.  If I subtotal the groupings, I get a blank Total line as well.  How can I stop this from happening? I'm using SQL 2005, report designer.  Data is coming from a stored procedure.  I've executed the sp in management studio as well as in the data tab of the report and it comes back with the correct data (no completely blank/null lines).  I'm new to SSRS and I've tried googling for a solution, but haven't found anything similar.  Below is the sp and the output data. SP: SELECT s.Status_Name + ' (' + CAST(CAST(s.Status_Weight*100 AS int) AS varchar(50)) + '%)' AS Status, s.Status_Order, CASE WHEN co.Company_Name IS NULL THEN '' ELSE co.Company_Name END AS Company_Name, co.Est_Income FROM tblStatus AS s LEFT OUTER JOIN tblCompany AS co ON (co.Status_ID = s.Status_ID AND co.New_Upsell = @NewUpsell) GROUP BY co.Company_Name, s.Status_Order, s.Status_Name, s.Status_Weight, co.Est_Income ORDER BY s.Status_Order, co.Company_Name Output (mgmt studio): Still Connecting (0%),1,Company1,400000.00 Still Connecting (0%),1,Company2,3000000.00 Clear Future (0%),2,Company3,250000.00 Clear Future (0%),2,Company4,250000.00 Appointment (10%),3,,NULL Proposal (40%),5,,NUL

How to Control each cells width and height of a Table ?

Hi, I want to fix the size of each cells of a table . for that i used Style like this: <td style="width:10px;height:10px"> contents </td> But it seems that there is no any effect of applying these settings.How can  i set its width and height. It seems that it purely depends on the contents of cells. Now, if suppose there are two rows, <tr id='r1'> <td id='d1'> content of size 10px </td> <td id='d2'> content of size 10px </td> </tr> <tr id='r2'> <td id='d3'> Content of size 400px </td> <td id='d4'> content of size 20px </td> </tr>   Then cell of id 'd1' will get a size of 400px ,since its just below cell is of size 400px. I want to fix its size. Is that possible ?  

Is there a way to set default style properties for a table or matrix?


We have a company standard we use for fonts, color, background, borders. 

Is there a way to set the default font to say 8 pt (vs 10 pt) so that I do not have to change every textbox and column header when adding columns to a table?



Matrix Report need to look as Table Report


Hi All,

I have a matrix report with 13 columns and 12 row groups are created in SSRS 2008. My problem here is because of the grouping the value is shown only once for a set where as I want to view the value of the grouping column to be repeated for every individual record. Can any one help with this.

Thanks for helping


SSRS 2008 - Fixed headers while scrolling - works fine for Matrix - but not for Table??!!


I have this feature working fine for matrix, but it does not work as expected for Table (Tablix).

I tried all over, and setting both check boxes in the 'Tablix Properties' dialog page 'Repeat header rows on each page' and 'Header should remain visible while scrolling' for both row header and column header, but none of it is working. Am I missing something?

In the properties table (F4) for text box of tablix, under 'Other' there is 'RepeatWith' - none / tablix: what is this used for? I tried this property also but I cannot get the headers fixed / visible while scrolling. I cannot get the 'column headers' repeat on each page of the report. Very frustrating...

Does anyone face similar issue? Can anyone help please? Do I need any update / download any fix? For now I have the following version installed for Visual Studio 2k8:
Microsoft SQL Server Reporting Services Designers Version 10.0.1600.22


matrix or table


How can I achieve the following desing of report ? I got all data but my problem is how to present it ? income, premium and fee are measuares

Country                Measures        July            August           September ....



                           income           $                   $                   $ 

                           premium         $          &n

Vertical align table cells via SharePoint UI



Is there anyway to vertical align table cells via the sharepoint 2010 WSIWYG editor? From what I can tell, you have to go into the html to do this, but you can't really tell end users to do this, especially for something that's quite a common request. Is there a way that i'm unaware of?

btw the main place where we need this ability is while using the PublishingWebControls RichHtmlField control.


Add link to another report within a Matrix Table


I have created a matrix table... and want to add a link to report base on the row field

how do i do this?

Each Row will have should nativigate to different reports based on which row the user will select.

So For example, the matrix table layout is like this....


                       Apr          May           Jun          Jul

Navigation to another report via a Matrix Table

I have created a matrix table... and want to add a link to various report base on the row. field.. .how do i do this?

please help on table to matrix/chart

i have a table with 2 columns

create table t1

(x varchar(1)
, y varchar(1)


the values are

(L, a)

(M, a)

(N, a)

(M, b)
(N, b)

(L, c)
(N, c)

(M, d)
(L, d)

what is a tsql to create a matrix/chart as the following based on it? (pls use fix font/notepad to have characters align)
  a          b     c    d
a          M,N    L,N   L,M
b M,N
c L,N                   L
d M,L             L

-- IBM has jobs for USA employee to work oversea (India) and get their wages.

How to add cells to html table from dataset


I'm trying to code an html table dynamically, adding the data from a dataset - -

(by the way, the output is on a mobile device)

I keep getting an error:
Multiple controls with the same ID 'tcell0' were found. FindControl requires that controls have unique IDs.

Here's the code (including what I've tried - commented out):

  Dim i As Integer

  ' For Each dc In ds.Tables(0).Columns

  For i = 0 To ds.Tables(0).Columns.Count - 1

  Dim tcell As New HtmlTableCell

  tcell.ID = "tcell" & i.ToString

  tcell.InnerText = dr(i).ToString() & "-" & tcell.ID  

  'tcell.ID = "tcell" & i.ToString


  'i += 1



if I don't add the cell.id, all the text gets added to t

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Edit GridView Individual Cells in ASP.NET

The ASP.NET GridView allows for a row of data to be edited by setting the EditIndex property of the GridView, placing the entire row in edit mode.

You may not want the entire row in edit mode if you are using DropDownList controls for several columns in the EditItemTemplate. If each DropDownList has many options then loading them all at once may result in a sluggish page. Also, if your data structure is more like a 2 dimensional array rather than a set of rows, you may want to edit each cell individually.

Here I will demonstrate how to achieve this and also how to deal with event validation without disabling it.

Insert value using Table Value Functions

a real gem in Sql Server 2008. mostly people still using Stored procedure may be they shifted to SQL Server but they are not using TVF right now.

Using jQuery to Filter Table Rows

The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:
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