PivotChart SubForm

[cparralesl]

Hello Guys,

I created a subform with chart purposes, so I change the "Allow PivotChart view" Property to yes, the others remains No. The Default view I set it as PivotChart.

I set the subform chart I save it and I test it. It shows data in bar chart type. But, when I insert it and link it to the main form, the subform chart shows nothing.

Because I'm using VBA code to set the LinkMasterFields and LinkChildFields manually, I do not know what else have to do to make it works.

I have in the same form, but in a diferent page of a tab and as form view, a subform that show data whitout a problem. In the of the subform chart it uses a query, not a table as in the other subform.

I use the same code in both forms:

Me.SFGraficoRegiones.LinkMasterFields = "lblRegionValue"
Me.SFGraficoRegiones.LinkChildFields = "ID_REGION"

Any help will be appreciated.

Regards,

Cesar Humberto Parrales
Application Support

 

[lameid]

I have in the same form, but in a diferent page of a tab and as form view

You mean you have two identical but differently named subforms? If not try that first.

Secondly, it seems odd yo be programatically setting the master and child fields... Why not set them manually or use criteria in your query to limit values based on the main form and requery the subform as necessary?

 

[cparralesl]

Thanks for your response lameid,

Basecally I need a dinamic chart, thats why I use a SubForm having PivotChart as a default view. This Subform use a query that I built and save it before, than i assign it to the PivotChart Subform.

My question is how can i make this subform dimanic?

Thanks in advance.

Regards,

Cesar Humberto Parrales
Application Support

 

[cparralesl]

Hi again:

Basically I need the PivotChart SubForm changes based on the seleccion the user make in a Listview. The list view has a list of places like States, Departaments. For example: If the user selects the state of Texas then the PicvotChart Shows how many mans and womans it has.

Help woul be gratly appreciated,

Regards,

Cesar Humberto Parrales
Application Support

 

[lameid]

I really haven't had a need to use charts but I would expect that if your query used a paramter that used the list control, and you requeried the subform / chart on the after update event of the list, it would work.