asp.net (c# or VB) report from sql query with combined fields
$30-125 USD
Completed
Posted about 14 years ago
$30-125 USD
Paid on delivery
I have been working on a web based report from an existing client/server apps sql database.? I have a working query and can provide the query and a result set.?
The results currently? are similar to? this.
ID : Name1 : Date1 : Veh? : PO
1? : Bob 1 : 12/1? : Car? : 1234
2? : Sam? ? ? : 12/3? : Car2 : 2245
2? : Joe? ? : 12/4? : Van1? : 5568
3? : Mel? ? : 1/4? ? : Van2? : 5678
4? : Mel? ? : 2/2? ? : Car? ? : 3456
4? : Sam? ? : 2/3? ? : Bus? ? : 4565
4? : Joe? ? : 3/4? ? : Car? ? : 6766
The Problem is that I don't know ahead of time if each ID will have 1 or many lines.? I need the results to return a combined line.
Similar to
ID : Name1 : Date1 : Veh? : PO
1? : Bob 1 : 12/1? : Car? : 1234
2? : Sam, Joe? : 12/3? : Car2, Van1? : 2245, 5568
3? : Mel? ? : 1/4? ? : Van2? : 5678
4? : Mel, Sam, Joe : 2/2? : Car, Bus, Car? : 3456, 4565, 6766