.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

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

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server

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?



View Complete Post

More Related Resource Links

DataGrid: Tailor Your DataGrid Apps Using Table Style and Custom Column Style Objects


One of the most enduring challenges in writing user interfaces is figuring out how to display large amounts of data efficiently and intuitively without bewildering the user. The problem becomes particularly thorny when the interface must reflect hierarchical relationships within the data that the user needs to modify. The Windows Forms DataGrid control gives developers a powerful and flexible tool to meet this challenge. This article explains its basic operations and shows how to extend the DataGrid to display columns of data in an application-appropriate manner.

Kristy Saunders

MSDN Magazine August 2003

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

Personal view reverts back to default after updating properties of item


I am working with a company that has 1 site collection with several sub sites.  I have built 3 document libraries with workflow in 3 different sub sites and all behave as expected.  I have one site where ALL libraries do something perplexing;

If you are in a custom personal view and you go into the properties of a document and then exit (update or not, does not matter) it reverts back to the default view of that library. 

Has anyone seen this?  is there an option when creating an album that could cause this?

thanks in advance for any input on this odd issue.

Is it possible to change the title bar background and the font style on default template?



Is there any way to change the default top link /title bar picture and the fonts of the title without breaking anything in the layout/structure?

I have changed the theme to Obsedian and I would also like to change the picture of the title bar of this theme and also the font/style of the title, top link bar, menus..etc. Is there a way to do this?

Please note: I am using WSS 3.0 and I am not the Administrator of the sharepoint. I am only the site admin of some sites on this sharepoint. I can do some basic customization using SPD.

Basically, what I am trying to do is that I want to set up a sharepoint site, however I want to make it NOT look like a sharepoint site.Well I know this is possible, but for my case it might be just partially possible due to the limitation that I am not the Site collection admin and hence I do not have direct access to the server itself.

What I want is to hide most of the sharepoint links/menus/bars, etc and use my own buttons/hyperlinks etc .. for user to navigate on the sites.

Thanks in advance for your help/advices.



In a style template, express a property in terms of the controls properties it is applied to.

Hello,   In the style template below, which works fine, I'd like to express the "Points" property in terms of the applied to controls "Width" and "Height" properties.  As you see, the "Fill" property is expressed in terms of the "Background" property the template is applied to by means of Fill="{TemplateBinding Background}".  The following does not work:   Points="0,({TemplateBinding Height} / 4)  ({TemplateBinding Width} / 12.5),({TemplateBinding Height} / 4) . . ."   Is what I'm looking for possible, all in XAML, no code/converters? <Style x:Key="FolderButton" TargetType="Button"> <Setter Property="Margin" Value="2.5" /> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="{x:Type Button}"> <Grid> <Polygon Fill="{TemplateBinding Background}" Stroke="{TemplateBinding BorderBrush}" Points="0,5 4,5 6,0 23,0 25,5 50,5 50,20 0,20"/> <ContentPresenter HorizontalAlignment="Center" VerticalAlignment="Center"/> </Grid> </ControlTemplate>

Instance and Default connection properties on SQL Server 2005

We had a sql server fail and I have been having troubles.  I compared the connection properties on the server properties and noticed that multiple default settings are no longer set.  So I'm wondering if during the failure these could have some gotten flipped.  DB's that worked all of a sudden don't work and we had to migrate to a different instance.  I have never changed any of the setings below and wonder what impact they would have if I changed them back to the default of an installed instance? ansi warning is checked ansi padding is checked ANSI NULLS is checked arithmetic abort is checked quoted identified is checked No Count is checked concat null yields null is checked Could anyone tell me how clearing these checked options will impact my db?   -- Paul Bergson MVP - Directory Services MCITP: Enterprise Administrator MCTS, MCT, MCSE, MCSA, Security+, BS CSci 2008, Vista, 2003, 2000 (Early Achiever), NT4 http://www.pbbergs.com    Twitter @pbbergs Please no e-mails, any questions should be posted in the NewsGroup This posting is provided "AS IS" with no warranties, and confers no rights.

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! ;)

Properties.Settings.Default.Save() folder

