Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Crystal 2011 Service pack 13

  • 1.  Crystal 2011 Service pack 13

    Posted 07-07-2020 16:18

    Hi Folks,

      I have a client that it getting a runtime error exporting to Excel.  The suggestion is to install the full version of Crystal (2011) and then Service Pack 13.  I am having a hard time finding it (I find SP 21 but the write up specifies 13 (ID:48564).    Any chance anyone has a copy?  Or does anyone know if SP 21 will fix the issue?

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     



  • 2.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 16:30
    Is it because they have a Parameter that is a numeric field?  Easier solution may be to change it to text and then convert to a number in the report.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 3.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 16:32
    Is it the sub-report issue?  Can you pass the value(s) to the main report using shared variables instead?

    CR patches should be cumulative.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 17:27

    Hi Kevin

      That is what is being done.  The subreport does not show on the report.   He is able to export using the data only format but it is very "messy" for their purpose.  

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     




    Original Message


  • 5.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 17:36
    Suppress Blank Sub-Report and Suppress Blank Section (assuming the sub-report is the only thing in the section) works well for me.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 6.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 18:10

    Hi Kevin,

      That is exactly the case here.  The sub report is to pull Multi Bin quantities (with bin filters) for an item and passed to the report with shared variables.  The fields on the sub report are suppressed and the lines on the sub report are set to suppress blank lines.  The sub report itself is set to suppress blank sub report and the section it is in is set to suppress blank section.    Pretty complex reporting being done here and we are actively looking into a better reporting solution for them.  Crystal does have its limits..

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     




    Original Message


  • 7.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 18:32
    Every section in the sub-report has to be suppressed or hidden.  Suppressing the fields is insufficient.
    Suppress sections in the sub-report that you don't use.
    Hide sections when you need CR to process something in that section (like your shared variables).
    When I've needed to do something similar in the past (with potentially multi-line output from the sub-report), I built a multi-line text value (in hidden sub-report sections) passed out to a main report formula using a Shared variable, so the sub-report has absolutely zero output (all sections suppressed or hidden).  Using this strategy, I have not had issues with exports to Excel.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 8.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 18:42
      |   view attached
    The attached quick report exports to Excel just fine for me, with mutli-line data from a sub-report.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Attachment(s)

    rpt
    SubReportToExcel.rpt   96 KB 1 version
    Original Message


  • 9.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 18:45

    Hi Kevin

      When I suppress the sections in the sub report with the shared variables, the values do not get passed to the main report in my experience.  I'll play around with it again to see if I can get it to pass the values when suppress.. 

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     




    Original Message


  • 10.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 18:46
    That is why you use Hide section instead of suppress section, in the sub-report.  See the example report I just uploaded.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 11.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 18:55

    HI Kevin,

      Good to know.  I have rarely used hide (just a matter of habit..).   I'll give it a shot and thanks much!

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     




    Original Message


  • 12.  RE: Crystal 2011 Service pack 13

    Posted 07-07-2020 18:59
    Hidden sections have to be processed so the results are available for drill-down, so Hide works well with this technique.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 13.  RE: Crystal 2011 Service pack 13

    Posted 07-08-2020 01:40

    HI Kevin,

      It did the trick!  Thanks much..   25+ years and learn something new everyday...

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     




    Original Message


  • 14.  RE: Crystal 2011 Service pack 13

    Posted 07-08-2020 08:29
    Kevin, 
    I've been looking for this solution too!  I notice there are three unsupressed blank lines when I export it to Excel.  Is it a matter of the export settings?  I saw the sections are set to suppress when blank.  Great idea to share the report with data saved, too!


    ------------------------------
    ==================
    Rhonda McNamara
    Customer Success Manager
    Stewart Technologies, Inc.
    rsm@stewarttechnologies.com
    ------------------------------

    Original Message


  • 15.  RE: Crystal 2011 Service pack 13

    Posted 07-08-2020 09:19


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 16.  RE: Crystal 2011 Service pack 13

    Posted 07-08-2020 11:05

    Hi Kevin

    Well I spoke too soon.   The user is still getting the error even with these changes.    So, I am back to looking for Service Pack 13 as it is repeated mentioned as a solution for this issue.

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     




    Original Message


  • 17.  RE: Crystal 2011 Service pack 13

    Posted 07-08-2020 11:11
    I think the runtime patch should come with v2018 workstation.  I've installed zero CR patches and it works for me on Win10.
    Are they running a really old version?  Was the workstation installed properly (UAC off, run as Admin...).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 18.  RE: Crystal 2011 Service pack 13

    Posted 07-08-2020 12:09
    If you can't get this to work AND you have some Access chops, create a DB using PTQ and SQRY tables.  Use the PTQ's (some may recommend linked tables) to link to Sage table.  Then create your SQRY to do the heavy lifting that Crystal would do.  Create Crystal to generate the report without involving sub reports for the client (or just set up Excel to Query access).  @Dan Burleson might even have a better way of using Access.  Put the DB on the server.  User does not need a copy of Access on local workstation.  Some of my Crystal reports run 10X faster using Access  You can also put the Crystal report on the Sage menu.  No one knows the difference. 

    Another trick for your toolbox.

    Below is a link to an ancient 90M webinar on PTQ's.  Audio starts around the 14 minute mark.  Technical difficulties in the early years......

    https://register.gotowebinar.com/recording/8562381197547797506
    ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 19.  RE: Crystal 2011 Service pack 13

    Posted 07-09-2020 01:46

    Hi Jeff,

      Long term they need something like this but much more than an "ad hoc" version.  We had thought the BI Solver could create the views they needed but appears not. We are still on the quest.   One of the big needs they have is to report though all levels of a BOM for demands and requirements...   No small task. 

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     




    Original Message


  • 20.  RE: Crystal 2011 Service pack 13

    Posted 07-09-2020 10:35
    To report through multi-layers of BoM I sync data to a SQL Express install (batch file refresh), and set up SQL Views there to reshape the data as needed.  One data source makes the report design easy, since all the logic is in SQL.  This is similar to the Access PTQ idea, but I'm more familiar with SQL (and SQL Express is free).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 21.  RE: Crystal 2011 Service pack 13

    Posted 07-18-2020 10:47

    Hi All,

      Sorry for the very late follow up.   Turns out my issue was that I am completely blind..   I was so focused on the sub report that was passing shared variables that I completely overlooked the fact that there was a visible sub report on the detail line...   I changed it to pass a shared variable as in the other report and the issue is resolved without the service pack.   

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     




    Original Message


  • 22.  RE: Crystal 2011 Service pack 13

    Posted 07-08-2020 23:32

    They are on 2014. 

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     




    Original Message


Related Content