Would it not be possible for you to change the parameters for report and, instead of taking a single id, accept a string. Then, your SQL query could return multiple invoices by doing a :

select
*
from
invoice_table t
where
t.id in (@parameterIDSt ring)

instead of

select
*
from
invoice_table t
where
t.id = (@parameterID)

...

A couple of other options:
A bit verbose, but you can do this:

select
dtForm = cast(day(dateFi eld) as varchar) + '/' + cast(month(date Field) as varchar) + '/' + cast(year(dateF ield) as varchar)

obviously, "dateField" is the name of whatever date field you're pulling from the database. If you still wanted that as a date, you could always recast that back to datetime with the cast function, just...

I'm a newbie to the messageboard, but I'm wondering if any of you gurus have tried to do the following before? I'm developing a custom reporting solution as part of a web application for a corporate client. One of the required features is a user-defined reporting (UDR) solution, but we cannot use ReportBuilder because their corporate firewalls prohibit ActiveX controls. Therefore, I have a wizard-style ASP.NET and C# interface that essentially...