Message board style!

[niles04]

I need to display notes in CR9 in a message board style. The notes in SQL are in two columns, one is ID and the other is parentID. In the front end users can reply to each others notes, the notes are indented to show which one follows which? How do I display that format in Crystal?

 

[synapsevampire]

It sounds like you do a self join, so add the table in a second time and join from Parent ID to ID.

Group by Parent ID and the tree view should demonstrate a hierarchy of sorts for them to navigate.

-k

 

[niles04]

Tried that suggestion but is not giving the right result. When the IDs are grouped you no longer see the Ids and the notes are not in the order desired. The order is another issue. It is not the time of the post. Any suggestions are welcome. Thanks

 

[synapsevampire]

Perhaps you could explain what is right, such as example data (a few rows) and the expected output.

-k

 

[niles04]

Here is what I'd like to see:

ParentID1
...ID1
......ID2
.........ID3
............ID4

ParentID2
...ID1
......ID2
.........ID3

in the database I have a column called ParentID and a column called ID. If the same value is in both columns that means that they are related. An ID can also become a ParentID.

Hope this explains what I have and what I intend to do

Thanks

 

[synapsevampire]

Oracle handles this in an interesting fashion if your SQL database in Oracle:

http://otn.oracle.com/oramag/webcolumns/2003/techarticles/gennick_connectby.html

Here's a SQL Server article:

http://builder.com.com/5100-6388-1045789.html

Since you're using CR 9 and some type of a SQL database, you can use the Add Command and paste in your own SQL.

-k

 

[niles04]

Thanks for the links.
I did get to the result I wanted but through a sub report. Now I have a sub report in report A and I am trying to pull Report A as a sub report in the main report. However, Report A loses the sub report when I add it to the main report. Is there a way around it?

Thanks

 

[synapsevampire]

Crystal doesn't support subreports nested within subreports.

-k