Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Issue with Small matrix spilling over 2 pages Expand / Collapse
Author
Message
Posted Thursday, January 10, 2013 11:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:19 AM
Points: 13, Visits: 60
I have a small matrix that measures 3.5 on the ruler. my report is set as landscape. but it seems when ever i put a box or anything a little wider then my 3.5 inches it spills over to another page. Im pretty skills in RS 2005 but just getting started in 2008 so im having some issues with the new matrix formats. any ideas would be great.
Post #1405572
Posted Friday, January 11, 2013 3:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 5:44 AM
Points: 243, Visits: 2,698
click on the report design area and then go to properites. Check the interactive page sizes.
Post #1405864
Posted Friday, January 11, 2013 10:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:19 AM
Points: 13, Visits: 60
i have it set as 11 wide and 8.5 high. which is what i want. any other ideas
Post #1406172
Posted Friday, January 11, 2013 10:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 2,819, Visits: 2,563
If you are working in 2008, set the property ConsumeContainerWhitespace = true. I believe 2005 either does not have this property, or it is already set to True.
Post #1406180
Posted Friday, January 11, 2013 10:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:19 AM
Points: 13, Visits: 60
did that and still same result
Post #1406194
Posted Monday, January 14, 2013 8:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:19 AM
Points: 13, Visits: 60
Still have the same results, anyone have any ideas?
Post #1406751
Posted Tuesday, January 15, 2013 5:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 5:44 AM
Points: 243, Visits: 2,698
Does it spill over if you export to pdf?
Post #1407208
Posted Tuesday, January 15, 2013 6:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:19 AM
Points: 13, Visits: 60
Yes it does.
Post #1407210
Posted Tuesday, January 15, 2013 6:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 5:44 AM
Points: 243, Visits: 2,698
Are you adding the text box to the matrix or outside the matrix? Have you turned off the CanGrow properties of the columns? Last, what happens if you put the matrix inside a rectangle? I know I have always struggled with matrix especially when the number of columns is unknown.
Post #1407213
Posted Tuesday, January 15, 2013 6:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:19 AM
Points: 13, Visits: 60
I have textboxes outside the matrix, but i put the matrix inside a rectangle and that seemed to work.
Post #1407217
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse