Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fredong
Yak Posting Veteran
80 Posts |
 Posted - 2005-05-18 : 15:46:41
|
| I am new to reporting services. I created a dataset and with store procedures string and when I ran the Data it showed all the the rows. However when I preivew it only show one row.If I refresh it it will show the next row of data.Please advise. Thanksk |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-05-18 : 17:49:54
|
| Are you using detail table or textboxes? If you test out in Data view and able to get all records, then there must be something wrong when you are creating the reports in layout view. I would look at the samples that came with reporting services and see what they are doing. Also I recommend doing simple query and see if you can get it to display all rows.It sounds like you'r not using using detail Table or Matrix table. You could be, but maybe you're not putting the fields in the correct section. Like maybe headers or footers? |
 |
|
|
fredong
Yak Posting Veteran
80 Posts |
Posted - 2005-05-19 : 08:44:22
|
| I got you. I was simply using thedrap and drop Field from the Select Fields. By the way I change to use the table and now I am able to see all the rows. Another Question on the table how come there are only 3 colunms avaliable? How can I add more columns? Thanks.k |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-05-19 : 09:34:02
|
Right click a column and do an 'add column to the right' or 'add column to the left'come on now you have to play with it before you ask basic questions like that.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
fredong
Yak Posting Veteran
80 Posts |
Posted - 2005-05-19 : 09:39:33
|
| Thanks,that work.However is there a way configure to nmber of columns instead of inserting one by one?k |
|
|
|
|
|
|
Preview not showing all the rows?