.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

SSRS how to expand table horizontally in SSRS

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
I am trying to make a report in SSRS. My requirement is to expend table dynamically instead of vertically..is this possbile in ssrs.

View Complete Post

More Related Resource Links

SSRS Table hide duplicate by date

Hi, I am parikshit deshpande i am working in SSRS 2005 from last three months. I am trying to solve this problem please help me for that, I have one table as per  Date                     Shift                               Tons                       Passes 1/1/2009            Day                                    Formula                  Formula 1/1/2009           Swings                            1/2/2009           Day 1/2/2009     &nb

PIvot Table in SSRS 2008

Hi All, Is there any data Region (Pivot) in SSRS 2008 or higher version? Our requirement is to show the report like excel pivot gererated from a OLAP Cube where we can select or unselect any dimesion attribute or measures. Thanks, IndiaSQl  

SSRS Table Header working differently in and out of print layout

Please help. This is bizarre and seems like a bug to me. Using a table in SSRS, I have a details row, with a parent group and finally a header row.  For my header row, I am referencing a particular cell in the parent group. I am doing this so that i can have the header row repeat on each page of the group. This works fine when I'm not in Print Layout mode. However, when i switch to print layout mode, or print the report itself, the data that is presented on the screen is different then what is presented when not in print layout mode. WHAT THE F*!@!?? I've been battling this for a while now and i'm at my wits end. Has anyone else experienced different results from when you are in print layout mode as opposed to being in print layout mode?

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


Trouble Using More Than One LIKE Operator in a Table Filter in SSRS 2008


Hello All,

I'm having what I'm hoping will be a simple issue -

My co-worker has created a large report which contains several tables in SSRS 2008.  Each table is tied to one dataset, yet only certain data can be returned to each respective table.  Right now he's applying filters at the table-level behind each table, however as you can imagine this is not efficient because there is a LOT of data returning for this report. 

I'll try and give a simplified example -

There are two tables in the report body - one for containing products relating to both Cats and Dogs, and one for containing products relating to Birds.   Each product starts with the name of the specific animal - for example "Cats-Mouse Toy", "Dogs-Frisbee", "Birds-Rubber_Leaf".  

Now I need to somehow filter out each product so that they go to their proper tables.  As mentioned above, my co-worker was creating a specific filter for each product, but this is proving to be inefficient.  For example, there are 52 different products for Birds alone.  That would mean 52 different filter entries for each product.  What I would like to do is use the LIKE operator but i'm not getting the results I want on the first table.

