Three queries into one report? 
Author Message
 Three queries into one report?

Hi,

I have three queries that each contain a Date and a Product Field, with the
remaining fields being different in each.  I need to select records from the
queries based on the Date and Product values and group them together in a
report.  It should look like this:

Product 1
    Date1
        Query1 info
        Query2 info
        Query3 info

    Date2
        Query1 info
        Query2 info
        Query3 info

Product 2
    Date1
        Query1 info
        Query2 info
        Query3 info
                                       etc.....

Getting the information from only one query into a report is not problem,
but I'm not sure how to combine all three queries into one report.  Is there
a way to weave all of this together, or will I have to settle for different
reports for each query?  Or is there a way to combine all three queries,
even though they contain dissimilar fields?  Thanks in advance,

Sean Marsell



Mon, 06 Jan 2003 03:00:00 GMT  
 Three queries into one report?
One option is to use subreports in your report.

Read online help on "Create a subreport".  After that, if you're still stuck
come back and ask specific questions to help you through the process.

Quote:

> Hi,

> I have three queries that each contain a Date and a Product Field, with the
> remaining fields being different in each.  I need to select records from the
> queries based on the Date and Product values and group them together in a
> report.  It should look like this:

> Product 1
>     Date1
>         Query1 info
>         Query2 info
>         Query3 info

>     Date2
>         Query1 info
>         Query2 info
>         Query3 info

> Product 2
>     Date1
>         Query1 info
>         Query2 info
>         Query3 info
>                                        etc.....

> Getting the information from only one query into a report is not problem,
> but I'm not sure how to combine all three queries into one report.  Is there
> a way to weave all of this together, or will I have to settle for different
> reports for each query?  Or is there a way to combine all three queries,
> even though they contain dissimilar fields?  Thanks in advance,

> Sean Marsell



Mon, 06 Jan 2003 03:00:00 GMT  
 Three queries into one report?
It looks like using subreports should do what I need.  But I'm having a
problem with them.  I'm trying to display three subforms in the detail
section of the main form.  The first two work fine, but the third one only
displays the label for the third subform.  I've tried resizing it, deleting
and reinserting it, making sure the relationships are set...but it's not
working.  When I open the problematic subform on its own everything is
displayed.  Any ideas about what might be wrong?

Sean Marsell

Quote:

>One option is to use subreports in your report.

>Read online help on "Create a subreport".  After that, if you're still
stuck
>come back and ask specific questions to help you through the process.


>> Hi,

>> I have three queries that each contain a Date and a Product Field, with
the
>> remaining fields being different in each.  I need to select records from
the
>> queries based on the Date and Product values and group them together in a
>> report.  It should look like this:

>> Product 1
>>     Date1
>>         Query1 info
>>         Query2 info
>>         Query3 info

>>     Date2
>>         Query1 info
>>         Query2 info
>>         Query3 info

>> Product 2
>>     Date1
>>         Query1 info
>>         Query2 info
>>         Query3 info
>>                                        etc.....

>> Getting the information from only one query into a report is not problem,
>> but I'm not sure how to combine all three queries into one report.  Is
there
>> a way to weave all of this together, or will I have to settle for
different
>> reports for each query?  Or is there a way to combine all three queries,
>> even though they contain dissimilar fields?  Thanks in advance,

>> Sean Marsell



Mon, 06 Jan 2003 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Three Different reports in one?

2. queries x 2 into one report

3. More than one query in a Crystal Report

4. Crystal Report Query can only find one of several MS Access records

5. Combining two or three fields into one?

6. three data controls (updating one from another)

7. simple beginners exercise/one-to-many form, three tables

8. Merging three dbases into one

9. Any easy way to convert 123 to One hundred and twenty-three in Vb5

10. Find next para that is one of three styles

11. Viewing desigs of three forms in one .vb file

12. Viewing desigs of three forms in one .vb file

 

 
Powered by phpBB® Forum Software