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: *

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

    Back Order Date

    When I placed an order on hold a record created in sop10104 with a hold date of 7/30/2015. when I release the order today, GP update the hold date to 8/13/2015. Does GP move the original hold date 7/30/2015 to another table or just simply update the date? Your help is greatly appreciated...
  2. CrystalVis

    Assign Result to Form

    i'm using Acess 2003 front end and backend is SQL Server 2000. i created a blank database and link it to SQL Server via ODBC. i'm trying to create form so the user can search/update/add record to a table. on the form header, i have a combo box base on the task table, once the user select a...
  3. CrystalVis

    Previous Months Data

    I need to collate all data by company and accounts for the current year. you can see from the case statement that i want to aggregate the amount from the beginning of the current year up to last month of the current year. however, when i get to Jan of a new year i need Dec of the previous year...
  4. CrystalVis

    Adding Data to Table via Form

    hello experts, i'm creating a simple form for my user to add data to a sql table. on the form i have a combo box that pulls the emp_id from the employee table. i also have 2 text boxes. text box1 displays employee first name and text box2 displays employee lastname. the values in the two text...
  5. CrystalVis

    How can I Get Crystal Report to Use Stored Procedure As a Source?

    Hello All, I'm using CR version 9 and Oracle 10g. How do I get Crystal Report to use stored procedure as a source for the report? Any help or suggestion is greatly appreciated.
  6. CrystalVis

    Unlock System and Sys accounts

    I just install Oracle 10g to my laptop. the installation was successful. the last step, i change the password for the System and Sys accounts. Now when i try to connect to Enterprise Manager in IE using either account, i received a message indicates that these accounts were locked. can you...
  7. CrystalVis

    concatinating

    i have a table with the following data structure: category instance nbr out of bal 1 8131234567 out of bal 1 7272345678... what i'm trying to accomplish is get the result in this format: category instance nbr out of bl 2...
  8. CrystalVis

    Export To A Specific Cell of an Excel sheet

    i'm trying to export a total from a sql table to a specific cell of an excel sheet. for exampl, select total_amount from tbl_total to cell b24 of an excel sheet named DATA. right now i have a data pump between a source connection and an excel connection but not sure how to accomplish his. any...
  9. CrystalVis

    Modify and Save Codes to Library

    how do i modify a class in the library and save it? i'm a newbie to vb .net and do not know how to accomplish this. any details information or links that i can learn to accomplish this is greatly appreciated. thanks
  10. CrystalVis

    Error

    We have a front end application written in C++ connect to a SQL Server. We just did an upgrade and receive this error message 1. error message on apps log: file: database.cpp; line number: 14674 22007 0 [Microsoft][ODBC SQL Server Driver]Invalid date format we contact the vendor and they...
  11. CrystalVis

    Tie Scheduled Job to a DTS Package

    is there a way for me to identify which DTS Package a scheduled job is executing? for example, i have a scheduled job named JOB_DTS_Account. within this server, i have three DTS Packages: DTS_Account, DTS_Account1 and DTS_Account2. i want to remove two out of three DTS Packages but not sure...
  12. CrystalVis

    Corrupt SQL Server!!!

    I have SQL 2K Dev Ed installed on my laptop. The IT person decided to rename my laptop. Now everytime I boot up, I revecie this message: "your sql server installation is either corrupt or has been tampered with (unable to load SQLBOOT.DLL)." I cannot start the local server on my laptop. I...
  13. CrystalVis

    Synonym vs. View

    Can you please help me understand why use synonym instead of view. My understanding is if you create a synonym, then you don't have to specify the schema owner and the users do not know the real objects that they are referencing. Same idea with using a view. You create a big temporary table...
  14. CrystalVis

    Date Calculation

    i have a result table that stores the data for my report and a calendar table that stores weekend and holiday. the result table has the following attributes: account_id account_status status_creation_datetime what I need to do is select all attributes from the result table. However, I have to...
  15. CrystalVis

    Convert Access WORKDAY Function to T-SQL

    Is there a function or a way to convert the WORKDAYS function in Access to T-SQL. This is what I have currently have in Access: Days in Error: WORKDAYS([creation_date]],Date()) basically, I would like to find the number of days between the creation_date and the current date excluding holiday...
  16. CrystalVis

    Create Fake Crosstab

    I have a result table with the following data layout (no key field, this is it): As_of_Date Email_Created Email_Sent No_Subscribers 9/11/2003 121 70 485 9/18/2003 180 87 1308 9/25/2003 249 148 2460 etc...
  17. CrystalVis

    Select MAX Value for Each Account

    Hello All, here is a sample data in my table: account_id transaction created_date 2025 846011 2003-08-14 07:28:12.037 2025 846012 2003-08-14 07:28:18.300 2025 846013 2003-08-16 20:18:25.253 6375 319711 2003-08-19 18:02:16.503 6375...
  18. CrystalVis

    Delete Row from Table

    I've a table that will always stored ten rows of data. I've a DTS package that run weekly to populate this table. What I'm trying to accomplish is remove the oldest row from the table in order to keep the number of row = 10 at all time. For example: As_of_Date Category 9/11/2003 Hungry...
  19. CrystalVis

    DECODE Statement

    I have to perform a division on two field to find the average. example: tbl.contact / tbl.count How do I check to ensure that when tbl.count is 0 then don't perform the calculation? I've tried the following but it doesn't work: DECODE(tbl.count, tbl.count > 0, tbl.contact / tbl.count,0 ) the...
  20. CrystalVis

    select data from multiple databases

    i'm trying to create a DTS pkg to use select account info from a table in oracle only if the account is exists in the SQL.lookup table in sql server 7. this is the syntax SELECT account_id, cust_ratings FROM Ora.account_info OAI WHERE EXISTS (select * from SQL.lookup where...

Part and Inventory Search

Back
Top