Hi!

I will create a number of different reports using the reportviewer in ASP.NET 2005. I have the datalayer as tableadapters and I ahve created objectdatasource classes for all my reports.

I have a few questions.

1) How to handle parameters? In one of the reports I need the user to select a user id before generating a report for this user. I have in th eobjectdatasource a method

GetReportDataByUserID(byval userid as integer)

Shall I use this table subset returned by the datasource, or shall I use the parameter functionality in the report itself? I noticed I can't design a report from an objectdatasource, only from my website datasources. But I guess since the fields are the same it doesn't really matter.


2) What if I have different sections in the report that need differnt objectdatasources? How to deal with this? For example on my employeereport I first write some basic info about the employee. And then I have a table where I want to list the past employments. This information is located in a diffferent objectdatasource. How can I tell the report "for this section, look for the values in this datasource, and in this section use the other datasource? In the design mode of the report I only state !Fields!PLATENO.Value, not !Fields.ObjectDataSource1.PLATENO.Value.

Is this at all possible or do I have to add lots of sub reports?

This is kind of uurgent so I would appreciate a quick reply.

kind regards
Henrik