Hi,
It's me again :-)
Just wondering if its possible to create one report using the output of two or more SQL Querries.
Currently i've got two SQL querries. one generates the total number of graduate students for the year (SQLGrad) and the other number of graduate students per course per year (SQLGradcourse). Now, what i want to happen (if possible) is that once i clicked the report button it will generate in just one page both the results of the two querries.
Is this possible? Any help on this matter is greatly appreciated.
Cheers,
Jacko7289
3 1926
Hi,
It's me again :-)
Just wondering if its possible to create one report using the output of two or more SQL Querries.
Currently i've got two SQL querries. one generates the total number of graduate students for the year (SQLGrad) and the other number of graduate students per course per year (SQLGradcourse). Now, what i want to happen (if possible) is that once i clicked the report button it will generate in just one page both the results of the two querries.
Is this possible? Any help on this matter is greatly appreciated.
Cheers,
Jacko7289
You can create a sub report in the main report. This is just an idea between much more. But to me I find it fine.
Abolos
I can't make it (Creating sub-report) work using the report design wizard . I got this essage..."You have chosen fields from record sources which the wizard can't connect".
Anyway here are my SQL's which i want to be reported in just one page.
SQL 1
Select DISTINCT CompletionYear, COUNT(*)
From Student
Where CompletionYear in ('2004','2005','2006','2007')
Group By CompletionYear;
SQL 2
Select DISTINCT Course, COUNT(*)
From Student
Where CompletionYear in ('2004','2005','2006','2007')
Group By Course;
Maybe i don't do it correctly. Any suggestion woul be greatly appreciated.
Cheers,
Jacko7289
Firstly you will need to return and group by CompletionYear in the second query as well if you want the number of students per course, per year. -
Select DISTINCT Course, COUNT(*), CompletionYear
-
From Student
-
Where CompletionYear in ('2004','2005','2006','2007')
-
Group By Course, CompletionYear;
-
Also try running both queries in the query window to make sure they are working properly.
Now create a report based on the first query. Create a group by level for CompletionYear
Now when you create the subreport (in the detail section) using the wizard make sure you join on CompletionYear.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Helen |
last post by:
Hi, I'm using
VB .NET (Visual Studio 2002
Crystal Reports 9 (soon to upgrade to 10, just want 9 to work first
Win 200
When I run the crystal report independently, I can access the Oracle 7.3.4...
|
by: Chris F Clark |
last post by:
In our C++ project we have some internal bug reporting macros that we
use to get useful information when the program does something
unexpected. Essentially at the point of the error, we invoke an...
|
by: Oreo Bomb |
last post by:
I have a secured database that contains a Read-Only group. This group
has permissions to view reports, but cannot add, edit, or delete any
DB objects. One of the reports the group needs access to...
|
by: Richard Holliingsworth |
last post by:
Hello:
Thanks for reading this. We just converted to A2002 and some of my
querries have stopped working and I can't figure out why.
Basically, anything with a "NOT" is not working.
For...
|
by: M |
last post by:
Hi all,
I am having problems figuring out the best way to query my database in
order to create a report. Perhaps someone can help me?
Background --
Consider a table with the following...
|
by: Abby |
last post by:
I'm now using Cygwin as my compiler for C code. I use Dev-c++ as my
editor.
The reason why I chose Cygwin compiler instead of the compiler that
came with Dev-C++ is that I believe it uses the same...
|
by: scottyman |
last post by:
I can't make this script work properly. I've gone as far as I can with
it and the rest is out of my ability. I can do some html editing but
I'm lost in the Java world. The script at the bottom of...
|
by: Niyazi |
last post by:
Hi
I have a report that I have to run it monthly in my machine.
My code in VB.NET and I access AS400 to get data, anaysie it and send into
pre formated Excel sheet. The data consist of 9000...
|
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ |
last post by:
I have created a report. This report needs to display records
between two dates entered by the user. I put two text boxes on the
report so I can enter the start and end date - I set them to use an...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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,...
|
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...
|
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...
| |