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!

  • Congratulations strongm 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: *

  • Users: AdamField
  • Content: Threads
  • Order by date
  1. AdamField

    Multi Server Query

    Hey Guys, I'm stuck on this problem and hoping somebody can give me a step into the good direction on it. First i'll try to give you all a view on the situation Mysql Server1 (lets call him Webserver:p) Mysql Server2 (lets call that one LocalHost) Now i'm working with Navicat so that's my...
  2. AdamField

    Jobs going wrong

    Hey All, I created a DTS local packages that makes 1 big table from 5 other tables. When i run the package from the local packages (execute package) IT pops up and runs perfect. The data in the table is also correct so no problem there. Problem starts when i right click the local package and...
  3. AdamField

    Ms SQL View

    Hey Guys, i got a stupid problem with making a SQL View and becouse i have zero sql skills i'm trying here :p what i have is in total 5 DB's all the DB's have 10 colum's with info now i need to make 1 BIG view from those 5 db's but i need to get 11 colums now first 10 are the same as what is...
  4. AdamField

    Formula going wrong

    Hey Guys, Got a formula that is working in the simple form but the moment i expand it, it start's do go wrong This is what i have DB1 Backorkl : colums with info im using b_afwerk (boolean) b_relnum DB2 bomatch : colums with info i'm using...
  5. AdamField

    multiple Sources

    Hey All, I'm stuck with quite a big problem and i hope this way will will get me a answer. I'll try to explain the problem as good as possible but feel free to ask more info if needed: First, the company i work for has 3 shops (lets call them shop1 - 2 - 3) and the program we work witch...
  6. AdamField

    2 many reports

    Hey All, Not sure if this is the correct forum but here i go: in our company we have 4 shops and i'm making reports for all of them but a lot of the times i have to make 4 time's the same becouse every shop needs the same style reports (sales report / cross selling report / ...) just a diferent...
  7. AdamField

    Shared/ Global Variable not working

    Hey all, I have this report i'm working on that is acting strange i have a shared variable counter: formula 1: shared numbervar counter := 0 (header) formula 2: shared numbervar counter; IF test1 THEN counter := counter +sum(fieldX) ELSE cunter...
  8. AdamField

    Limit the number of shown records

    Hey All, I'm quite new to crystal report so maybe i'm stuck on somthing simple but here it goos I have a SQL db with arround 500 lines and i do a record selection on 2 parameters that i give. In most cases that gives me back 1 result but in some cases it gives me 2 or even 3 records in my...
  9. AdamField

    SQL : Making a table with only the past 14 days in

    Hey all, I'm stuck on this problem here and hoping somebody can point me in the right direction I need for a crystal report a database (SQL prefered) that has the last 14 dates in it and that is autoupdate (so no task that fill's it up daily) It only needs to have 1 colum (if 2 are needed for...

Part and Inventory Search

Back
Top