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.
LVL 5
IsaacSharePoint Client Side DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.