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 |
|
bpabmeyer
Starting Member
2 Posts |
 Posted - 2009-07-01 : 11:53:13
|
| I created a RS report that basically resemebers a letter to individuals. When I run the query in the data tab, I get eight records returned. When I run the report to preview, the only record I get is the last record in the query (I know this because of the order by clause). I have the data fields embedded in the Body section of the report. I am lost. Can anyone give some guidance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-01 : 12:50:23
|
| order by wont change number of records returned. seems like you're using some filter expression either on report container or on dataset which is filtering out the other seven records. |
 |
|
|
bpabmeyer
Starting Member
2 Posts |
Posted - 2009-07-01 : 15:11:19
|
quote:
Originally posted by visakh16
order by wont change number of records returned. seems like you're using some filter expression either on report container or on dataset which is filtering out the other seven records.
I understand the order by will not have an affect on record counts. Sorry, I wasn't very clear.I created a new report with two fields (database ID and date). My query is as simple as "select id, date from table where date = @date order by id". I am not trying to push the dataset info to a table or matrix. I am pushing all the data to text boxes, as I mentioned before, I am trying to create a mailable letter. I still get only the last record in the dataset, no other records. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-02 : 14:20:46
|
| textbox will be able to display only one value. what you need is a table container which is linked to dataset with two columns showing id and date if you want all record values from your table to be displayed |
|
|
|
|
|
|
SSRS 2005 Not all records displaying