Data Region/Matrix Control Wrapping Around

Hello All,

In my report, I have a Matrix control placed next to a table. It renders properly and displays data aligned in two controls in Visual Studio Preview. However, when I deploy to production, it wraps the matrix control below the table, in fact puts the entire matrix control underneath the table. Why such strange behavior and not in the Preview of the report but only in Production? Any ideas how to fix this?

In VS Env. Preview --> [Table][Matrix]

In Report Svr Prod --> [Table]

[Matrix]

Thanks,

Try making a 2 column, 1 row table with the table and matrix in the left and right cells, respectively.
Set the datasource of the table to be one of your already used datasets.|||

Do you mean in the Details or Header/Footer of the table? If I put in the details it returns with following errors dialog

Microsoft Report Designer

Cannot place a Table/Matrix at this location in the table

|||I didn't specify. I know I've received that error and have tried to place the piece in the header instead. I believe that works fine - but there's one way to find out.|||Well, I tried that but it din't work. The thing is that the table and matrix have different data sets. And the containing table can only have one data set name, that is why the report designer is complaining... May be I am missing something but it really sucks that the control renders one way in development and differently in production.|||

In my experience, Matrix reports almost always do not render properly on deployment. I do not know of any one method to fix such alignment issues, but in general try making sure that the components do not overlap even slightly with each other.

Also, try putting both inside a single rectangle, if they are not already in one.

Hope this helps,

-Aayush

|||

Yes, that worked. I use three rectangles though. One for table. Second for Matrix. The third one is the container. So, its sort of like the table header solution as suggested above by TU5 but without a table. The problem indeed was the overlapping report items --> "SSRS does not support overlapping report items in all rendering formats".

Thanks.

Data Region/Matrix Control Wrapping Around

Hello All,

In my report, I have a Matrix control placed next to a table. It renders properly and displays data aligned in two controls in Visual Studio Preview. However, when I deploy to production, it wraps the matrix control below the table, in fact puts the entire matrix control underneath the table. Why such strange behavior and not in the Preview of the report but only in Production? Any ideas how to fix this?

In VS Env. Preview --> [Table][Matrix]

In Report Svr Prod --> [Table]

[Matrix]

Thanks,

Try making a 2 column, 1 row table with the table and matrix in the left and right cells, respectively.
Set the datasource of the table to be one of your already used datasets.|||

Do you mean in the Details or Header/Footer of the table? If I put in the details it returns with following errors dialog

Microsoft Report Designer

Cannot place a Table/Matrix at this location in the table

|||I didn't specify. I know I've received that error and have tried to place the piece in the header instead. I believe that works fine - but there's one way to find out.|||Well, I tried that but it din't work. The thing is that the table and matrix have different data sets. And the containing table can only have one data set name, that is why the report designer is complaining... May be I am missing something but it really sucks that the control renders one way in development and differently in production.|||

In my experience, Matrix reports almost always do not render properly on deployment. I do not know of any one method to fix such alignment issues, but in general try making sure that the components do not overlap even slightly with each other.

Also, try putting both inside a single rectangle, if they are not already in one.

Hope this helps,

-Aayush

|||

Yes, that worked. I use three rectangles though. One for table. Second for Matrix. The third one is the container. So, its sort of like the table header solution as suggested above by TU5 but without a table. The problem indeed was the overlapping report items --> "SSRS does not support overlapping report items in all rendering formats".

Thanks.

Data Layout in Matrix

Repost from an earlier question. I am trying to use a matrix to display records in three columns per row, like this:
Record1 Record2 Record3
Model Model Model
Descript Descript Descript
Price Price Price
Unable to get the dynamic columns expanding to the right, or set the # of columns.
Below is the conversation so far...
Any help would be greatly appreciated!
---
Thank you for the response Chris. I've been out and unable to test this until today. I set it up as you suggested - I have a matrix with two three static rows and a column group on =RowNumber(Nothing).
I get the following error message:
"A group expression for the grouping â'matrix1_ColumnGroup1â' uses the RowNumber function with a scope parameter that is not valid. When used in a group expression, the value of the scope parameter of RowNumber must equal the name of the group directly containing the current group."
Using the List group name as the RowNumber parameter throws more errors.
What am I missing?
Michael
"Chris Hays [MSFT]" wrote:
> You'll need to use a matrix to get a horizontially growing layout.
> It should have one dynamic column grouping (group on =RowNumber(Nothing))
> and three static rows (right-click in the data area and select "Add Row"
> twice).
> To limit this to three columns per matrix, put the matrix in a list and
> group on something like this: =Ceiling(RowNumber(Nothing)/3)
>
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "OTB6" <OTB6@.discussions.microsoft.com> wrote in message
> news:7EC2C1E0-98C2-4069-B951-D40123C37ABF@.microsoft.com...
> > Trying to find a way to display returned records in (n) rows of 3 columns
> or less like this:
> >
> > Record 1 Record 2 Record 3
> > col 1 col 1 col 1
> > col 2 col 2 col 2
> > col 3 col 3 col 3
> >
> > Record 4 Record 5
> > col 1 col 1
> > col 2 col 2
> > col 3 col 3
> >
> > Can someone point me in the right direction as far as the tools
> (table/matrix/list)?
> >
> > Thanks!
> >
> > Michael<-- okay really feeling like an idiot now, but...
where/how is this attachment retrieved? if sent to the email listed in my profile, I'm not receiving it. I'd REALLY like to see your solution.
m
"Chris Hays [MSFT]" wrote:
> Using the list group name should have worked.
> I'm attaching a working example so you can compare to what you've done to
> find where they differ.
>|||You really should use a real newsreader (like Outlook Express) so you can
receive and post attachments.
(Most web-based newsreaders fail to implement support for attachments.)
I'll be posting this example to my weblog later today so you'll be able to
get it there if you can't use a real newsreader for some reason:
http://blogs.msdn.com/chrishays
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"OTB6" <OTB6@.discussions.microsoft.com> wrote in message
news:8994534E-8F27-4102-832A-071AEC7D1978@.microsoft.com...
> <-- okay really feeling like an idiot now, but...
> where/how is this attachment retrieved? if sent to the email listed in my
profile, I'm not receiving it. I'd REALLY like to see your solution.
> m
> "Chris Hays [MSFT]" wrote:
> > Using the list group name should have worked.
> > I'm attaching a working example so you can compare to what you've done
to
> > find where they differ.
> >
>

Data Grouping

hi,

I want to group data in matrix column. Lets say i have a field say Weekday which has weekdays from monday to friday. then suppose i have measure "my expenditure".

I will place Weekdays in column field of matrix and "my expenditure" in data field". lets not worry about rows.

Now i want something like this.

Group my expenditure in three categories like

1. My expenditure on monday

2. My expenditure on tuesday

3. My expenditure on days other than monday and tuesday.(means it should show me data for wednesday,thursday,friday and also if no weekday is entered)

what I am doing now is i m writting IIF expression in the column field but with that i get data for monday and tuesday but data for all the other days is not getting clubbed.

how can i do this?

Thanks

rohit

Is my problem not clear?

Please anybody help!!

Thanks & regards

|||

Instead of using a matrix table top create your report, you could use a query to pivot your data.

(SUM(CASE WHEN DAY = 'MONDAY' THEN EXPENDITURE ELSE 0 END)) AS [MON EXP],

(SUM(CASE WHEN DAY = 'TUESDAY' THEN EXPENDITURE ELSE 0 END)) AS [TUES EXP],

(SUM(CASE WHEN (DAY <> 'MONDAY' AND DAY <>'TUESDAY') THEN EXPENDITURE ELSE 0 END)) AS [ROW EXP]

FROM EXPENDITURE_TABLE

Then insert the fields from the datasource into a std table component in a report.