June 30, 2010 at 2:59 am
I am struggling with reporting services and some limitations I have found
1. Toggling on column headers in impossible
2. In an expression you cannot add carriage returns
3. you cannot merge cells vertically
4. you can't add a table to a matrix and then return dataset values in that table
maybe I am wrong on some or all of these but the limitations are frustrating
June 30, 2010 at 11:26 am
Rather than a rant, you may want to post some more information on what you are trying to accomplish and how you are having trouble doing it. Also which version you're talking about.
For example... do you just want to break the code up so it's more readable for you or do you want to display a carriage return in the field you are populating? If it's the second, try concatenating a vbCRLF or a controlchars.newline character.
Why do you want to merge cells vertically? How does doing this accomplish something for you? If you're talking about in a matrix, there are options to allow for this in the row groups, or at least it looks like that when displayed ont he page. For everywhere else, how does an ever expanding (down) textbox not meet your needs? Perhaps you need to use grouping a bit better?
Not enough data to even guess at what you are talking about with 1 and 4 so I won't other than to say we're not sitting in your chair. If you need help you need to provide us what we need in order to help you. Unfortunately for SSRS many times a screenshot is worth a thousand words. What can I say I see TSQL problems in Code, and SSRS problems in pictures... just the way my mind works.
-Luke.
June 30, 2010 at 11:32 am
Also, check out the following link... I think the first result returned will show you how to toggle using the header row...
http://lmgtfy.com/?q=SSRS+Toggle+on+header+row
When you read it, it will basically tell you that you can toggle using the header rows, but the toggle item can't be something that's already hidden. Kinda makes sense you can't toggle something that's already not displayed...
June 30, 2010 at 2:13 pm
When you read it, it will basically tell you that you can toggle using the header rows, but the toggle item can't be something that's already hidden. Kinda makes sense you can't toggle something that's already not displayed...
That is correct. The toggle on/off cannot be on the column or row that is going to be toggled off or on. It has to be on the next grouping out from the row/column that will be hidden. If the toggle on/off is on the row/column that toggles then you would not be able to toggle it back on once toggled off because it would not be visible.
June 30, 2010 at 2:22 pm
Right it can be the next column out or could even be a button or image you place somewhere else on the report for a collapse/expand all type scenario. There are a number of ways to approach it, all depending on the needs for that particular report.
-Luke.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply