I have created a simple form with a pivot grid and an XPView which is set as it's datasource.  I see all of the fields and am able to run without any errors, but there is no data in the PivotGrid.

I know that the XPView is working because I added a standard GridControl as well and set it's datasource to the view also and it shows all of the data.

I just am unable to see any data in the PivotGrid.

Any suggestions on where I might start???  I know that is pretty vague, but I'm not sure what is going on.

Thanks,
JIm

What type of data are you binding to the grid for the DataArea? If you are binding text, try setting SummaryType="Max" on the DataArea field.

Example:

<dxwpg:PivotGridField Area="DataArea" FieldName="Response" Caption="Response" SummaryType="Max" />

Thanks for the response Joey.

The data in the Data area is an Int32.

My XpView queries order, products and shipments and comes up with 4 properties:  Product #, Work Order #, Ship Date and Ship Quantity.

I have set the Ship Date as 4 different fields in the PivotGrid with GroupIntervals set as DateYear, DateQuarter, DateMonth and DateDay in order to be able to drill down to the day level.  I put the Product # in the column area, the all 4 date fields in the row area and the Ship Quantity in the data area.  I have a criteria on the view so it will pull the shipping data for only one product.

Like I said, I have included a GridControl on the form as well to make sure I am getting data and that is fine, but the PivotGrid doesn't show anything.

Jim

I'm having the same problem. Did you work out what the cause was?

I can use one sql query and it works fine. A different sql query does not work.

 Dan,

I am so far behind on my current project that I didn't have time to deal with this.  I tried with a dataset as the datasource instead of an XPView and it works great.  Maybe I will come back to this next year when I have this thing live and have got through the first handfull of enhancements that are already on the list!

My ultimate goal is to utilise SSAS as an OLAP engine, but I don't have time to learn that either .

Good luck with your issues.

Jim

I discovered the cause of my problem.

I had something like:

grid.Fields.Add(new PivotGridField("Name", PivotArea.RowArea);

This added a field to the grid ok. The field in the datasource was called "name", not "Name", so it was showing nothing in the grid.

It appears as though FieldName's are case-sensitive.

 Good info to know Dan.

Thanks