| Author |
Topic |
|
Wozer
Starting Member
29 Posts |
 Posted - 2009-06-09 : 15:54:39
|
| Is there a good way to create a static table in SSRS where I can manually input all of the data? The static table is a bunch of codes that will never be changed. What I did for the static table was create a "table" that is just a bunch of text boxes lined up with each other.When I go to preview the report, the table populated by a stored proc, pushes part of the "static table" down to the bottom of the populated table so there is a big gap between the first few "rows" and the rest of the table.Is there any way to stop this, other than putting the static table underneath the populated table?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-10 : 14:34:17
|
| how do they look in designer? do they overlap? |
 |
|
|
Wozer
Starting Member
29 Posts |
Posted - 2009-06-11 : 08:32:02
|
They dont overlap each other it looks something like this in designer Table Table TextboxTable=Column 1 =Column 2 =Col 1 =Col 2 txtCol1 txtCol2 txtCol3 =data =data =data =data txtdata txtdata txtdata |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-11 : 13:11:05
|
| does table cells displays long textual data? also is autogrow property set to true? |
|
|
|
Wozer
Starting Member
29 Posts |
Posted - 2009-06-11 : 13:18:11
|
| The first table shows about 26 rows the second table is only 4 rows of data.The CanGrow property under Layout is set to true is this what you mean by autogrow? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-11 : 13:33:54
|
| i meant cangrow property of individual cells |
|
|
|
Wozer
Starting Member
29 Posts |
Posted - 2009-06-11 : 13:47:31
|
| Yes, the CanGrow property for all of the cells in the table are set to true |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-14 : 04:12:26
|
| that may be a reason. are data showing really long? |
|
|
|
Wozer
Starting Member
29 Posts |
Posted - 2009-06-15 : 08:35:20
|
| The data isn't really that long. Its a Name and then a dollar number next to it so something likeBill Gates $300,000and there are about 20 or so rows like this. |
|
|
|
Hiroshi
Starting Member
1 Post |
Posted - 2009-08-27 : 22:28:46
|
| Hi, i have a similiar problem with Wozer. the report needs exactly n-number of rows in the table. let's say 5 rows. this table will be populated from store procedure. no matter how many data it returns, the row must be exactly 5. if i have 20 records of data, it will show only 5 row. and if i have less than 5 records, maybe 3 records, it will also show 5 rows in the table (3 rows with data, the other 2, blank). anyone knows how to do it? your help will be appreciated. thanks in advance |
|
|
|
yavvie
Starting Member
46 Posts |
Posted - 2009-09-08 : 04:45:14
|
| Hiroshi - you can use a filter on the data source that accepts the top 5 rowsbest way is to optimize your procedure to return exactly what you need - create a table with 5 rows and use update to put there your 5 or less rows of data and then make that table the output of your procedure. It is easier than playing with the report and if the requirements are changed you just change your procedure and report will work the same. |
|
|
|
|
Table Pushing text boxes beside it down