Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. deanni

    query help

    The problem is; we have several companies and i need to do consolidated reporting. FRx still mounts each db independently. I am trying to extract the financial data into a consolidated database and have Frx, crystal or some reporting software mount the consolidated db. So, that is why i'm trying...
  2. deanni

    query help

    Here is the actual query the reports uses, but if it is ran outside of mas nothing appears. SELECT "GL_FinancialReportHeaderWrk"."ReportTitle", "GL_FinancialReportHeaderWrk"."ReportTitle2", "GL_FinancialReportHeaderWrk"."ReportTitle3", "GL_FinancialReportHeaderWrk"."ReportTitle4"...
  3. deanni

    query help

    I'm using MAS 90 4.2. The crystal financial reports are using a table named "GL_FinancialReportDetailWrk" to pull there information, but there is no data when i access them. I imagine MAS populates the table spits out the report and then clears them out. Is there a way to populate the table or...
  4. deanni

    query help

    thanks for the link. ill check it out
  5. deanni

    query help

    I'm new to the MAS 90 data structure and use access to look at the data. Does any one have a simple query that summarizes the GL? I would like to extract a useful datacube to a MS SQL server and use a report writer. I am having trouble understanding where and how the data is stored and linked...

Part and Inventory Search

Back
Top