Browse By Tags

  • Using Crystal Reports to customize Ardinvo, how do I add database tables and fields from those tables?

    I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name. Now I want to add some fields to it that are not in the set of data tables already in the report. In the "Field Explorer" I right…
  • Report Designer - custom date formula

    Hi there, This is my first post in Sage 300 online Community, woohoo. I find myself in uncharted waters. I am putting together a custom date formula, where the date has DDD field, which means 3 digits for "day in year". Example would be that today…
  • Formula to Suppress the footer option

    I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…
  • Contract Billing Report Customization in Crystal

    I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…
  • Issue with Crystal reports prompting for SQL sa password.

    We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…
  • Can I add the user name who is printing the form on the form?

    Hi, Can I add the user name who is printing the form on the form? Thank you!
  • Report print Macros

    i have the below Exception please any help ????