January 17, 2010 at 10:36 am
I'm new to ASP.NET so this might be simple. I am creating a report using VWD 2008 Express. The SQL i'm using is:
select objectiondescription,count(*) as Counter
from usr_app_objections o
inner join usr_app_master_objections m
on m.masterobjectionid = o.masterobjectionid
where objected = 1
group by objectiondescription
order by m.objectiondescription
If I run it from the SQL Server Management Studio it returns all rows, but when I added a webpage with a DataSet using the query and open the page, only the last row on the results show up. I checked the report and can't find anything wrong with it. The columns were pulled from the website data sources pane and put into the body but the body does not seem to loop. What am I doing wrong?
Attached are the webpage and the report. Any help will be really appreciated.
January 19, 2010 at 11:51 am
Needed to place the text boxes inside a list. DUH!!!
Thanks Jack Corbett
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply