January 14, 2010 at 1:59 pm
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?
January 14, 2010 at 2:25 pm
Made a mistake on the title. It should have been: "Report only printing last ROW". Cannot change it so I'm adding this reply 😉
January 15, 2010 at 8:18 am
You'd have to show us the code in your ASP.NET page. There is something you are doing in .NET that is causing it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 15, 2010 at 9:13 am
I attached a file with the DataSet, the report and the webpage.
Thanks
January 19, 2010 at 9:40 am
Looking at your report you need to place the textboxes in a list or use a table to display multiple rows. Without a list or table you only get the last row.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 19, 2010 at 11:48 am
I knew it was something stupid.
Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply