I have a report control in my report. But I want to expand graph depending on the selected number of months (Parameter) by users.
But there is no formula option for graph control. Is there any workaround?
You might be able to do something with padding. But that would not change the space your graph takes up in the page, you would just have more (or less) white space, depending on your current data.
>L<
sqlWould some one know how to control the formatting of Matrix Sub totals, such as Border around it, background color and font etc...I can't select the grey textbox that is rendered if sub totals are chosen from the context menu for a group.
Any help will be appreciated.
If you right-click on the green triangle in the corner of the subtotal label and click properties you should be able to access the properties of the subtotal text box (I believe it is actual labeled Subtotal by default).
Hope this helps,
Simone
|||I love this forum....Thanks!!!!!!Hi,
I'm trying to format the output of a report and can't seem to figure out how use the Matrix control to get what I want. Currently, I have it formatted as:
General Information <-- Head
Tag Number Line Size Line Schedule <-- Information
Service P&ID No. Tightness Requirements
Line No. Area Classification Location
Process Data
Fluid Specific Gravity
Transmitter Spec.
Mounting Type
NEMA Rating Power Supplied Analog Outputs
Ideally I'd like to have it formatted as:
General Information <-- Header centered
Tag Number Line Size Line Schedule
Service P&ID No. Tightness Requirements
Line No. Area Classification Location
__ <-- Divider Line between sections
Process Data
Fluid Specific Gravity
__
Transmitter Spec.
Mounting Type
NEMA Rating Power Supplied Analog Outputs
Any ideas or suggestions would be greatly appreciated. This shouldn't be THIS hard to do.
Thanks,
John.
It'll be a lot clearer to understand if you make up your examples in Excel and then just copy paste that into your post.|||Adam,
Thanks for taking an interest. Ok, here's what's going on: I'm trying to render information where I have multiple (unknown at design time) Catagories which have multiple Attributes (also unknown at design time). The relationship is One Catagory, Many Attributes.
I'm using a Matrix control because it seems to be the Control to use? If it's not, let me know. What I'd like ideally is to: Add a Line to separate the different Catagories (i.e. General Information, Process Data, etc.), and center the Catagory title. Currently I'm forcing the Matrix to wrap at 3 by setting a property in the List Control's "Edit Details Group..." property to: =Ceiling(RowNumber(Nothing)/3). If you have any ideas on how to solve this through the designer, please let me know.
Here's an example of the data as it's currently being rendered:
Power Supplied
On a side note, I've tried adding a Line control to the List, but it renders on every line. I also have no way to detect when the last line of a Catagory is being rendered. I've tried every way I can think of using the tool, but it's just not working for me.
TIA,
John.
|||I would suggest placing the matrix inside a list control. Group the list control by category which will result in a separate matrix being rendered per category. You can then place the category in a textbox above the matrix and also inside the list and center it.|||Adam,
Mad thanks, that did the trick!!
John.
cheston wrote:
So i've created a flat file destination control and have mapped the columns. At what point can you control which column shows up first?
In the advanced section of the Flat File Connection Manager screen.|||I do not see an option to move the columns and dragging them does not work either.
|||
I do not see an option to move the columns and dragging them does not work either.
Nope. You have to define them in the desired order first.|||If that's too painful, it might worth a try to edit the .dtsx file itself and reorder the DTS:FlatFileColumn elements.
