displaying values in comma delimited format

[tandyaw]

I need to pull up data within specific date (that is specified by the users) and display the returned value in comma delimited. How can I do that?

So my data looks like the following:
TABLE 1:
PARENT ID CHILD ID
--------- ---------
12345 22234
12345 33345
12345 44456

TABLE 2:
CHILD ID DATE
--------- ------------
22234 11/14/2004
33345 02/20/2005
44456 04/15/2005

In the report, if the user wants to get all Child Ids for Parent ID 12345 between 01/01/2005 and 05/31/2005, then the result should be displayed as:
33345, 44456 instead in the list format.

BUt if they specify the date to be between 10/01/2004 - 03/01/2005, then the result will be displayed as:
22234, 33345

How can I do that?

Currently, I have a view that shows all the child IDs for Parent IDs in comma delimited format. However, I don't know how to incorporate the date.

Thanks in advance for any help that you can give me!

-Lia

 

[tandyaw]

By the way, this is for Cognos Impromptu.
But if it can be done in the database level, it would be great.

Thanks again!