hierarchical datagrid........Needed Help Urgently

[inguva_vamsi]

Hi

I want to display a hierarchical datagrid in more tabs of a account. Is it possible to build a hierarchical datagrid in saleslogix 7.5 (LAN). If so please kindly help.

Thanks in advance

 vamsi

[jamessutton]

You'll have to use a 3rd party grid control.  We do this all the time for our customers.  And since they already use Infragistics within the Default Sage product we did the same and used the Infragistics webgrid.  You'll have to be careful of the version you use however, Sage currently uses 7.2.1 so you'll have to use the same.  If you purchase the most recent .net suite from Infragistics they will provide past versions upon request.

The nice thing about the Infragistics grid is that you have a lot of control over the load events so you can for example populate the top level records and retrieve child band data asynchronously.

Best  Regards,

James Sutton

[mboysen]

Since you are doing this in the LAN, you can use the QuantumGrid from DeveloperExpress. It's what the LAN datagrid is based on and has many options for building trees, etc.

If you mean simply using more than one grid and filtering a second grid based on the highlighted row in a parent grid, you can do that with the out of the box control.

Which are you trying to do?

[jamessutton]

Hi Vamsi,

Apologies I assumed you meant the Web.  The SalesLogix LAN component while it does support hierarchical grouping does not have hiarchical data band capabilities, however, we have used our Infragistic WinGrid to do just that.

Regards,

Jim.

[inguva_vamsi]

Hi James,

Thanks a lot for your reply.Actually what i am trying to do is i do have three tables that got binded with account and all these three are different set of data for each contact of an account. So when i choose a contact in the tree view (this has to done in more tabs) the grid should populate all the data that is for the respective contact as just like stages/tasks datagrid under campaign. So could you pls suggest steps  what i have to do for this with in Saleslogix

My environment is SLX LAN 7.5  and Oracle 10g

Regards

Vamsi Inguva

[mboysen]

There are a couple of ways to approach the problem.

1. OnChangeNode of Parent Grid (I believe) you can rewrite the SQL property for child grids, or
2. OnChangeNode you can apply a filter to the recordset property of the grid (no intellisense)
3. OnChangeNode - you could simply change the binding to be related to the parent record / entity.

Recordset filtering has some limitations, but performs extremely well because you won't have to hit the database again.  The binding will work too. Even if the grid starts off as bound to the Account, you can change that on the fly.

One thing about recordset filtering, you'll need to set the datagrid.recordset = nothing at the OnChange event of the form or the grid will lose it's binding as you change records.

[jamessutton]

Yes, you can display hierarchical data but not with the native SalesLogix controls.  You'll need a 3rd party grid control to do this.  We've done it before in SalesLogix LAN using Infragistic's WinGrid.

Regards,

Jim Sutton

[inguva_vamsi]

Hi

I want to show this in more tab view of saleslogix(My Development Environment is saleslogix 7.5 LAN and oracle 10g). Could you please suggest where can i get this control and how can i add it to the saleslogix control list or how can i add a form (if i developed this form in dot net) to view it in more tabs

Regards

Vamsi Inguva

[RJLedger]

These are not free controls. You have to purchase them from the (original) vendor.