For example:
Code: Select all
Date | User | In Time | Out Time
1/1/2019 1 7:00 12:00
1/1/2019 1 12:00 12:30
1/1/2019 1 12:30 17:30
Code: Select all
Date | User | In Time | Out Time
1/1/2019 1 7:00 17:30
Is there a way to get this done in the report designer "without" creating a sql query to have sql return only one row? I can get it done using a query to get the data I want from the database directly as a new datasource, but the problem I have then is I loose the parameters that were used.
Not fully understanding just how this report software works, I am sort of fumbling around trying to figure it out. I have tried using the new datasource from sql that condenses the output and creating a relationship with the original datasource the software created originally for the report, so I could maybe compare the dates and output when the info is a match, but the original datasource never increments its row or data and I get gibberish.
Im sort of left right now at a point where I can use the report, but its locked into what I set it up to output.