More discussions in SAP Business One ApplicationWhere is place located?
    4 Replies Latest reply: Jul 14, 2012 4:25 PM by Edwin Anderson RSS

    Crystal Report Import Problem

    Edwin Anderson
    Edwin Anderson
    Jul 12, 2012 12:17 AM
    Currently Being Moderated

    Good Afternoon experts!

     

     

    One of our customer is having problems importing Crystal reports into the SBO.

    The report were develop by the customer itself.

    Using the Report and Layout Import wizard, everything is done normally, but when they click Finish, the report could not be imported. As shown in the image. The thing is, this happens for every single report the try to import.

    I'd like to know, why a report fails to import? is it the Data source or something else? Up unitl now, i haven't seen any report failing to import.

    But when the previsualize it, it runs without any problem, error or anything.

    They just cannot import it.

    Any ideas

    SAP Version 8.8 PL 17

     

    Untitled.png

     

    Thank you very much!!

     

    Regards,

    Edwin.

    • Re: Crystal Report Import Problem
      John-Michael Davis
      John-Michael Davis Jul 12, 2012 1:08 AM (in response to Edwin Anderson)
      Currently Being Moderated

      Hey Edwin,

       

      Unfortunately I don't know a good way to check the reason for failure, you can however attempt to import straight from Crystal in B1 using the Crystal add-in --> Save as function. You just need to make sure you are logged in to the right database and save your report into B1.

       

      I hope that helps,

      jmsignature.png

    • Re: Crystal Report Import Problem
      Jimmy Michael
      Jimmy Michael Jul 12, 2012 3:32 AM (in response to Edwin Anderson)
      Currently Being Moderated

      Hi,

       

       

      You can try to remove all temporary crystal report files from %temp% folder at first. After deleting them, try to import it again.

       

      I always experience this problem especially when I import the crystal report after editing or enhancing the report.

      When I import into another folder or import directly into document report e.g. a/r invoice, it succeeded. I always try and try to import it but always failed. I try to remove the CR files from temporary folder, it is sometimes successful.

       

      Another solution is use the solution part of this sap note belows:

       

      1532509  - Cannot import Crystal Report template into SAP Business One    
      Version   2   Validity: 03.05.2012 - active
      Language   English 
          

      Content:      Summary    |    Header Data    |    References    |    Validity 

       

       

      Symptom

      Cannot import Crystal Report templates into SAP Business One.


       

      Cause

      Consulting


       

      Solution

      Please run the below query and if it returns results please log a support message via SAP Service Marketplace, and attach the results of the query.

       

      select * from CDPM where ObjectType = 232 and ObjectKey not in (select doccode from rdoc) order by permid

       

      Select * from USR3 where PermId
      not in (Select distinct Absid from OUPT union Select distinct cast(PermId as nvarchar(50) )from CDPM)

       

       


       

      Other terms

      SBO,B1,CR,Crystal report,import


         
             

      Header Data

        
      Released On 03.05.2012 08:11:01   
      Release Status Released for Customer   
      Component SBO-REP-CR Crystal Reports for SAP Business One   
      Priority   Correction with medium priority   
      Category   Consulting   
        
            

      References

      This document refers to:

        SAP Business One Notes
      1402322 Overview for notes released in PEQ wiki

      This document is referenced by:

         SAP Business One Notes (1) 
        1402322   Overview for notes released in PEQ wiki
         
          
            

      Validity

      Software Component

      Version

      SAP BUSINESS ONE

      8.8

      8.81

      8.82

          

       

       

      The solution is prepared or provided by SAP Support. So, you run the query of  the note and then raise a  ticket to sap support with query result attachment.

       

       

      JM

    • Re: Crystal Report Import Problem
      Edwin Anderson
      Edwin Anderson Jul 14, 2012 4:25 PM (in response to Edwin Anderson)
      Currently Being Moderated

      Thank you very much Micheal.

      Exactly, using the Save As option in Crystal, worked just well.

      Thank you everyone for all of the answers.

      They are quite helpful for future references.

      Thank you very much!!

    Actions

    Incoming Links