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 derfloh 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. bradlee27514

    Using Current Date parameters in the SQL command in the DB Expert

    I have a query pulling some data in a SQL command something like select table.invoicenumber, table.invoicedate from table What I want to do is restrict the records in the SQL command based on the invoicedate field, something like where table.invoicedate =< currentdate and...
  2. bradlee27514

    Trouble getting a distinct count in SQL command

    I have this query: select sop10100.soptype, sop10100.sopnumbe, sop10100.orignumb, sop10100. reqshipdate, sop10100.custnmbr, sop10100.custname, sop10100.cstponbr, sop10100.city, sop10100.state, sop10100.miscamnt, sop10100.docamnt, sop10100.creatddt, sop10200.sopnumbe...
  3. bradlee27514

    How can I find the week number of the year?

    I can't seem to figure this out with the available date functions. I want to take a date (e.g. currentdate) and have Crystal return what week of the year (e.g. 43) it is. Any ideas?
  4. bradlee27514

    Selecting a specific record value to input in header

    I am attempting something that I think should be rather simple. I think I can do it inside the report but perhaps I need to do something in my SQL command. Any help is appreciated. My command is pretty simple: select gl00100.actindx, gl00100.actnumbr_1, gl00100.actdescr...
  5. bradlee27514

    Some Strange Date Formulas

    I'm sure this is possible, but can't seem to figure the coding out. I have a report I want to run any given day and select data based on a start date and an end date. I want the start date to be day 1 of 3 months ago. I want the end date to be the last day of the last month. For example, If...
  6. bradlee27514

    Trouble Restricting Smartlist Access to Financial

    GP 10. I've managed to remove access to all Financial smartlists except for 'Accounts' and 'Multidimensional Analysis' . I created a security role for a test user, displayed the financial series task IDs and un checked everything, yet they still these two folders in the smartlist. Any...
  7. bradlee27514

    Summing group footer data

    My data looks like this: GH1 Invoice | Amount D 1 | $10 GF1 1 | $10 D 2 | $5 D 2 | $5 GF2 2 | $5 where GF1 is group footer 1, D is details, and GF2 is group footer 2. I want to sum the Amount in the GF2 field for the whole data set. However when I do I get...
  8. bradlee27514

    Trouble with Duplicates

    Ok, I'll try my best to explain this clearly. I'm using Great Plains SQL tables. I have three tables: Table 1 (RM30201) has a record of all invoices and what check amounts were applied to them. Table 2 (SOP30200) is a sales history table, which lists invoices and there details, but not the...

Part and Inventory Search

Back
Top