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 gkittelson 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. Greeham

    SQL Statements

    Can someone tell me how to insert an SQL Statement in my Report? I need the following: I'm using a table named F_DOCS. I've included a lot of calculated records and formulas but now I need to obtain the number of records where F_DOCS.DO_HOUR is within a range of time. I would like to obtain...
  2. Greeham

    How to access records in the same table but with a different filter

    The problem I've found is that I want to access the data filtered by the record DO_TYPE, but I do not need ONLY one. I must have a report like this: Total of Invoices: 3 ---> Count({F_DOCS}) WHERE DO_TYPE=1 Total of Achieves: 2 ---> Count({F_DOCS}) WHERE DO_TYPE=2 Number of Documents: 5...
  3. Greeham

    How to access records in the same table but with a different filter

    Dear friends, Can someone tell me how to access records in the same table but with a different filter? That is, I have a table named F_DOCS of documents. There's a record named DO_TYPE which is used to sepparate different kind of documents (i.e. DO_TYPE = 1 The document is an InVoice, DO_TYPE =...
  4. Greeham

    Using variables from a sub-report in the main report

    Dear friends, I've got the following question: - How can I use sub-report declared variables in the main report ? For example, I want to use a variable declared in a sub-report to be used for calculating a Total in the Main Report. I hope you can give me an answer. Thankx.

Part and Inventory Search

Back
Top