Using dataviews in reports

  • Thread starter Thread starter Earl
  • Start date Start date
E

Earl

I'm creating a report that needs to be split up by a date range, then by
employee, then by weeks within the employee daterange. Better to use
multiple dataviews to accomplish this or is there a better way? Filtering
and refiltering hasn't struck me as being the cleanest method of handling
this scenario.
 
Hi Eerl,

Did you think of using grouping (usual report capability)?
how are you doing the reports?
 
I'm not sure what you mean ... I'm using ActiveReports.

Miha Markic said:
Hi Eerl,

Did you think of using grouping (usual report capability)?
how are you doing the reports?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Earl said:
I'm creating a report that needs to be split up by a date range, then by
employee, then by weeks within the employee daterange. Better to use
multiple dataviews to accomplish this or is there a better way? Filtering
and refiltering hasn't struck me as being the cleanest method of handling
this scenario.
Click to expand...
Click to expand...
 
Hi Earl,

Let's say you have to split a report by a data range (let's say by starting
quarter) and you have following data:

From, To
1.jan.2000, 15.jan.2000
10.jan.2000, 15.jan.2000
3.feb.2001, 5.mar.2001

I would add another column which I fill by code
From, To, Quarter
1.jan.2000, 15.jan.2000, Q1/2000
10.jan.2000, 15.jan.2000, Q1/2000
3.feb.2001, 5.mar.2001, Q1/2001

Now, I have the perfect grouping column. Within report design a group by
Quarter column and there you go.
Is this what you were looking for?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Earl said:
I'm not sure what you mean ... I'm using ActiveReports.

Miha Markic said:
Hi Eerl,

Did you think of using grouping (usual report capability)?
how are you doing the reports?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Earl said:
I'm creating a report that needs to be split up by a date range, then
by
employee, then by weeks within the employee daterange. Better to use
multiple dataviews to accomplish this or is there a better way? Filtering
and refiltering hasn't struck me as being the cleanest method of handling
this scenario.
Click to expand...
Click to expand...
Click to expand...
 
Thanks for replying Miha. Actually what I'm looking for is more like:

Employee
Date range
Weeks within date range
Columns within weeks (for job, date worked, hours, etc.)

Breaking it out by Employee and date range is not an issue. Nor is the
column breakdown. And I have the code written to determine what weeks show
up within the date range. I'm just not clear on whether to filter through
the weeks by filtering and refiltering a dataview, or use separate dataviews
filtered per week. Or ......?

Miha Markic said:
Hi Earl,

Let's say you have to split a report by a data range (let's say by starting
quarter) and you have following data:

From, To
1.jan.2000, 15.jan.2000
10.jan.2000, 15.jan.2000
3.feb.2001, 5.mar.2001

I would add another column which I fill by code
From, To, Quarter
1.jan.2000, 15.jan.2000, Q1/2000
10.jan.2000, 15.jan.2000, Q1/2000
3.feb.2001, 5.mar.2001, Q1/2001

Now, I have the perfect grouping column. Within report design a group by
Quarter column and there you go.
Is this what you were looking for?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Earl said:
I'm not sure what you mean ... I'm using ActiveReports.

Miha Markic said:
Hi Eerl,

Did you think of using grouping (usual report capability)?
how are you doing the reports?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

I'm creating a report that needs to be split up by a date range, then
by
employee, then by weeks within the employee daterange. Better to use
multiple dataviews to accomplish this or is there a better way? Filtering
and refiltering hasn't struck me as being the cleanest method of handling
this scenario.
Click to expand...
Click to expand...
Click to expand...
 
Hi Earl,

It depends on whether ActiveReports support this operation to filter the
weeks within the date range. Generally, reporting views should support this
function, so we just need to pass the whole data view to the control and
let it filter out what we need and group for us.

Does this answer your question? If anything is unclear, please feel free to
reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
I have not yet resolved this issue and simply laid it aside for a few days,
altho it is next on my agenda. ActiveReports can filter the weeks, so I'm
going to play around with this a bit and will let you know. Thanks Kevin.
 
Back
Top