Hi all... I am trying to create a SQL Server report in VS2005 that will read 5 sql server tables. One table is the parent and will always be populated. The other tables may have no rows or multiple rows that match the key from the parent table (I used Left
joins). I am having a problem with my report reading the rows returned from my sql procedure. I have one table on my report for data that is from the parent and it only needs to be displayed one time. If I have two rows returned from my procedure, I get two
rows back in my report table. I have used the property Hide Duplicates to get rid of them but the spaces are still there. The second problem I have is that one table sends back 2 rows with two different value lists. I need both of them to display. It does
display twice but in both I only get the first row's data from the query. It is as if the report knows there are two rows because everything repeats twice but it is only showing the data from the first row.
Basically I need to know if there is a way to step through my proc results and populate my report the way I need it to be.
I have done several searches on the web on VS2005 reporting and can't find any good resource. I am new to VS2005 reporting AND VS2005 in general. I have managed to create a website by reading books and doing searches but I am trying to do the reporting part
now and I am stumped. Can someone refer me to a good source (a book or online) where I can get a good explanation of how reporting needs to be setup in VS2005?
Landarr
0 Points
10 Posts
VS2005 reporting using tableadapters
Jul 27, 2007 03:54 PM|LINK
Hi all... I am trying to create a SQL Server report in VS2005 that will read 5 sql server tables. One table is the parent and will always be populated. The other tables may have no rows or multiple rows that match the key from the parent table (I used Left joins). I am having a problem with my report reading the rows returned from my sql procedure. I have one table on my report for data that is from the parent and it only needs to be displayed one time. If I have two rows returned from my procedure, I get two rows back in my report table. I have used the property Hide Duplicates to get rid of them but the spaces are still there. The second problem I have is that one table sends back 2 rows with two different value lists. I need both of them to display. It does display twice but in both I only get the first row's data from the query. It is as if the report knows there are two rows because everything repeats twice but it is only showing the data from the first row. Basically I need to know if there is a way to step through my proc results and populate my report the way I need it to be.
I have done several searches on the web on VS2005 reporting and can't find any good resource. I am new to VS2005 reporting AND VS2005 in general. I have managed to create a website by reading books and doing searches but I am trying to do the reporting part now and I am stumped. Can someone refer me to a good source (a book or online) where I can get a good explanation of how reporting needs to be setup in VS2005?