Incomplete RecordSet rendered in report
in [Reports]
|
Prev: Cascading parameter doesn't work right in BIDS, but works fine in
Next: If you can determine the number of records per page this solution isbest
From: Pete Hay on 5 Mar 2010 12:28 When I use the query builder to view a select query I get the expected number of rows returned. When I view this in report mode only records with the first instance of a certain field are rendered. ie: select * from foo order by Field2 Returns all records in the Query Builder Returns only the first instance of each field2 in the report I added the sort so I could compare the results. Original query has no sort. Shouldn't the query results and the report results be identical? Using Report Builder 2 against ODBC database. (also get the same behavior in VS2005 BI) I hope this makes sense, Pete
From: Bruce L-C [MVP] on 5 Mar 2010 16:31 I'm guessing that you do not have the query bound to a table control. If all you did was drag and drop your fields onto the design surface then you are only going to see one record. You either need to use a table control or a list control and drag and drop your fields onto one of the other controls. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "Pete Hay" <PeteHay(a)discussions.microsoft.com> wrote in message news:254F527C-8EEE-4A9E-B763-53592B2D2F50(a)microsoft.com... > When I use the query builder to view a select query I get the expected > number > of rows returned. When I view this in report mode only records with the > first > instance of a certain field are rendered. ie: > select * from foo > order by Field2 > > Returns all records in the Query Builder > Returns only the first instance of each field2 in the report > > I added the sort so I could compare the results. Original query has no > sort. > Shouldn't the query results and the report results be identical? > > Using Report Builder 2 against ODBC database. (also get the same behavior > in > VS2005 BI) > > I hope this makes sense, > Pete > >
From: Pete Hay on 5 Mar 2010 18:48
Thanks Bruce - It was the List Control that I was not understanding. Pete "Bruce L-C [MVP]" wrote: > I'm guessing that you do not have the query bound to a table control. If all > you did was drag and drop your fields onto the design surface then you are > only going to see one record. You either need to use a table control or a > list control and drag and drop your fields onto one of the other controls. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Pete Hay" <PeteHay(a)discussions.microsoft.com> wrote in message > news:254F527C-8EEE-4A9E-B763-53592B2D2F50(a)microsoft.com... > > When I use the query builder to view a select query I get the expected > > number > > of rows returned. When I view this in report mode only records with the > > first > > instance of a certain field are rendered. ie: > > select * from foo > > order by Field2 > > > > Returns all records in the Query Builder > > Returns only the first instance of each field2 in the report > > > > I added the sort so I could compare the results. Original query has no > > sort. > > Shouldn't the query results and the report results be identical? > > > > Using Report Builder 2 against ODBC database. (also get the same behavior > > in > > VS2005 BI) > > > > I hope this makes sense, > > Pete > > > > > . > |