Hello Folks,
I hope this is in the right place to post… i want to create a report using reportwriter to show activity that is NOT there.
Example: I have to have provide a monthly report to an agency for each client. I can get a report to show who I did a report on, but those that need one do not show up.
I want to run a report showing those clients I have NOT competed done anything with.
How can I create a report showing a “NO Activity” listing?
Thanks
I am not sure if this is along the correct intent for you but:
My generic approach is this:
Loop over all clients looking for records that have been modified that lie within the start/end date time of the month then you can easily differentiate those with activity and those without. (This assume s of course that you have fields with the modification datetime attribute as well as the userid attribute or some other field with a similar data.
This approach could be implemented many ways depending on whether you have a report designer/generator or do it with Servoy code.
Is this along the lines of intent for you?
No Sorry,
I’m not sure if this will work as there are other activity in the month that is done. I talked with some folks in #SQL on freenode yesterday who showed me a sql command , identifying a value of say “10501” then looking for the absence of that value. Don’t really understand it so I am getting a book today on SQL to learn the basics. So, If I can find clients “WITHOUT” an entry of “10501” using SQL command lines, how can I implement that search into reportwriter ? I can use reportwrither to find any data in the database, I just cannot figure out how to find an occurrence of “missing” data for a client.
Thanks
Sounds like you need to look into the “not exists” clause of SQL
Paul