1) I'm able to generate a report with data from parent form. But is it also possible to add fields from grand parent forms or forms not directly linked by lookup field, but INDIRECTLY related by lookup fields?

2) Is it possible to use related fields in the pivot chart report? I only get a list of fields from the form that I select as base, not from linked ones. And also again, is the same logic as point 1 valid for pivot charts?

Thank you