IngridEM on Mon, 07 Jan 2013 09:13:47
I've have a bit of a special issue with report builder, I need to make two tablix act as one, meaning that they both have the same amount of rows, and for example row number one in tablix one should be the same height as row number one in tablix two.
The result should be that no matter which one has the most text, the other one should reflect that so that they look as they are just two columns in the same tablix, adjusting to each other.
I have also tried to make vb code to compare the length of text in each field and adjust accodingly.
Is there anyone else that have had a similar issue with this? Any other ideas?
By the way, we are using SharePoint Lists, and Report Builder 3.0
Arun Gangumalla on Mon, 07 Jan 2013 13:48:56
AS per the details all you need is a design with 2 tablix controls similar in each and every cell, please correct me if am wrong in understanding.
if it is the case, then try designing the first tablix(A) with all fields etc in place and then copy this tablix and paste on the report body with which you'll be able to get another tablix control(B) with same length,cell size etc similar to the first table.
then include the second tablix(B) just beside the first tablix(A).
Hope this will help you in getting required design. Let me know if any issues while creating, thank you...
krootz on Mon, 07 Jan 2013 17:16:19
With the assumption that both tablix will have the same number of rows everytime, make your row height in tablix 1 the same as in tablix 2 and set all the column textbox properties for both Tablix1 and Tablix 2 Cangrow=False and the row height you set will not change.
Charlie Liao on Tue, 08 Jan 2013 03:08:01
From you description, you need to make two tablix act as one, if in this case, why not display the data just in one matrix. If the data from the same dataset, we can just display them in one matrix, if the data from different dataset we can use LOOKUP function to display them in one matrix.
SQL Server Reporting Services 2008 R2 came up with Lookup Functions which plays a very handy role in getting the things done in a very simple way. As their name suggests, they are just lookups helping us to retrieve values from a dataset that has name/value
pairs and that is not bound to the data region. However, requirement to use lookup function is there has a similar field between the two datasets. In you scenario, the two datasets has no relationship between each other, so I am afraid your requirement cannot
be achieved in Reporting Services currently. For more information about lookup function, please see:
Hope this helps.
SueNeilson on Thu, 25 Apr 2013 09:51:52
Can you help me with this scenario? I have used the lookup function in a simple table, but I can't see how to get it to work in a matrix, where the lookup is on both row and column data. We are reporting against a service desk system and reporting stats primarily against calls that have been resolved across a 3 month period. But we want to include the number of calls opened in those same periods, by class. The matrix currently works fine with rows of class and columns of resolve month, but when I try to lookup against the summary of calls opened by class and month, I get #Error. I can't see how to do this. Tried to concatenate the class+resolve month, to compare with the lookup dataset values of class + log month but the expression does not recognise the second field in the 'destination expression' that I am trying to concatenate. There must be something I am missing .....