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. sjdbmc

    Combining Tables

    SQL Server What you have described is exactly what we need and I'll speak to our IT guy about getting it set up. Many Thanks Stuart
  2. sjdbmc

    Combining Tables

    Example Table 1 called order_line Table 2 called c_order_line Structures are identical with order_line storing live jobs & c_order_line storing historical jobs. Can these 2 data sources be merged into 1 data source which can then be reported on. We use subreports at the minute but we would...
  3. sjdbmc

    Combining Tables

    Our system for handling jobs has various tables associated with live jobs. When a job is invoiced it is moved to history and the job is now stored in identically structured tables but with different names. When reporting I have to write 2 reports to get information i.e current & history. Is...
  4. sjdbmc

    Summarising Groups

    Works like a charm Much appreciated Stuart
  5. sjdbmc

    Summarising Groups

    campsys Thanks for response. All of my info is in the group header of order_id. The Yes or No in calculated on the group info not the detail. All of the detail is suppressed, so I need to summarise the group headers. example GH YES GH YES GH YES GH...
  6. sjdbmc

    Summarising Groups

    I am attempting to work out whether we have attended a job when we said we would attend a job and calculate %'s from it. I have 2 tables order_line and demand. Order_line contains details of the job and Demand contains the activities carried out on the job (1 to many) The attend by date is in...
  7. sjdbmc

    Section Visibility

    I have created a report to produce an invoice to customers. A Subreport produces the Invoice Address. Due to human error etc people have entered the customer name into the 1st line of the invoice address which results in the customer name appearing twice in the address. I have come up with...
  8. sjdbmc

    Section Visibility

    I have created a report to produce an invoice to cusotmers. A Subreport produces the Invoice Address. Due to human error etc people have entered the customer name into the 1st line of the invoice address which results in the customer name appearing twice in the address. I have come up with...
  9. sjdbmc

    Passing Data from Sub report

    I have created a query with returns 2,000 records approx from one table. I have created a subreport for each record which is linked to the main report and returns a SURVEY activity and a date. I now want to pass the date value back to the main report using StoreDateVar and FetchDateVar. I...
  10. sjdbmc

    Evaluating Date Fields

    Many Thanks
  11. sjdbmc

    Evaluating Date Fields

    I am attempting to evaluate date fields and enter "----" is blank or the actual date if not. if year({insurance_details.mtrl_choice_rec}) = 1899 then "----" else if isnull({insurance_details.mtrl_choice_rec}) then "----" else if {insurance_details.mtrl_choice_rec} = Date(0,0,0) then "----"...
  12. sjdbmc

    String is non Numeric

    I've managed to sort it myself. Regional settings on on individual machines needed changing to pick up correct date format.
  13. sjdbmc

    String is non Numeric

    numberVar Conversion_Year := tonumber(Mid (totext({insurance_details.complete_by_dt}),7,4)); numberVar Conversion_Month := tonumber(Mid (totext({insurance_details.complete_by_dt}),4,2)); numberVar Conversion_Day := tonumber(Mid (totext({insurance_details.complete_by_dt}),1,2)); numberVar...
  14. sjdbmc

    Start position for string searching is less than 0 or not an integer

    I am attempting to retrieve an address from our new database which is stored at address.address_1. All of the address lines are stored in this one field and need to be extracted and entered onto my report so I can suppress blank sections. I have successfully located the separator...

Part and Inventory Search

Back
Top