.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

How to merge two matrix rows in rdl reports

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :ASP.Net


Could any body help my problem. I have design two matrix  in single  .rdl  .

I want merger two matrix rows together  in output when i export excel .

Could you give any better idea .



View Complete Post

More Related Resource Links

Report Builder 2.0: duplicate rows do not show on reports

Hello,Created a report using a report model.the problem is that duplicate rows do not show on the report.Why?And also how can this be fixed?the report shows product ids, that may or may not have serial numbersticket numbers can have mulitple products associated with them and they may or may not have serial numbersthe report data row is as follows:example:order number, ticket number, product id, manufacturer id, serial number123                  456               dsl_router 12  cisco123                  456               dsl_router 12  ciscothe above data shows as one row on the report, thus, showing it to be one product, but really there are 2 products and there should be 2 rows.is this a bug?how can this be fixed?Thanks.

Dynamic rows(fields) generation in crystal reports

Hi.....frnds,     I am working on Crystal reports.My requirement is that i need to  generate dynamic fields according to the count of Family_Members column in sql server database,for example if i have '4' in 'Family_Members' column i need to generate 4(Family members details)dynamically.

how to use inscope in matrix reports

  I am having a matrix  report in ssrs 2005.It is having three  column grouping and one row grouping.                           Column group 1                          Column group2                          Column_group3 Column1   PercentageColumn2  Percentage    Total(A+B)           47 63.51% 1 1.35% 74 18 24.32% 7 9.46% 1 1.35% 0 0.00% 66   8                      A               C           B                 D                E                    &

help need in calculating %'s in matrix reports.

Hi all, I have created report. And i have a problem in writing an expression in calculating the percentages.in column B, D, F I know that we can do this using Inscope function. But iam not able to get the solution. Is there any other way, or if its only thr inscope function could someone plz help me in writing to calculate the percentage   Matrix Report SNO A B C D E F 1 count % count % TOTAL Count TOTAL % 2 3 (3 / tot count) * 100 4 (4 / tot count) * 100     3 5 (5 / tot count) * 100 3 (3 / tot count) * 100 SUM(A2,A3,A4,C2,C3,C4) SUM(D2,D3,D4,B2,B3,B4) 4 8 (8 / tot count) * 100 6 (6 / tot count) * 100     TOTAL SUM(3,5,8)   SUM(4,3,6)         Thank you, -- Suman Gupta

How to hide matrix rows based on values?


I have a matrix settled upon an MDX Query using Reporting Services 2000.
In columns i have the Months and in  the Lines and i have Products, so what i need todo is hide the rows that have a 0 value in all months.

How can this be achieved?

Best Regards,
Luis Simões

Report Builder 3.0 renders empty page for Reports with Matrix (column group) in Landscape orientatio


I need some help.


If I create a Report with a Matrix Tablix (with row Groups and column groups) in landscape layout and preview it in print layout, the report generates me some extra empty page every 2nd page.

I don't understand the rule, why it's doing that.


My Report settings are:

  • PageSize: width: 29.7 cm, height: 21 cm
  • InteractiveSize: width: 29.7cm, height: 21 cm
  • Margins : 0cm,0cm,0cm,0cm
  • Report Body : widht: 25cm, height: 10cm

According my Report settings this shouldn't happen, should it. The width of my Tablix is max 22cm.

What I noticed is, that when I shrink the width of my Report Body to 21 cm (to the width of the portrait layout) or less, the emtpy pages disappear.

Or when I delete the column group, it also renders the report without some empty pages.

I think this problem has something to do with column groups.


Is this a bug or am I missing a setting?

update conflicts occur even if rows were updated only at subscribers (Merge Replication)


Hi all, we use Merge Replication as described bellow:

Publisher: SQL Server 2005 Standard Edt with SP3 (on Win Server 2003)

Subscribers: SQL Express 2005 with SP3 (Win XP), pull subscriptions, synchronizing through .NET application (using RMO objects)

Further description: we use both download-only articles and articles with parametrized filters, Publisher acts as its own Distributor

From time to time, update conflicts occur in table where product stock status is stored for sales representatives. Error message states that the same row was updated both at subscriber and at  publisher.

Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality

In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes.

jQuery: Highlight Gridview Rows with Checkbox

Im learning and experimenting with jQuery and ASP.NET. Below is a simple solution I created to highlight rows in a gridview by clicking on a checkbox next to the row.

Gridview setup:

Highlighting Rows with TextBox OnFocus

In another article I explained that how you can make the rows of the GridView control clickable and highlight them when they are clicked. In this article I will explain that how you can highlight the GridView rows when you focus on the TextBox which is contained inside the GridView control.

jQuery: Highlight Gridview Rows with Checkbox

Im learning and experimenting with jQuery and ASP.NET. Below is a simple solution I created to highlight rows in a gridview by clicking on a checkbox next to the row.

jQuery: Styling DropDownList Alternating Items (Rows)

In the following example, I will show how you can style any asp:dropdownlist very easily.

The example demonstrates how you can change alternating row items background color, using the fadeTo() to add a nice touch in the dropdownlist. You can change alt rows with a couple lines.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

How to format and update GridView and DataGrid rows using JQuery

The behavior described in this question is as expected. When you set text of a cell in grid, it directly affects HTML that is going to be rendered. When you set text value of a cell, it means that you are setting innerText of the cell. The column that GridView creates for command fields (Edit, Delete and Select) are a (anchor) or button elements. So you can see what will happen if you set text value in that cell. It will wipe out those link or button controls and replace them with simple text string.

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:

Insert Rows with a GridView

In ASP.NET version 1.x, I used the footer on the DataGrid control to insert new rows by placing a series of TextBox, DropDownLists, CheckBoxes etc. controls on it and then handling a save button. This also works with the GridView in version 2.0 but with one major exception: if your data source is empty, the GridView will hide your footer (and header) and only display the EmptyDataText.

Problem to group radio button across gridview rows

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:
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