So, on the first table I need something like:  =(Fields!Products.value LIKE &

SSRS 2008 - Drilldown - Grouping collapse/expand /title/header



I have been able to have a report with Group / Group count and Details.

The issue I have are:

1. When I collapse the drilldown to get only the Group and Group countit just collapse per page not the full report...I would like to have all Group / Group count on 1 or two pages and then epand as needed...

2. The title and column headers appear only on the first page... how to get it on all pages?

What is the "Linked Report" doing? Is it another kind of Drill Down..?

I need to have my summary report per OS for example shows only the OS Name then Count and if I click to expand I will have the servers in this group... but it seems working reverse way, I mean you have the details and if you collaspe you have the summary but this seems limited per page...



System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support

Embedded HTML using
to replace tags in ssrs 2008   

After doing various amounts of research and testing I need to post a question here. 

I am using an html editor to format html and data (for reports) and then using reporting services to render the html harnessing the report server to view, export, and print. 

As already many of you know around here you can set an ssrs table cell to “HTML – Interpret HTML tags as styles”.  Also many of you know that this functionality does not accept <table><tr><td></td></tr></table> tags.  However, the documentation says it support <div> tags. Yet when I try using div tags with the appropriate styles for creating tables this does not work either.  So if ssrs handles <div> tags could you please tell me a complete list of style attributes it handles as well?

SSRS 2008 how to define a custom legend and display colors of legend in table


How would i go about setting the background color in a table to a legend series color in a chart control?



Table Header (Title) Row need to repeat on each page. How to do this in SSRS 2008 & above?



I have a requirement, where 1st row (Hearder) should repeat on each page.

For Example:



Experience in Years




So I want to repeat


Can I set a table to display 20 rows and then scroll instead of expanding down the page? (SSRS 2005


Can I set a table to display 20 rows and then scroll instead of expanding down several page? (SSRS 2005 )

How to GET the Height of a Table programmatically in SSRS 2005?


Im fairly new to SSRS and all attempts to align my table at the Bottom of the page has failed. (similiar to a footer)

I cannot use a footer to do this because the footer allocates space on every page even tho i require the data on the last page only.

I have tried the solutions given to me on the following link: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/08785944-923e-445a-b7de-b1062ea97879/

Unfortunately i cannot seem to GET the Height of the preceeding content (which is in a table).

Any help will be much appreciated!


ssrs - expand image not visible when viewed in IE



I have created a tabular report in SSRS. The report drills down to monthly level when toggle image (+) is clicked. When this report is viewed in Firefox, it gets expanded & collapsed and the proper toggle image is displayed. The same report when viewed in IE doesn't expands and hence the toggle image remains as is (just the page is refreshed).

Note: A dashboard is created in sharepoint 2010 and deployed. 

Please help.



Edit Table in SSRS 2008


Hi Experts,

We were having table with just ONE DATA COLUMN ( it means no Header and nor Footer), and we were having two row groups on this table.

Now our user's request to some "Total" at the bottom, and I'm trying to edit the table were I can add Table Footer but I'm unable to do the same, Can anybody out to do?

Even I tried by "Insert Row" -> Outside Group - Below but it is still inserting as a "Group level footer" rather I want as a Table level footer.

Long question short, how to edit table to add Table Header or Footer.



Table rendering Bug: Setting Background color for SSRS report (RDLC)



I am facing the issue while trying to create a Report Definition Language Client-side (RDLC) report. I want to set background color to the textbox (used in table) depending on the value. I have used conditional formatting to achieve this. But i am facing issue in setting background color for Some of  the fields like

  1. EnduranceYoYo
  2. Endurance5MinRun

The General Format of the Conditional format is

=iif(<Varchar Field>.value="NA",Gray.iif(<Integer Field> < 600,"Red",iif(<Integer Field> >=800,"Green","Gold")))

I have used this conditional formatting in Textbox (Properties) --> Background (Expressions)

 I have tried the following options to rectify the issue

Option 1 :

This is the format i have used in Conditional formatting in Expression (In Textbox properties -- background -- Expressio

Can I have 3 different tables in a report? And, can I pass 3 temp table to SSRS as source for these

I'm using BI 2008 and sql 2005 and 2008.  Is there an example to show me?  Thanks.

SSRS 2005 Dynamic Table Generation



I am attempting to build a report that allows the user to select the value of 4 different parameters. The final parameter allows the user to select multiple values. My question is as follows. Based on the users selections, is there a way to generate the required number of tables dynamically?

For instance, if the input for the final parameter is A, B, & C can the appriopriate number of tables be generated for the same dataset (Sales) without having to build a table for SalesA, SalesB, and SalesC? Or do I have to build the maximum number of tables and use an expression to determine visibility based on the parameters. Note: max number of possible tables is more than 100.





SSRS Reporting with Sub Report or Master-Child Table.


I have a list called "Product" which contains list of products with category. The product is available in More then one category. The product category is available in list called "Category".

Following table explain how the data is strored in the "Product" List. 

Product ID   Name   Category 
P1  Product1  Cat1
P2  Product2 Cat2
P3  Product3 Cat3
P4  Product4 Cat1, Cat3
P5  Product5 Cat2, Cat3
P6  Product6 Cat4
P7  Product7 Cat1,Cat4

Now i want the data to displayed SSRS report in following way. So kindly provide valueable inputs to achive same. 

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