query regarding Crosstab report 
Author Message
 query regarding Crosstab report

hi,

I have a report which IS grouped by region and each region has a cross
tab report between nationality and organization.The value is the count
of cases approved in each nation and assigned to organization and also
the count of members in each approved case(NO.OF CASES/sum(no.of ppl
in each case))...see report format below.

can someone tell me how i should go abt doing this report...how do i
use crosstab report in this case.I am using Crystal Reports in this
case.

thanks in advance
Vidya.

Region 2
---------                                               (SUMMARY FLDS)
        Organization  SAA    MNB      CRX      LDD    Monthly Yearto
Nationality                                                   DATE
INDIA                1/3    5/12     11/21    3/7    20/43   20/43    
CHINA                5/7    2/3      5/12     4/5    16/27   17/30
JAPAN                2/4    3/4      2/5      6/9    13/22   15/25

Monthly (SUM)         8/14   10/19    18/38    13/21
Year to date(SUM)     10/20  12/25    22/45    15/30          52/120

Region 2
---------                                               (SUMMARY FLDS)
        Organization  SAA    MNB      CRX      LDD    Monthly Yearto
Nationality                                                   DATE
fRANCE                1/3    5/12     11/21    3/7    20/43   20/43
KOREA                 5/7    2/3      5/12     4/5    16/27   17/30
NEPAL                 2/4    3/4      2/5      6/9    13/22   15/25

Monthly (SUM)         8/14   10/19    18/38    13/21
Year to date(SUM)     10/20  12/25    22/45    15/30          52/120



Thu, 14 Oct 2004 22:38:41 GMT  
 query regarding Crosstab report
Hello Vidya,

If u r using SQL server, the best thing wud be to write a stored
procedure and dump the values into a temporary table, using the
sequence fields.

For e.g.

Table name: TMP_MANISH

FIX_SEQ1   FIX_NAT    FIX_SEQ2     FIX_ORG     FIX_VALUE
   1        INDIA         1         SAA           1/3
   1        INDIA         2         MNB           5/12
   1        INDIA         3         CRX           11/21

and so on.....

The sequencing will help u in printing of the report in the organized
manner
Using this table in a cross-tab crystal will help u in getting the
desired output.

With warm regards,
Manish

Quote:

> hi,

> I have a report which IS grouped by region and each region has a cross
> tab report between nationality and organization.The value is the count
> of cases approved in each nation and assigned to organization and also
> the count of members in each approved case(NO.OF CASES/sum(no.of ppl
> in each case))...see report format below.

> can someone tell me how i should go abt doing this report...how do i
> use crosstab report in this case.I am using crystal reports in this
> case.

> thanks in advance
> Vidya.

> Region 2
> ---------                                               (SUMMARY FLDS)
>         Organization  SAA    MNB      CRX      LDD    Monthly Yearto
> Nationality                                                   DATE
> INDIA                1/3    5/12     11/21    3/7    20/43   20/43    
> CHINA                5/7    2/3      5/12     4/5    16/27   17/30
> JAPAN                2/4    3/4      2/5      6/9    13/22   15/25

> Monthly (SUM)         8/14   10/19    18/38    13/21
> Year to date(SUM)     10/20  12/25    22/45    15/30          52/120

> Region 2
> ---------                                               (SUMMARY FLDS)
>         Organization  SAA    MNB      CRX      LDD    Monthly Yearto
> Nationality                                                   DATE
> fRANCE                1/3    5/12     11/21    3/7    20/43   20/43
> KOREA                 5/7    2/3      5/12     4/5    16/27   17/30
> NEPAL                 2/4    3/4      2/5      6/9    13/22   15/25

> Monthly (SUM)         8/14   10/19    18/38    13/21
> Year to date(SUM)     10/20  12/25    22/45    15/30          52/120



Tue, 19 Oct 2004 17:56:17 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. report based on a crosstab query

2. report based on a crosstab query

3. Crosstab Query for Report

4. dynamic report formatting from crosstab queries??

5. Crosstab Query/Conversion/Report Generation...

6. multiple queries into a crosstab query in VB

7. multiple queries into a crosstab query in VB

8. Crystal Report : CrossTab Report

9. VBA for crosstab query

10. Opening a CrossTab query via QueryDef.OpenRecordset

11. Crosstab Query

12. Sort or limit row displayed in a crosstab query

 

 
Powered by phpBB® Forum Software