web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Crystal Sub Report
Microsoft Dynamics SL (Archived)

Crystal Sub Report

(0) ShareShare
ReportReport
Posted on by Rich Mersinger 110

I added a Crystal sub report to a Project report, where the sub report is only printing the total expenses of the project.

When I look at the sub report the I can see the field and it has the correct amount.

 When I add it to the original report and run it, It prints the field and the correct amount for all record rows but the first row in the report.  Is there a way to force it to print on the first record row?

 

Thanks,

 Rich Mersinger

314 615-1271

*This post is locked for comments

I have the same question (0)
  • Richard Schultz Profile Picture
    Richard Schultz 1,085 on at

     Rich,

    The problem could arise from a number of issues.  Can you provide a bit more information, for example:

    What version of Crystal are you running?

    What section is the sub-report in?

    Is the sub-report linked on one or more-than-one column?

    Is the sub-report linked via a formula (ie not linked from one field to another, but from a field to a Crystal formula?)

    Does the link field in the main report have a value for that missing record?

    This is definitely odd, but it also should be fixable.  Have you submitted anything to Business Objects yet?  In case this is an obscure bug, you'll want to notify them early.

  • hassanvoyeau Profile Picture
    hassanvoyeau 580 on at

    I saw this on another forum suggesting that this is a CR issue with SL 6.5 SP1

    http://www.eggheadcafe.com/conversation.aspx?messageid=31065446&threadid=30929440

     

    Were you able to resolve the issue?

  • Rich Mersinger Profile Picture
    Rich Mersinger 110 on at

    I was not able to resolve it.  But the problem is occuring on a client running SL 6.5 SP1.

     

    Rich

  • hassanvoyeau Profile Picture
    hassanvoyeau 580 on at
    I was able to resolve the problem with my report by unchecking "Verify on First Refresh" from the subreport report options. File --> Report options. I discovered this after taking an original Solomon report with a subreport e.g. 10810.rpt and comparing it to my report. I usually start with a Solomon report when creating new reports for this same reason but I guess I didn't this time around :(. Any idea why this made a difference?
  • sunnyyun Profile Picture
    sunnyyun 5 on at

    Maybe you can try RAQ Report. It's a free excel-like reporting tool. You can get free User Manual - RAQ Report 4.0. You can easily learn to use it .And RAQ Report provides free reliable Doc, Demo, Forum, Email support.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans