.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

How to limited group number in matrix

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
Hi,  I was wondering how to limited group number in matrix? Because in some case the number of the dataColumn will be very large. So I just wanna to display the top 10 group. I've try the RowNumber(Nothing) mod 10 in group expression, but has no effect. Could you tell me how to do this.  Thank you very much indeed.  

View Complete Post

More Related Resource Links

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

The number of connections to this computer is limited

I am currently getting an error saying ' The number of connevtions to this computer is limited and all the connections are in use.'. When I first looked this error up it says it comes with SQL server default allowing no connections. I d/l'd SQL but never really used it, maybe just opened it a couple of times but that was it. I just uninstalled all SQL applications on my computer. I have restarted and no traces that I can find left from SQL, however I am still getting the same error. Maybe uninstalling SQL didn't change this setting back to the original, or maybe something else is going on. I was hoping to get some help/advice. Please let me know what you would suggest I do. My understanding if you d/l use SQl server the default connections is zero. Windows Vista may allow 5 SQL server default is zero. So if you d/l SQL you would have to change the default connections to something else. I never did that after opening SQL server and some of its other tools. Today I uninstalled SQL after getting this error hoping the default value would change back to Vistas connection default. It did not change so, I am still getting this error.   http://support.microsoft.com/kb/320728 But I no longer have SQL

SSRS 2008 R2 Conditionally Hide Matrix Group


With SSRS 2005 we were able to conditionally hide and show row matrix groups in a report.  Now that we have upgraded to SQL 2008 R2 when we set a child row group Hidden property to true conditionally or manually no rows appear on the report.  Has anyone seen this before and is there a work around or a hot fix for this. 

Any insight will be greatly appreciated. 


How to get the permissions of a user or group that has "Limited Access" to a site



For a user or group that has "Limited Access" to a site, I'd like to be able to find all of the libraries, documents, etc that that user or group has been given permissions to.  I believe that I could accomplish this by iterating over all of the lists of the site, and then over all of the list items of each list, and checking if, for that list or list item, inheritance is broken and that user or group has been granted access.  However, I am hoping there is a cleaner, quicker alternative in which I don't have to iterate over all of the site content.

If that's not possible, I may be able to accomplish mostly what I need if I could find all of the site content which has unique permissions (and then simply iterate over that content to see if the user or group has been given permissions).

Any advice is greatly appreciated.




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

count number of columns in group



I need to count number of columns in group -

I have a matrix with SUM in the date area.

I have a group column (lats say 'city') and under it my columns (lats say 'street name');

Under each 'street name' I have cell with SUM function.

The problem is:

When The main group (city) is not expand I get the sum of all cities and what I want to get is an average .

So what I thought of was to divide that number in the number of streets under each city group.

How can I get that number?


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?

SQL and Merge replication -> Number of records limited to 100000?


Hi all,

I´ve a publication in a server with SQL 2008 Enterprise.

I´ve a  client with SQL 2008 Express. Here i´ve a clean database.

There's a table in the server with 569856 records and it´s included in a publication with no filters.

I create a Merge subscription, but when it finished the client table has only 100000 records.

Is there a limit in SQL 2008  Express?


Jon M.

Matrix Row Group or Columns Group layout problem


I am trying to creating a Matrix that displays Appointments sorted by Time  (expample below)

11/22/2010  7:3O AM







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

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:

Group Calendars in SharePoint 2010

One of the many requests I had in SharePoint 2007 was the ability to place SharePoint Calendars on top of each other like you can in Outlook 2007 saving you having to look at each and work out when the best time is for a meeting.

Convert English to Arabic number without changing any regional settings in .net

Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

dynamically adding sql server columns based on number of files in fileuploader


I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.


I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!


Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")


ListViewControl - how to group items by their value, for eg. date range



I have a table containing courses, columns are 

Name - "Yoga Classes"

DateStart - "2/23/2010"

DateEnd - "2/24/2010"

I am using ListView Control to bind it, is there a way to display them and group them by Month? 

for eg.


Piano Class (10th Jan 2010 - 11th Jan 2010)
Guitar Class (10th Jan 2010 - 11th Jan 2010)


Yoga Class (15th Feb 2010 - 16th Feb 2010)

Thanks for help.

Embeb a variable number of videos


I need to provide some alternate content for my non-Flash users.

I have a directory of video files that is scanned using the DirectoryInfo() function, and I want to use the results to embed all files ending in ".mov" in QuickTime players on a web form.

How would you approach this? Right now I am using the count on the array of videos to determine how many times to repeat the embed code.  But this seems inelegant.

Is there a way to have a single QuickTime player.ascx control that gets duplicated according to the number of videos available for display?

Article commenting by line number


I'm wondering what's the best way to approach an online article system that allows users to comment by clicking on the line they are commenting about? Essentially the same way Adobe Acrobat works with comments where you can click anywhere and the text is saved for that location.

I'm assuming a mix of jQuery would be the crux of the interface. The system would need to save comments so that when another user logs in, they will also see the other comments but they can´t edit them - only add their own.

Any suggestions would be great.

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