multiple dataset in one tab

Question

Post reply

multiple dataset in one tab

Shuanna

SSC Enthusiast

Points: 171
More actions
July 9, 2009 at 12:47 pm

#384963

Is there a way, you can put multiple dataset in one table? I have two datasets and each of the have multiple rows. The columns are all the same. There is no problem for the first dataset since it is in the scope on the table. When I display the content in the second table, I can only show the first or sum of the data.. which is not what I want.. Also I don't want to use group by because I put to put some other data between these two datasets.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

2Tall SSChampion Points: 14644 More actions · Answer 1

As far as I am aware a table can only reference a single dataset.

Regards,

Phil

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

Shuanna SSC Enthusiast Points: 171 More actions · Answer 2

Thanks Phil! I got a workaround.. I merged all my datasets into one and created several tables to use the merged dataset but has filters on it.. and then wrap all the tables in one List..

2Tall SSChampion Points: 14644 More actions · Answer 3

Pleased to here you resolved.

Phil.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

becklery Hall of Fame Points: 3315 More actions · Answer 4

Hi, shuang.xia.

In my opinion, you can have a try of RAQ Report. It provides an almost perfect data submission solution: Multiple Database/Dataset Input.

With the Multiple Datasource/Dataset Input solution, you can relate different tables from different databases, and submit data to multiple tables/databases, and keep the transactional consistency of database easily.

You can get this free reporting tool at http://www.raqsoft.com/[/url].

Good luck.

RAQ Report: Web-based Excel-like Java reporting tool[/url]

Shuanna SSC Enthusiast Points: 171 More actions · Answer 5

becklery,

Thank you so much for the information. I am exploring it now.