rdrunner40
MIS
Hi there
A new user here to access basically i have a report that is a kit list of all our users at work. What i am wanting to do is to have all the users applications appear only once in the details section.
I have a details section which contains all the application currently in use on our network maximum 15 applications installed across 27 users ... what i have done so far in the designer is to 15 applications on the report in design mode and if the underlying fields are not populated in the table then make the fields invisible from the onformat property. Doing it this way i cannot get the details section to close up and remove all the white space ....
Is there a way to do this. I am using four tables with a prmary key across all of them and i am using a select query to make the underlying data to be used in the report.
Doing it this way i have all the user data appearing in a flat file layout but i realise this is wrong ... but how to i change it so i have a header label for the application and a header lable for the OEM number and then when the report is run there is only the applications listed that the current user has on the PC....
Any help greatly accepted.
regards
Murray
A new user here to access basically i have a report that is a kit list of all our users at work. What i am wanting to do is to have all the users applications appear only once in the details section.
I have a details section which contains all the application currently in use on our network maximum 15 applications installed across 27 users ... what i have done so far in the designer is to 15 applications on the report in design mode and if the underlying fields are not populated in the table then make the fields invisible from the onformat property. Doing it this way i cannot get the details section to close up and remove all the white space ....
Is there a way to do this. I am using four tables with a prmary key across all of them and i am using a select query to make the underlying data to be used in the report.
Doing it this way i have all the user data appearing in a flat file layout but i realise this is wrong ... but how to i change it so i have a header label for the application and a header lable for the OEM number and then when the report is run there is only the applications listed that the current user has on the PC....
Any help greatly accepted.
regards
Murray
