Trying to condense a Databand.
Posted: Sat Aug 03, 2019 6:18 pm
I have a data source that is displaying login and logout details generated by some software. This software auto inserts breaks causing each days login data to have 3 rows of data associated with it. This software also allows you to generate the reports based on some user defined parameters such as date ranges, users, etc. As far as I can tell, there is no way to capture what this software is passing to what ever it uses to make this report software generate the reports. The Databand looks like this:
For example:
I would prefer the data be the first and last of the day, for example:
There are many many more rows of data, but this is the pattern. Three rows for each day.
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.
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.