Browse By Tags

We'd like our quotes to display the product codes hyperlinked to their associated webpage on our website. Is there a way to do this with sage 100 and crystal reports? Seems like a very basic thing that should be doable.

Ever since we update to Sage 2021, the suppression in on our forms doesn't work correctly. It will leave large blank areas for al the supressed values. Supress blank sections is already selected in the group and details. It was working perfectly before…

Hi, I wanted to add "invoice transaction description" into it original report file ARTBAL.RPT using Crystal Reports. But there is no description field found from it existing table in this report. The field that I want to add is in table AROBL.DESCINVC…

I am passing a value from a subreport to main report and in the main report this is the formula: WhilePrintingRecords; shared numbervar Cafe; Cafe If there is not a match between the main report and subreport, Then it prints the value from the previous…

Trying to install Crystal Reports 2011 on a Server 2016 with terminal services enabled. I have A: UAC disabled B: Changed user status to "install" and C: Disabled the antivirus. It appears to install and gets to the point of clicking on "Finish" at…

We have Sage 300c installed and the Web Screens are accessible. However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…

I have created some reports in Crystal reports 2008 which work fine when opened directly from Crystal reports. Unfortunately the client would like to be able to open these reports from any workstation that has access to Sage, so must be able to open…

Hello all, We have a custom crystal report for Order Entry order confirmations. We have been printing Line Numbers on the report by using the special field "Record Number". However, we can no longer use this because if someone inserts a comment and…

We export a bunch of reports in CSV format using Crystal Reports. I just updated to Sage 100 2016 from MAS 200 4.4 and something weird is going on. When we try and export a report to CSV format on the Server/Remote Desktop, the Delimiter and Separator…

I won't go into great detail but I am not getting the training I need from my employer and joined here to find answers to questions that I should be able to find myself in a normal working environment. I would like to fix the alignment for check printing…

I am building a custom crystal report off the AP Invoice Table. When I grab the APIBH.DATEINVC file, it shows 20,110,101.00. I want to convert it to 1/1/2011. I tried using the following formula: date({APIBH.DATEINVC}) but it does not work. Any suggestions…

I recently upgrade from MAS200 4.4 to MAS200 2014. the version of Crystal reports for 4.4 will not work when creating custom reports in the NEW MAS200 2014. I need to install a full version of crystal reports 2011, it usually is on the MAS200 CD or…

Just started with this error in December 2015. Users of both DC Reader and Acrobat Standard XI, Windows 7 ,Mas 4.2. Not sure if MS or Adobe update caused the issue. Any help is appreciated!

I have reports that when I go into designer I see the ODBC connection and it not using the SOTAMAS90 ODBC connector, it has some other type of connection. I do not think it is correct and if someone can explain the connector and how to fix it I would…

I need to be able to review invoice line history for specific customers for a period in time(AR INIVOICEC HISTORY) Detail and Header). From that data I want to exclude specific items sold during specific date ranges(Sale items). Once I have gotten the…

We have a custom Crystal report that we run every morning that shows sales based on divisions. We can input a custom date / division / etc. I have recently discovered that the report shows sales that have not been invoiced yet. For instance, I can run…

I have written a report in Crystal utilizing dynamic parameters. When I run the report outside of Sage, it works fine and all of the parameters work as they should. If I add the report to Sage 100, the parameters no longer function properly. There is…

I have a Crystal Report that is linking CI_Item, to IM_ItemWarehouse and also linking to IM_TransactionHistory all with Inner Joins. The criteria are the following: {IM_ItemWarehouse.WarehouseCode} = "003" and {IM_ItemTransactionHistory.TransactionDate…

I am wanting to make small changes to the Trial Balance Report and run it outside of Sage 100. I went into trial balance designer and "Save as" to make a copy of the crystal report however when I refresh the data it never prompts me for parameters and…

I have a parameter field link to the CI_Item for Value Field, I would like to have only the Type 1 item show up in the drom down, what is the best way to manage the parameter field in crystal reports? or can I do something like this?

Does anyone have suggestions how to launch a crystal report from a stored procedure?

I have created a Custom General Ledger Detail By Source Report under the General Ledger Reports. I would like to print the parameters that have been selected on the Report but I do not see under special fields or under the database work table any fields…

Hi. Does SAGE 100 ERP Support Crystal Reports 2008. If it does, how do I upgrade? I want to take advantage of the additional functionality, "Calculated Members" in cross-tab reporting Thanks. -Sol

I need to print a two page document with each Sales Order I print. Crystal shortens my document to the size of the page less the size of the page footer. I need the page footer. I have tried to use sup reports, I get the same page footer problem. I have…

I need to let the system to calculate a discount based on Sales Order Header - 4. Totals -Order Total. The formula will be 5% * Order Total . I need to create a UDF, UDF_DISCOUNT, under Sales Order Header - 4. Totals Tab to show this amount. I don…