PlusMinus Sign on parent row without child rows

I'm new to CJ and what I'm trying to do is showing a lot of records into a Report Control (5000), each of them has at least 2 child records.

If I build the report, it takes a while to build, so I thought, if I can build the report with only the Parent records that gives me an acceptable build time. I want to have the + sign in the first column, and only if i press the + then I query the database for the child records and add them to the report.

 

The result is the same, but loading time, is speed up a lot.

 

Can someone give me a tip.

 

1/ The first thing I need to know is how to force the Row to show the + sign if there are no child record underneath?

 

2/The event that fires when the + sign is pressed, so I can add the child records before expanding

 

Greetings

Katrien

 

 

 

The problem of speed is not a Codejock Problem, I have to search for data in different databases in multiple tables and that takes time.

 

To reduce the time for the end user I thought to load the Parent records with the Plus Sign already shown, and when the user clicks the sign, then go look for the child records and add them.

 

The way I do it know is when I add a parend record, I add a empty dummy child record, so that the + sign appears. When the user clicks on the +, then I delete the dummy child record and add the real child records.

 

this means that i only need the time for building the child records for the parents where I'm intrested in.

 

But I wonder if there is a property so I can force the parent record to show the + sign, without al the workaround stuff.

 

Regards

A little more info on above code:

This event fires whenever RC needs to be redrawn (mouseclicks, scrolling etc etc) so the icon 'expanded' shows only when a row is really expanded and to expand a row you need childs otherwise its just an ordinary row. Because you removed + / - icon (from .Glyphs collection), the row responds to a single click and you are able to fill the record with the childs. You have to check if you added childs already of course or another option is (when row is collapsed) remove its childs again. Basicly same way as Windows Explorer works, + sign is always present even when the folder is empty. Only clicking the folder wil update icon.

 

Hope this helps