Hi:
I have a situation where I have a series of time records (one or more per day) for a
number of projects. Each record has an identification for the activity conducted during
the period recorded. For any project, the activity may be one of many things, and the
activities may vary by project number.
I need to run a report and end up with a list of all the times reported, and totals by the
project number and the activity, as well as totals by Reporting individual, project
number, activity. I am having a little trouble with the activity piece, since you cant
predict the categories that will come up. I have tried pivot tables, but find that I have
to merge the pivot table back into the report using a spreadsheet (Excel), and that gets a
bit hairy round the edges. Before I end this madness, there may be one other category that
surfaces, but that's for the client to determine. Right now I am trying to figure out the
architectures for a solution, then I will execute the solution!
Anyone got any suggestions?
Totals would be
Project
Activity
and
Employee
Project
Activity
Regards
John Baker
3  2108 
Had what I think was a similar problem with an unknown number of races in a
series of races and needed to produce a report with a column for the
position of the boat in each race.
The basis of the solution is a temporary crosstab query programatically .
This will include all your unknown nunber of categories.
Then, again programatticall y you can check what columns there are in your
temporary query and create a report with the position of each column
positioned to the right of the previous column.
It's a lot of coding, but it works OK
The code for creating the crosstab query is so specific that it is not worth
sending, but if you want, I will send you the code for creating the report,
which again is specific but could be doctored (butchered would be closer)
Phil
"John Baker" <Ba******@Veriz on.net> wrote in message
news:ls******** *************** *********@4ax.c om... Hi:
I have a situation where I have a series of time records (one or more per
day) for a number of projects. Each record has an identification for the activity
conducted during the period recorded. For any project, the activity may be one of many
things, and the activities may vary by project number.
I need to run a report and end up with a list of all the times reported,
and totals by the project number and the activity, as well as totals by Reporting
individual, project number, activity. I am having a little trouble with the activity piece,
since you cant predict the categories that will come up. I have tried pivot tables, but
find that I have to merge the pivot table back into the report using a spreadsheet (Excel),
and that gets a bit hairy round the edges. Before I end this madness, there may be one
other category that surfaces, but that's for the client to determine. Right now I am trying to
figure out the architectures for a solution, then I will execute the solution!
Anyone got any suggestions?
Totals would be
Project
Activity
and
Employee
Project
Activity
Regards
John Baker
Phil:
Thanks a lot.
I am a bit of a neophyte in Access and any help is much appreciated. If you could send the
code it would be great.It would give me some sense of direction as I try and tackle his
issue. Were you able to roll the whole thing back into an Access report, or did you end up
using Excel to produce the final document?
Regards
John Baker
"Phil Stanton" <ph**@stantonfa mily.co.uk> wrote: Had what I think was a similar problem with an unknown number of races in a
series of races and needed to produce a report with a column for the
position of the boat in each race.
The basis of the solution is a temporary crosstab query programatically .
This will include all your unknown nunber of categories.
Then, again programatticall y you can check what columns there are in your
temporary query and create a report with the position of each column
positioned to the right of the previous column.
It's a lot of coding, but it works OK
The code for creating the crosstab query is so specific that it is not worth
sending, but if you want, I will send you the code for creating the report,
which again is specific but could be doctored (butchered would be closer)
Phil
"John Baker" <Ba******@Veriz on.net> wrote in message
news:ls******* *************** **********@4ax. com... Hi:
I have a situation where I have a series of time records (one or more per
day) for a number of projects. Each record has an identification for the activity
conducted during the period recorded. For any project, the activity may be one of many
things, and the activities may vary by project number.
I need to run a report and end up with a list of all the times reported,
and totals by the project number and the activity, as well as totals by Reporting
individual, project number, activity. I am having a little trouble with the activity piece,
since you cant predict the categories that will come up. I have tried pivot tables, but
find that I have to merge the pivot table back into the report using a spreadsheet (Excel),
and that gets a bit hairy round the edges. Before I end this madness, there may be one
other category that surfaces, but that's for the client to determine. Right now I am trying to
figure out the architectures for a solution, then I will execute the solution!
Anyone got any suggestions?
Totals would be
Project
Activity
and
Employee
Project
Activity
Regards
John Baker
I just finished a payroll db w/ similar situation. Reports with the
job category and with employees hours depicted.
In Reports I had to "Group by" job code and then "group by"
employees(I used first name of employee). In the details the name and
hours worked by employees.
In the group number footer is where I put the first sum equation for
job number totals to appear. Then a second sum total in the first name
footer. In the end you get two totals. One total for the job number
each employee worked for the time period specified and another total
combining all the job numbers combined. I also created a report
summarizing all the job numbers with all the total for that time
period specified as well. Hope I helped.
John Baker <Ba******@Veriz on.net> wrote in message news:<ls******* *************** **********@4ax. com>... Hi:
I have a situation where I have a series of time records (one or more per day) for a
number of projects. Each record has an identification for the activity conducted during
the period recorded. For any project, the activity may be one of many things, and the
activities may vary by project number.
I need to run a report and end up with a list of all the times reported, and totals by the
project number and the activity, as well as totals by Reporting individual, project
number, activity. I am having a little trouble with the activity piece, since you cant
predict the categories that will come up. I have tried pivot tables, but find that I have
to merge the pivot table back into the report using a spreadsheet (Excel), and that gets a
bit hairy round the edges. Before I end this madness, there may be one other category that
surfaces, but that's for the client to determine. Right now I am trying to figure out the
architectures for a solution, then I will execute the solution!
Anyone got any suggestions?
Totals would be
Project
Activity
and
Employee
Project
Activity
Regards
John Baker This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Scott |
last post by:
How can you show SUBTOTALS in the same column as the data, NOT in a
separate column?
I need to SUBTOTAL in the same column as one of the the data columns,
like the subtotals 700 and 800 under Field 3 below (I really have 21
columns). Also I must show one blank row after each resulting group:
Field1 Field2 Field3 Field4
entry1 data2.1 100 data4.1
entry2 data2.2 400 data4.2
|
by: Andy V |
last post by:
Hi. I've got a multi page report of my monthly purchases. I'd like a running
total (month to date) at the end of each page and to have that total at the
top of the following page. So far all I can figure out is a grand total at
the end of the entire report!
Any suggestions? Thanks.
|
by: vashwath |
last post by:
Might be off topic but I don't know where to post this question.Hope
some body clears my doubt.
The coding standard of the project which I am working on say's not to
use malloc.When I asked my lead(I have just started working) he said we
should not use dynamic allocation in real time systems, the code will
not run in predictable time period.Can anybody tell what does he
mean?Why the execution time becomes unpredictable?
Thanks
|
by: javatopia |
last post by:
Hello,
I am trying to show a Crystal Reports 10 Enterprise report in an ASP.NET
page (C#). I can run the report via the admin console just fine. When I try
to show the report, after setting up its parameters, I get:
"Value does not fall within the expected range."
How are people interacting with the Crystal Report viewer to set the
parameters on a report? I haven't found any useful documentation at
|
by: Jerry LeVan |
last post by:
Is is possible, via some clever sql coding ( perhaps with PL/pgsql)
to get subtotals to appear in a selection, ie
If I have a query: select * from checks order by category
I would like the have the subtotals appear (possibly in
an unused column for each "category" when the category
"breaks".
Basically I would like to meld the query:
select category, sum(amount) from checks group by category order by
| | |
by: Greg |
last post by:
I have a database that tracks the vacation time of each employee of the
company that I work for. Everything works great and totals all of the
vacation time that has been used. Could someone give me a little
guidance on how I could get a subtotal for each employee and then total
all of the subtotals? I would like to list employee 1's time and total
it, then employee 2's time and total it and so on. Then total all of
the subtotals. Not sure...
|
by: xian2 |
last post by:
Hi,
I have two subreports on my report and they both have a subtotal in the subreport footer section.
I have managed to work out how to call the subtotals in to the main form:
=!!..
=!!..
|
by: Paul Ilacqua |
last post by:
I'm using VB .NET and I'm trying to "roll my own" report subtotals. I'm
building a string from a datareader top pass to a reporting class and I want
to break and subtotal QTY at each change in shipper and I have struggled
with the code to do so for days and just can't seem to get it. I can get it
to insert a draw a line at a shipper change, but I can't get the subtotals.
The actual Code is down below data sample. I appreciate any advice I...
|
by: =?Utf-8?B?SHV0dHk=?= |
last post by:
I have searched the net but have been unable to find a solution to
subtotaling in a gridview. I have a gridview that is bounded to sqldatasource
where I would like to subtotal rows throughout the gridview based on column
value "Type". I am using VB.NET. Thanks.
--
Hutty
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
