• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

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.
0
Isaac
Asked:
Isaac
  • 4
  • 3
1 Solution
 
kenwagersCommented:
Have you checked the underlying data to make sure that there is data that would be in the subreport?  

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.
0
 
IsaacSharePoint Client Side DeveloperAuthor Commented:
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.
0
 
kenwagersCommented:
Did you check the subreport links?  

You could try exporting the subreport, and then importing it back in.

Right click on the subreport, and select "Save Subreport As".

Then delete the subreport, and reinsert it by selecting "Insert / Subreport" from the drop down menus.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
IsaacSharePoint Client Side DeveloperAuthor Commented:
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
0
 
kenwagersCommented:
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.
0
 
IsaacSharePoint Client Side DeveloperAuthor Commented:
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.
0
 
kenwagersCommented:
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.


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now