Displaying & sorting multiple table data

[mg712]

Given any number of tables I would like to display and sort their data by date and time. I'm using ADO.NET datasets. I'm able to do that for the one table but I'm lost when it comes to more than that. Do I need to create groups? Any help appreciated. Thanks.

 

[synapsevampire]

That would depend on the tables.

If your question is a pure ADO.NET question, try posting in that forum, but it really sounds like a database problem, so you might consider posting in a database forum.

To append datasets in Crystal you might use a UNION, otherwise a Stored Procedure on the database using a temp file is probably the most efficient means.

-k

 

[synapsevampire]

Sorry, I should have stated that Crystal does not allow multiple datasets within a single report.

You also didn't mention if you were combining the data, or justsorting each dataset seperately.

Consider posting example data and expected output, you might also mention the database being used, and version of Crystal.

-k