Microsoft Dynamics SL

Home » Microsoft Dynamics SL » Microsoft Dynamics SL Forum » All Tags » Crystal Reports

Browse by Tags

Tags
Related Posts

  • Forum Post: Re: Load Report Failed

    craigde
    Hi Sandyf This is a crystal reports error that is caused by the fact you don't have a C: drive in a citrix environment. The below explains the issue and outlines a crystal reports configuration change that can be made to fix this. http://diamond.businessobjects.com/node/231%23comment-2457 ...
    on 14 Jan 2008

  • Forum Post: Load Report Failed

    SandyF
    I am looking for a resolution for this error when running a crystal report in Dynamics SL v7.0. This error appears only on the citrix server, for some of the users not all of them. All users have the same rights and permissions. The error does not appear when the users run reports on the Dynamics...
    on 12 Jan 2008

  • Forum Post: Re: How to edit Temporary/Holding Table in Crystal Report

    Liz H
    Hi alanngo, Seems as though your screen shot didn't come through. Can you explain a bit more what’s meant by “Temporary/Holding” view. I asked the SL team about your inquiry and they couldn’t find those terms on the web or crystal help.
    on 22 Apr 2008

  • Forum Post: Re: Unvouchered Receipts

    hailsour
    I just joined the community and realize this was posted quite a while ago, but thought I would respond anyway. When I started this job 2 years ago I had the same mess (4+ years of crap). The key to cleaning it up is creating a meaningful, legible, organized Unvouchered Receipts Report. The dataset...
    on 9 May 2008

  • Forum Post: Crystal Report

    alanngo
    Your help is greatly appreciated.
    on 27 Mar 2008

  • Forum Post: Solomon 6.0 - SQL Server message 10039

    vincent28
    Hi, we are running Solomon 6.0 and whenever I try to run a report, I get this error. SQL Server Message 10039 Attempt to convert data stopped by syntax error in source field Debugging info: MS_strtotime - dbconvert Optional info: 07435400 Anyone know what this means?
    on 25 Sep 2008

  • Forum Post: Report for budget vs actual

    Joe Morris
    I am trying to write a Crystal report comparing actual costs to the total budgeted revenues by job. I can find values for budgets and actual in the table PJPTDSUM, but this doesn't have or seem to have the accounting period in that. I was unsuccessful in combing amounts from PJTRAN and PJPTDSUM....
    on 6 Sep 2008

  • Forum Post: Scheduled Billings - comments - notes - multiline textbox

    joe
    On Schedule Billings and Revenue Entry Screen (BI.SBE.00) under the billing schedule tab. I need to be able to make the comment field able to accept multiple lines of input. Is this possible? An alternative was going to be using the notes field to add multiple lines of text and then have it display on...
    on 14 Jan 2009

  • Forum Post: Bill of Materials Lists (Current Costs)

    kevinmcg
    I really do wish they would fix there report feature this has not worked since day one. And I do not want ot pay again for them telling me its a bug. I just need it to work. Since we use AVG cost there is no need to rollup costs but I still can't print a report because it is doubling the labor and...
    on 25 Feb 2009

  • Forum Post: Traditional Trial Balance Report

    Joe Morris
    This may sound silly, but I am trying to find if anyone has a format for a trial balance that shows the "true" debit and credit signs for each account (i.e. all debit balances are positive, all credit balances are negatives). I find it hard when I download the current trial balance in excel...
    on 23 Mar 2009

  • Forum Post: Re: Re: Add Discount amount to Period Sensitive Aged AP Crystal Report

    joe
    I receive the following errors when attempting to run from Dynamics SL: Crystal Reports Helpber Application for Solomon IV Get SQL Query Failed Report S:\Solomon\Usr_Rpts\03681d.RPT Crystal Print Engine Error: 536 - Error in File S:\Solomon\Usr_Rpts\03681d.RPT: Unable to connect: incorrect log on parameters...
    on 5 May 2009

  • Forum Post: Add Discount amount to Period Sensitive Aged AP Crystal Report

    joe
    I need to add the discount amount to the Period Sensitive Aged AP Report. I've tried going into Crystal Reports and adding the APDoc table and seting the datasource location for all the tables / views to the application database but it still doesn't work. Can someone please guide me through adding...
    on 27 Mar 2009

  • Forum Post: Crystal Reports Print Engine error

    Derek Schauland
    We use SL 6.5 Sp1 Some of my users (order management) are having trouble printing picking lists to a particular printer. The report will error the first time they print it, producing the 723 error that Crystal Reports Print Engine Helper cannot start print job. The user clicks ok and immediately repeats...
    on 28 May 2009

  • Forum Post: crystal reports for solomon and crystal reports 9

    Jeraldo
    can i install crystal reports 9 on my PC that has a crystal report for solomon? or can i just install crystal reports 9 instead of using crystal report for solomon when creating reports for Dynamics SL? thanks. this is my first post.
    on 5 Nov 2009

  • Forum Post: Crystal Reports in a Custom .NET 2.0 App

    Bob Giovinazzo
    Hi to all. I would like to install a .NET 2.0 application on the same machine as Dynamics SL 7. The application contains an output module that utilizes the Crystal Reports objects for .NET (e.g. CrystalDecisions.CrystalReports.Engine, etc.). My preference would be to use the same exact version...
    on 19 Nov 2009

  • Forum Post: Re: Custom Reports - Solomon ROI

    Paul Phillips
    ROI will dynamically rewrite the SQL contained in the data source, based on the sort/select options that the user has entered onto the report screen. It also changes the database to the SL application database the user is currently in. For these reasons, accessing anything outside of the normal SL tables...
    on 24 Feb 2010

  • Forum Post: Business Portal 4.0

    Tamara Marshall
    Are there web parts available for Business Portal 4.0 for the following? 1) FRx Viewer 2) Crystal Reports Viewer
    on 3 May 2010

  • Forum Post: Re: Re: Re: Create an Input Form in SL

    Paul Phillips
    Hi Lisa, Al of the SL screens (provided with the application or custom-built) are created using the SDK (also referred to as VBTools). The screen and its program code are created in Visual Studio using the standard SL user interface controls that are provided. The SDK provide the SL-specific API calls...
    on 6 Aug 2010

  • Forum Post: How can I get a table view to be available in Crystal Reports for SL 7.0?

    Richard Cloyes
    I'm creating new crystal report and want to use a view that is listed in the database views. Many views do show, but not all - including the one I am after (of course). I have changed the connection properties to show all tables/views/etc.. but no change. Any ideas why this is happening and how to...
    on 9 Dec 2010

  • Forum Post: "Crystal Print Engine Error: 723" when printing from Microsoft Dynamics SL 7

    IT2428
    When using Microsoft Dynamics SL to view a custom report that is linked to a custom view, table, or stored procedure and you get this error message... Cannot start print job. Report: C:\Program Files\Solomon\Usr_Rpts\CUSTOM.RPT Crystal Print Engine Error: 723 - Error in File C:\Program Files\Solomon...
    on 24 Feb 2009

  • Forum Post: Crystal report with extra page break

    Ruben Juarez
    I am completely out of ideas. I have a customized Crystal invoice report (not using any variations of the BI.010) that just will not cooperate. My situation is that whenever I have a multi-page invoice within a batch of invoices, the first page of the multi-page invoice prints the invoice header (group...
    on 8 May 2012

  • Forum Post: Add Terms and Conditions to OM Invoice

    Shelley Schultz
    I'm trying to add two pages of terms and conditions to an SL OM Invoice. The Terms and Conditions also needs to print conditionally based on Customer.User5 being true or false. Invoices will be sent via Quick Send so ideally everything would be printed in a single file with the invoice printing normally...
    on 18 Oct 2010

  • Forum Post: Crystal Reports Database Vendor Code 916

    jmittleman
    I have some custom crystal reports that I am trying to upgrade from SL 7 SP3 to SL 2011. On a number of them, I am receiving an error from Crystal Reports "Failed to retrieve data from the database. Details: [Database Vendor Code: 916] Failed to retrieve data from teh database. Error in File...
    on 24 Oct 2012

  • Forum Post: Crystal Report - error opening report - database vendor code: 208

    RedStorm
    We upgraded to SL2011 FP1 from SL7 FP1. Now when we print/print preview certain crystal reports they come up with an ERROR message: Crystal Report Windows Forms Viewer - Failed to retrieve data from the database. Details: [Database Vendor Code: 208] ... Any suggestions? Thank you, Dave
    on 26 Nov 2012

  • Forum Post: SL Crystal Report - Error in formula Record Selection

    RedStorm
    Help! 1) Upgrading to SL2011 from SL7. 2) Going through pain of fixing Crystal reports. 3) We have an invoice format in Flex Billings. That format is linked to a custom Crystal report we had used in the past without issue. 4) Now, when we VIEW INVOICE from the Flex Billings Invoice and Adjustment screen...
    on 6 Dec 2012
12