.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

Does the 2008 R2 Data Alignment in the columns (Domain Scope) work with multiple tablix's

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

Does the 2008 R2 Data Alignment in the columns (Domain Scope) work with multiple tablix's or only with one Tablix with different groups?


I have been trying to use it for a report that has 3 tablixs (the same dataset and same format) but it doesnt seem to work. All the examples i find are for a single tablix.

Anyone know?

View Complete Post

More Related Resource Links


the database result is as follows DATE     code   class1 class2  class3 1/8/10     M1     10       20     30     3/8/10     V2      20       30     10      1/8/10      H1      1           2      3         7/8/10     ! ! 8/8/10     !M2    5      5      5       3/8/10     B2      4      4     4       1/8/10     V1      3      7     3       THE OUTPUT SHOULD BE AS FOLLOWS:- DATE           M1                          M2           

Hiding rows/columns completely in SSRS tablix even when they have data

I have several columns and rows in my tablix.  I don't want to see all of them at once.  I am using a parameter that controls the visibility of the columns or rows of the tablix.  The issue is that it hides but the white space is left.  How do i take out that white space?

does the sql server 2008 R2 support movable columns in a tablix (in Reports)



is there a way to build a report with a tablix and let the columns movable for the users?
from another post i figured out, that this feature is not supported in sql server 2008.
is it featured in  2008 R2 or in 2010? :)

thanks Johnny


Data driven subscriptions need to use multiple "From" addresses - SSRS 2008


Is it possible to create a data driven subscription that supplies the from address based on which brand of my company is sending out the email? Or even if I'm representing a single brand, I need to use different email addresses such as customerservice or accounting or system.admin, etc. This cannot be a rare situation, what do all of you do to address this concern? Am I missing something obvious?



SQL Server 2008 R2 Data Collector for multiple servers.


Hello all,

I'm working as a intern and have been maintaining a performance monitoring application for my companies servers and wanted to know if "Performance Data Collector" could do the job for us(and that I've spent the last month working on...) I ran across an article(http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-performance-data-collector/ ) that seemed to describe this tool as pretty much what I've been working on.

Presently we do this:

1. Performance Monitor(perfmon.exe) logs all the performance counters we want and stores them locally on each server.

2. A client service(run on each server we monitor) takes the log files, zips them and periodically transfers them to the logging server.

3. Once on the logging server another service parses the files and bulk uploads them into a SQL Server 2008 R2 Database.

4. A SSAS cube on the logging server then processes all the data and we have our min/max/averages for the various counters.

Can I collect performance data from Windows 2008 servers that do not have SQL Server 2008/2008 R2 installed on them by using the server that is running the collector to pull the information? This would essentially b

Reporting Services 2008: Columns get shifted on Tablix after hiding a field.



I have a report implemented on SSRS 2005 that for the purpose of hiding the toggle sign (+/-) when there is no detail data has an expression on the Hidden property of the text box.

Now when migrating to 2008, the table has been automatically upgraded to a tablix with the undesired behavior that, when a field is hidden on a row, the remaining fields are shifted to the left to occupy the space of the hidden field.

This happens only when the report is rendered on the web. On Visual Studio it works as in 2005.

Is there a way to avoid this kind of shifting? Why will I want to render a field on a space designated to the field on the left that it may not even fit?




How to print more than 15 columns of data in SSRS 2008?



I have a report with 15 columns of data (each column is approximately 1inch~2inch), when I preview the report and click PRINT icon (which is very next to refresh icon) then save it as Microsoft xps document writer, it shows only first 5 columns of data, even data is truncated at end of each page in .xps.

I have selected A4 paper type in report properties, So please assist me how to print all 15 columns (along with header and footer) of data ? If I change the width and height in report properties then it affects rendering to PDF, DOC etc ..

Any suggestion is also welcome

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.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Dynamic Data, Domain datasource, Poco and lookups


Mr. Edward,

Excuse my question but: it is necessary to involve in our projects something more than just Dynamic Data or should we make use of all other features available in VS2010 (which will make assume taht they had been left out of the Dynamic Data framework) like: wef, poco, azure, wcf, cloud, mvc, silverllight, ajax, odata, agile, workflow, etc.?

Sorry my ignorance, I'm just transcribing names as they come to my mind and of which I don't know anything about


Carlos Porras (El Salvador)

data from multiple row



I have a dataset in my SSRS report where I am getting the data like this. It has 3 rows.

ID Parameter Value

1. Client Name-  XYZ

2. Client Email - xyz@s.com

3. Clinet Phone- 234567

I need to check condition in expression, so If parameter is Client name then It will show in client name textbox of Report. How can write expression for this.

Under The Table: Spatial Data Support In SQL Server 2008


New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009

Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008


Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.

Kent Tegels

MSDN Magazine September 2008

Filter search over multiple text columns


Hi everyone,

I'm working on a library that stores information on various cases. The case table has several columns that contain descriptive strings on what happened in the case. I would like to create a single filter that returns all cases where the search string is found in any of the columns. I've looked at Dynamic Data Filtering, but as far as I can tell, the "Contains" filter only allows you to connect to each column individually. Has anyone tried this?



Entity Data Model and database view returning the same columns as there are in a table


When adding a stored procedure into the Entity Data Model I can select whether the procedure returns a scalar, a (new) complex type or one of the entity types I already defined. 

How do I do something similar for a view?

I mean assuming I have a view like this

CREATE VIEW FilteredFoos as SELECT Foo.* FROM Foo join ... WHERE ...

(that is a view that implements some involved filtering, but returns all columns from one table) how do I add it to the project so that I can use the entity set, but get the Foo objects, not some new FilteredFoo objects.

var foos = myDB.FilteredFoos.Include("Bar").ToList();

foreach (Foo foo in foos) { ...

Thanks, Jenda

When I use 'publish', site doesn't work when i post data


Arrgghh, I am so tired of dealing with stuff like this

I've got a project, when I put up on another server I point two sites in IIS6 to it

i have

http://www.main.com  pointing to the folder the files are in


http://www.anotherofoursites.com/main pointing to that same folder in it's own "Virtual Application" or whatever IIS calls it when you put a folder into it's own 

If I just "Build" and push all the files up.. both work without issue and as expected...  but when I use "Publish" to precompile, the site works until I post, and then i get nailed with:

Server Error in '/' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
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