running access 2k;
I have some stats (bowling) that I want to print in columns on a
report.
The top portion of the report will have a team-members name, and the
bottom of the report will have a
sub-report that presents the stats in UP-TO 4 columns.
Here's how it works (in concept):
a team may have 2 to 5 people; not everyone on the team bowls each
week.
So - I want to produce a report that shows up to 4 columns - ONLY the
most current 4 days (TOP 4).
It will look something like this:
NAME 3/1/05 3/8/05 3/14/05 3/20/05
_______________ _______________ _______________ _______________ __
Mary 465 397 525
Harry 592 604 575 602
Jerry 418 427
Gary 214 397 255 327
Larry 601 650 647 599
all of the names [which don't change] are actually on the master report
- only the dates are in the
sub-report.
Here's how the data is structured in tables:
BOWLER BOWL_DAYS BOWL_DATA
b_key (key) b_key (k) b_key (k)
name bdate (k) bdate (k)
score (k)
Now - the organization of the data is set in stone - I've VASTLY
simplified the concept. So the real question is how to do this report.
I've tried everything I can think of:
cross tab queries; queries FROM crosstab Q's; cross tab queries from a
"TOP 4" query;
the sub-report formatted thusly: AND Thusly:
(header) (header)
[mary] [name]
[harry]
[jerry]
[gary]
[larry]
With the "[name]" version, I tried doing some fancy vb record/column
counting, so as to know when to "go to the next column".
Nothing I've tried works right, and/or is error free!
What's the best way to accomplish such a report from the given data
organization?
TIA!!
Ned 2 1397
I noticed you tried doing a crosstab query from a Top4 query, but have
you tried doing a Top4 query on the crosstab?
If you are looking at having multiple teams, you'll need to include
that as your a part of your crosstab, and using that field as a part of
the Top4's selection criteria. ns*@starnetwx.n et wrote: running access 2k; I have some stats (bowling) that I want to print in columns on a report. The top portion of the report will have a team-members name, and the bottom of the report will have a sub-report that presents the stats in UP-TO 4 columns. Here's how it works (in concept): a team may have 2 to 5 people; not everyone on the team bowls each week. So - I want to produce a report that shows up to 4 columns - ONLY the most current 4 days (TOP 4). It will look something like this: NAME 3/1/05 3/8/05 3/14/05 3/20/05 _______________ _______________ _______________ _______________ __ Mary 465 397 525 Harry 592 604 575 602 Jerry 418 427 Gary 214 397 255 327 Larry 601 650 647 599 all of the names [which don't change] are actually on the master report - only the dates are in the sub-report. Here's how the data is structured in tables: BOWLER BOWL_DAYS BOWL_DATA b_key (key) b_key (k) b_key (k) name bdate (k) bdate (k) score (k) Now - the organization of the data is set in stone - I've VASTLY simplified the concept. So the real question is how to do this report. I've tried everything I can think of: cross tab queries; queries FROM crosstab Q's; cross tab queries from a "TOP 4" query; the sub-report formatted thusly: AND Thusly: (header) (header) [mary] [name] [harry] [jerry] [gary] [larry] With the "[name]" version, I tried doing some fancy vb record/column counting, so as to know when to "go to the next column". Nothing I've tried works right, and/or is error free! What's the best way to accomplish such a report from the given data organization?
hi Chuck,
Tx much for your reply;
I have not tried reversing the top4/Xtab relationship - would that
really make a difference?
I'll have to check into that....
Right now, I'm only reporting on 1 team - but in the future I expect to
expand that; as well as have the ability to add additional members to
the 1 team (right now it's fixed).
I'll check out reversing - TX....
Ned This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Helmut Jarausch |
last post by:
Hi,
according to the docs the following should work (IMHO)
import csv
csv_file= file('test.csv')
Inp= csv.DictReader(csv_file,,\
lineterminator='\n')
|
by: George Hardy IV |
last post by:
Hello,
I have a main project that contained a report form and a report selection
form. I would like to break this out into a satellite assembly, but am
getting strange errors when I include the new project in my solution.
Dim crTableLogonInfo As New TableLogOnInfo
Dim crTable As Table
For Each crTable In rpt.Database.Tables
crTableLogonInfo = crTable.LogOnInfo
crTableLogonInfo.ConnectionInfo = ci
|
by: Vlady |
last post by:
Hello. I recently built an ASP.NET "financial" application. I got to the
point where I have a HTML template (a contract) which needs to be filled with
various data from the database. I put a "generate contract" button on my ASPX
page, but I totally lack ideas of how to put the data in the correct places
in the html file. I was recommended (actually "do like this" from my boss) to
enclose the variable name like this {variable_name} in the...
|
by: Mark Harrison |
last post by:
HOWTO: Integrating Posgresql queries into an event loop.
Mark Harrison
mh@pixar.com
May 27, 2004
Problem
-------
The commonly used postgresql APIs will block until completed.
|
by: VB Programmer |
last post by:
Just loaded up one of my ASP.NET 2.0 projects. When I ran the webapp (IE)
I was warned with this message...
Your system may be vulnerable to BloodHound Virus! We recommend you DOWNLOAD
one of these security software programs to prevent malware infections...
Looked "spamish", so I didn't do anything as instructed above. Is this a
message from Microsoft? I'm up to date with Norton, have done a full system
scan, with no viruses...
| |
by: Igor |
last post by:
Hi all,
I've had these pages that I wrote in php that are used for executing varoius
queries. Query results are displayed as tables.
Since these tables can be pretty big I'like to give user some feedback while
queries are executing and rendering so I did the following:
- While rendering (iterating through query resultset) every N rows I'd
output a javascript command and then response.flush() to update user's
progress bar.
That way, a...
|
by: iThinkData |
last post by:
Should these 3 items, .Net 2.0 Website, SQLServer 2005, Reporting Services
2005. all reside on the same computer?
I know that the website issues a configuration error saying it can't find
certain assemblies listed in the <assemblies> section of the web.config file
(Microsoft.Reportviewer.Common, Microsoft.Reportviewer.ProcessingObjectModel,
Microsoft.Reportviewer.WebForms, ADODB) pertaining to the Reporting
Services. Also, Reporting...
|
by: Pieter |
last post by:
Hi,
For some procedures that throws exceptions, I would like to show different
messages to the user depending on what type of exception he's getting. For
instance this one: when the file is locked, I want a messagebox to tell that
the user has to close the file first.
Is there a way to identify an exception by some kind of unique number or
something like this? I don't want to identify it on the Exception Message
because some users are...
|
by: Cirene |
last post by:
I'm having some wierd paging issues with a gridview.
Here it is: http://www.gulfstreamonline.com/NonAuctions.aspx
Page 2 is empty
Page 3-5 have 1 item each
Any ideas why?
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |