Solved

rePORTAL Not Printing Crystal Formula Fields

Posted on 2014-09-04
10
352 Views
Last Modified: 2014-09-10
A report I created using Crystal runs well in Crystal but when running it via rePORTAL (Shahrabani + Associates), none of my formula fields will print. See image below for example...

http://s32.photobucket.com/user/tompreston75/media/rePortal_zps1a9fa759.jpg.html 

Any ideas as to what may be causing this?
0
Comment
Question by:Bad_Fish
  • 5
  • 4
10 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40304238
No idea.

Have you checked the rePortal site for help?
I looked at their site but I don't see any FAQ or HELP options.

What are the formulas in question?

mlmcc
0
 

Author Comment

by:Bad_Fish
ID: 40304257
Yes...I found an infrequently used forum and posted the same question there. However, based on the time between posts, I don't expect to hear anything soon.

For documentation purposes; if anyone else needs the rePORTAL forum it can be bound at http://forums.reportalsoftware.com. You must enter the following credentials for initial access...

Username: forumuser
Password: reportal12

...after that, users can register with their chosen username.

As for the formulas; they are quite simple. Here are all four...

1) {AZInvoiceDetail.azid_UnitPrice}*{AZInvoiceDetail.azid_QtyInvoiced}

2) {AZInvoiceDetail.azid_UnitCost}*{AZInvoiceDetail.azid_QtyInvoiced}

3) ({AZInvoiceDetail.azid_QtyInvoiced}*{AZInvoiceDetail.azid_UnitPrice})-({AZInvoiceDetail.azid_QtyInvoiced}*{AZInvoiceDetail.azid_UnitCost})

4) ((({AZInvoiceDetail.azid_UnitPrice}-{AZInvoiceDetail.azid_UnitCost})/{AZInvoiceDetail.azid_UnitPrice})*100)

Each formula is in a conditional statement. For example, the full formula for #1 above is...

if isnull({AZInvoiceDetail.azid_UnitPrice}) then
    0
else
    {AZInvoiceDetail.azid_UnitPrice}*{AZInvoiceDetail.azid_QtyInvoiced}

...but that shouldn't matter.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40304563
As best I can tell, rePortal is just a viewer/portal and doesn't change the report in any way.  DO you know if that is true?

I don't see anything in the formulas that jumps out as an issue.

mlmcc
0
 

Author Comment

by:Bad_Fish
ID: 40304705
Reportal is used in conjunction with Sage CRM and I don't believe that it changes the report...but it runs in Crystal and not in rePortal...so maybe it does.

I'm working with the author now so I'll report back with the solution.
0
 
LVL 34

Expert Comment

by:James0628
ID: 40305545
FWIW, the full formula that you posted checks to see if azid_UnitPrice is null, but it doesn't check azid_QtyInvoiced.  If azid_QtyInvoiced was null (and you're not converting database null values to default values), the formula wouldn't show.  And your first 3 formulas use azid_QtyInvoiced, so a null field could explain those.  OTOH, the 4th calculation doesn't use it, so it wouldn't seem to explain that one.

 IAC, it would be easy enough to change the first formula to check azid_QtyInvoiced for nulls too, and see if you get 0's on the report.

 James

if isnull({AZInvoiceDetail.azid_UnitPrice}) or IsNull ({AZInvoiceDetail.azid_QtyInvoiced}) then
     0
 else
     {AZInvoiceDetail.azid_UnitPrice}*{AZInvoiceDetail.azid_QtyInvoiced}

Open in new window

0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 100

Expert Comment

by:mlmcc
ID: 40305764
In looking at his image of the report the one shows data for the formulas but the other doesn't.  Assuming it is the same report and data there is an issue with rePortal.

mlmcc
0
 

Accepted Solution

by:
Bad_Fish earned 0 total points
ID: 40306403
Updating to the latest Acrobat product solved this problem.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40306467
Did the "working" version have a newer Acrobat?

mlmcc
0
 

Author Comment

by:Bad_Fish
ID: 40306500
The new version of Acrobat solved it.
0
 

Author Closing Comment

by:Bad_Fish
ID: 40314023
In the course of attempting to resolve this problem, I updated my computer to the latest version of Acrobat. That solved the problem.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now