Crosstab drilldown report

[strustam]

Hi!

I have no any issue when create drill down from Summary Report to other Summary Report.

I try to create drill down from Crosstab Report to Summary Report (v2023 and v2024)
I have the same error as it was in
viewtopic.php?t=50168
viewtopic.php?t=51944

; __append( sourceFldParm )
ReferenceError: sourceFldParm is not defined

Is it possible in general?
if Yes, can anybody provide the example in Demo project
or can anybody generate working solution and provide description how to do

Thanks in advance

[arbei]

arbei wrote:

Make sure you have set up the Source Field and Target Field for the drilldown report properly. If the source field does not exist, you get that error.

You may download the v2024 demo project and learn how the reports are setup, then apply to your own project.

Follow the tutorial Tutorial - Drill Down Report and Chart and make sure the Detail Report column under Drill Down section is properly set up.

[strustam]

Thanks for your prompt reply

Before this post, I followed the Tutorial, tested on my own project and on Demo2024 project. Drill Down on main report to detail report mapped, and at detail report parameters shown correctly, but generation of code stopped with error

There is no Crosstab report with Drill Down in Demo2024 project
I created Summary Report with Drill Down and it was OK

That is why my question
How to create Crosstab Reports with Drill Down, generated and worked successfully

[arbei]

You may post your drill down settings for crosstab report using the demo project so other users can try to reproduce your report and discuss with you.

[strustam]

Demo2024

There is Crosstab Report "Quarterly Orders By Product" based on "orders_by_product (View)"
at Row headings CategoryName, ProductName
at Column hedings OrderDate with Interval Year
at Value Amount (Sum)

I create Summary Report "Orders_by_product_new" based on the same "orders_by_product (View)",
at Grouping levels set CategoryName, ProductName and OrderDate and all with Show summary,
at Sort orders set CompanyName,
at Summary value set Amount (Sum)

in Crosstab Report "Quarterly Orders By Product", Report (Drildown) - Detail report i set for Amount -> Summary Report "Orders_by_product_new"
CategoryName -> CategoryName,
ProductName -> ProductName,
OrderDate -> OrderDate

I can see in Summary Report "Orders_by_product_new" checked Detail report Parameters => CategoryName, ProductName and OrderDate

Start generate and get this:
Generating QuarterlyOrdersByProductCrosstab.php (class)...
undefined:332
; __append( sourceFldParm )
^
ReferenceError: sourceFldParm is not defined

[Webmaster]

Click Tools -> Update Template and try again.