Help with report and crosstab queries

[stefanocps]

Hello
i have in my db 7 reports made from 7 crosstabs queires

I am trying to use this path to gather the report

Put in the foot of 1 report another report
But i receive an error and the 2 report is blank
I attach the db
if you start the report ETA, at the foot of it there is the report OCCUPAZIONE
Eta work, occupazione not


Also another solution will be good
Just need to gather the result from those seven queries alltogether


Thanks for help!



Before of using the report, please open the form RICERCHE and set the 2 date...example 1/1/2018 and 1/1/2019 then set the pointer in one of the 2 textbox
After this open the report

 

[bastanu]

Hi Stefano,
Have a look at the attached (look at report1) and see if that is what you wanted. You will need to set the column headings property for the 7 crosstab queries to "femmina","maschio" (I attached a screen shot inside the zip file).
Cheers,
Vlad

 

[stefanocps]

hello
Thanks a lot...Great!
I can eventually do what i need


Please tell me hot to replicate onmy original db(i have posted a moidifed one for make things easier


I put the report in the main report, in the BODY part
I have set the column name in all the queries
But i have receive error in my report
Is there anything else to do?

 

[stefanocps]

ok it works
i was using , instead ; in the colum heading


Great
I really thank you!

 

[bastanu]

Glad to hear it works!
Vlad