Thank you very much for this response wichitakid! Now it grabs all the columns I need. I had done some quirky thing with subreports and such in the meantime but now i'm going to go back and make it pretty and probably work faster.
Thank you for the quick response. I should have mentioned that I have tried left outer joining all the tables.
I can get the report looking great, up until the point I specify :
Communication_type.Communication_type = "CL"
Then it stops showing subjects that I want to show 0 values for...
I hope this is the right forum to go to, here's the technical information behind the rreport i'm trying to make.
Tables :
Communication
Communication_type
Subject
Permit
Permit_Type
Facility
Example of the report would be :
Draft indirect permits were sent to 0 facilities.
Draft direct...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.