How can I determine or change the location that Properties.Settings.Default.Save() will save my user.config file.  Everything I have seen says it will be stored in a folder based on my application name but in my instance it's including my companies name as well and I cant figure out where it is getting that info from.  I would like to store all my local data in the same place so I want to know where the data will be stored so I can save other stuff there as well.  For example; I have a winform project named XYZApp which generates XYZApp.exe.AssemblyInfo.cs contains the following:[assembly: AssemblyTitle("XYZApp")] [assembly: AssemblyCompany("Software Company International, Inc.")] [assembly: AssemblyProduct("XYZApp")] From what I Read online my user.config should be stored in C:\Documents and Settings\<USER>\Local Settings\Application Data\XYZApp\ However mine appears to be stored in C:\Documents and Settings\<USER>\Local Settings\Application Data\Software_Company_XYZ\ So somehow its picking up the company and only part of the actual application name.  I'd like to have a way to know what the folder is going to be called so i can keep all the data in the same place. Is there a property i can check to determine this?

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

Getting counts by 2nd Date Dimension Attribute with Snapshot Style Fact Table

  I have an MDX question finding hard to solve.  I have a Snapshot Fact Table with a snapshot of the records in the source system for each batch date.  All records in the fact table are assigned the batch date with the batch date key.  There are many records for each day and each batch date is an entire copy of the source records.  So, the grain of the fact table is one record for each batch date that exists in the source system.  These facts rows have another date in them for when the record was entered.  This date is different from the batch date in that the batch date is based on the day the batch was processed and the entered date is based on when the record was entered.  If a record was entered many days before, its batch date will be today but its entered date will be several days ago.  Therefore each day a copy of all the records entered the previous batch date and all the records added on today's batch date are present. Fact Table : FactSnaphshotKey (surrogate for easier administration) BatchDateKey (link to batch date dimension – date dimension, first in dimension list so it is used for semi aggregate measures) EnteredDateKey (link to entered date dimension – date dimension) Facts Count – measure for fact table - default measure from Analysis Services cube 2 Dim

Searching for custom properties in a default search

Hi all, I have added some custom properties in to Manage User Properties in my User Profile Service Application. The issue I'm having is that I'm unable to obtain search results from these properties. For example, if in the Enterprise Search / People tab I enter "Dave" and click search, then I'll be presented with results of people who's name matches "Dave". If I enter "Information Technology" then I'll get a list of all users who's department is "Information Technology". So far we're okay! But let's go back to the custom property. Let's say it's called "Clients" and it is for storing client names against the staff profiles. If I search for "Microsoft" and a user has Microsoft in their client property then no results are found. I've created the managed properties in the Metadata Property Mappings of my search service application, done full crawls but nothing. If I search for "clients:microsoft" then I get results. So the question is how do I or is it even possible to get custom metadata properties to show up in a default search? Thanks!

modify/override properties of default sharepoint modal dialogs (ex. editview.aspx) using javascript

Hello all, I would like to know how can I modify (override) some properties of the default sharepoint modal dialogs using Javascript. Ex. the size and location of editview.aspx. I while ago I asked a question about overriding the DialogResult in the display view dialog. I got an answer from Zach which looked like this:             sb.Append("<script type=\"text/javascript\">");             sb.Append(@"window.setTimeout(function () {");             sb.Append(@"if (window.frameElement && typeof(window.frameElement.overrideDialogResult) == 'function')");             sb.Append(@"{");             sb.Append(@"SP.SOD.executeFunc('sp.ui.dialog.js', 'SP.UI.DialogResult.OK', function () {");             sb.Append(@"window.frameElement.overrideDialogResult(SP.UI.DialogResult.OK); ");             sb.Append(@"});");             sb.Append(@"}");  

how to display matrix report with default zero when we are not having data related to it in database

Hi, I am having a matrix report in SSRS 2005 which is parameterized.When I select parameter which is having related data in the database report is working well.But When I select a parameter for which data is not present in database at that particular time.I donot see the matrix on report .So can any one suggest me how to show the matrix report with zeros in data region when user select that parameter   Thanks in advance.

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


default style for control

Hi all , I have a problem when I use button in some code base , I found some guys already defined lots of style for the button and buttonbase , but I want to use the default style in WPF , can I prevent the button inherit the style from custom , only use the WPF ?

how to restore view style to default... urgent


dear friends,

I have changed default font size of '.ts-syslabl' in view style of "Boxed" for a page. But it is reflecting in all view styles. May be i corrupted main css core file or vwstyles file with respect to that site collection. How to restore to default file with respect to css. Kindly help me out . It is urgent ...please.. It is the problem with only one site collection in which i tried.

I used Sharepoint designer 2010 .

pleasehelp me out

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