Isaac
asked on
Sub Report not appearing
Hello,
I have a report with sub reports in it.
When I run the report, some of the sub reports show and some don't.
Does anyone know why they are not showing? They used to show.
Thanks.
I have a report with sub reports in it.
When I run the report, some of the sub reports show and some don't.
Does anyone know why they are not showing? They used to show.
Thanks.
ASKER
There is data returned outside of CR and the subreports are not suppressed or hidden.
I can't even see plain text that is in my sub report.
I can't even see plain text that is in my sub report.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok. Now I see my Report Header Text but not my details.
I think I might be linking wrong. It's linked as an inner join.
I have 2 tables and one of them is a look up table. see below:
SAMPLE:
HL_sup_tbl & HL_sup_LU
HL_sup_tbl
---------------
ID SUP_TYPE_ID NAME FROM
-------------------------- ---------- ---------- ---------- ---------
1 2 JOHN ARGENTINA
2 1 ANN CHINA
3 3 KIM AFRICA
HL_sup_LU
---------------
SUPP_TYPE_ID SUPP_TYPE
-------------------------- ---------- ---------- ----
1 A
2 B
3 C
In my report I want to show
SUB_TYPE NAME FROM
B JOHN ARGENTINA
A ANN CHINA
C KIM AFRICA
I think I might be linking wrong. It's linked as an inner join.
I have 2 tables and one of them is a look up table. see below:
SAMPLE:
HL_sup_tbl & HL_sup_LU
HL_sup_tbl
---------------
ID SUP_TYPE_ID NAME FROM
--------------------------
1 2 JOHN ARGENTINA
2 1 ANN CHINA
3 3 KIM AFRICA
HL_sup_LU
---------------
SUPP_TYPE_ID SUPP_TYPE
--------------------------
1 A
2 B
3 C
In my report I want to show
SUB_TYPE NAME FROM
B JOHN ARGENTINA
A ANN CHINA
C KIM AFRICA
Would it be possible to post your report? If not, can you send a screen shot of the Subreport links screen?
Are the two tables you show here both in your subreport only?
What you show above looks like it would be okay for a INNER JOIN - all the SUP_TYPE_ID values from HL_sub_tbl exist in HL_sub_LU.
The subreport link should be set from HL_sub_tbl.SUP_TYPE_ID = HL_Sup_LU.SUPP_TYPE_ID
If you only have these two tables, perhaps you don't need the subreport at all, and could add the second table to the main report.
Are the two tables you show here both in your subreport only?
What you show above looks like it would be okay for a INNER JOIN - all the SUP_TYPE_ID values from HL_sub_tbl exist in HL_sub_LU.
The subreport link should be set from HL_sub_tbl.SUP_TYPE_ID = HL_Sup_LU.SUPP_TYPE_ID
If you only have these two tables, perhaps you don't need the subreport at all, and could add the second table to the main report.
ASKER
I see part of the problem.
In one of the columns, when I concatenate to fields using the Formula Editor, if one of the concatenating fields is blank it does not show in the report.
Ex: I want to capture full name in a report but if first name is blank and last name is not, "FULLNAME " will show up blank on the report.
FULLNAME defined as
{HL_SUBJECT_TBL.LAST_NAME} & ', ' & {HL_SUBJECT_TBL.FIRST_NAME }
How can I fix this? I want the FULLNAME show even if one of the names is blank.
In one of the columns, when I concatenate to fields using the Formula Editor, if one of the concatenating fields is blank it does not show in the report.
Ex: I want to capture full name in a report but if first name is blank and last name is not, "FULLNAME " will show up blank on the report.
FULLNAME defined as
{HL_SUBJECT_TBL.LAST_NAME}
How can I fix this? I want the FULLNAME show even if one of the names is blank.
I suspect you have NULL values in the name fields, not empty strings. The easiest way to handle this is to do the following:
Select File, then Report Options from the drop down menu. Check the box "Convert Database NULL Values to Default", and click OK.
Select File, then Report Options from the drop down menu. Check the box "Convert Database NULL Values to Default", and click OK.
Have you tried running the queries outside of Crystal to see if they return data?
A few things to check:
Make sure the subreports are not suppressed or hidden.
Make sure the joins are correct in the subreport - do you need LEFT OUTER instead of INNER?
Are the subquery links correct? Right click on the sub report, an select "Change subreport links". These can get lost when editing the subreport.