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 Chriss Miller 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: JSHoltsIT
  • Content: Threads
  • Order by date
  1. JSHoltsIT

    Highest Balance

    I have a report that gives me Customer Number, Name, Credit Limit, Sales Rep, Current Year Sales, Current Year High Balance, and then sales and high balance for last year. The problem is, my high balance that I currently have is the largest invoice amount. I need to work this query --- start...
  2. JSHoltsIT

    Calculating Current Balance & Highest Balance Owed

    I have a query that pulls transaction date and amount per customer. I would like to add to my select statement a method to calculate Current Balance owed by the customer and the Highest Balance Owed over his history with us. Thanks in advance! Jason select transdate,amountmst from custtrans...
  3. JSHoltsIT

    yearly comparative reports and leap year issues

    I have a portion of a select formula {AAcsbycpi.glpostdt} >= Date(Year(Maximum({?Date Range}))-1,1,1) that gives me everything from the current and previous year in my report. I received word that February data for this year and last are off. I presume this is a leap year issue? Thanks Jason
  4. JSHoltsIT

    SQL Query

    I have a database with products and location codes. fields: itemnmbr,locncode Every item should have a locncode M. We want to find out which items do not have M but have any other locncode. We also need to ignore items that have a blank locncode field. The database has a record for each...
  5. JSHoltsIT

    Fileserver Migration Toolkit

    I am using the Fileserver Migration Toolkit to move shared directories from one fileserver to the next. I elected not to use DFS as I prefer my new file server to be simple (sans extra services). The toolkit copies the shares and permissions with ease, but appends the old fileserver name to...
  6. JSHoltsIT

    Crystal display every date in date range on report

    in version 8.x, I have a report that pulls data from two date ranges (this year and last). The problem is, there is no data in my database for days where there is no data entered by a user. How do I display in my report a date from the range that does not have data with a Zero in place of the...
  7. JSHoltsIT

    comparative report

    I have a report that pulls data from both a date period in the current year and the same period last year. I would like the report to display by day with the current date range ascending on the left with last year's data on the right. Currently, my report is What programming magic do I have...
  8. JSHoltsIT

    Date Range Formula

    I have a date range formula IF {V_Sales_History_w_Ecomm_Attributes.glpostdt} = {?Date Range} THEN {@Shortened GL Date} And I would like to create a second formula that leverages a condition of {?Date Range} minus one year. My report pulls two sets of dates; a date range from this year and a...
  9. JSHoltsIT

    Grouping on date ranges

    My current selection criteria: record Selection Formula not ({RM00101.CUSTCLAS} in ["50IC", "50R", "50W", "IC"]) and {Sales Trx History.VOIDSTTS} = 0.00 and {Sales Trx History.SOPTYPE} in 3.00 to 4.00 group selection formula {Sales Trx History.GLPOSTDT} in {?Date Range} When I add {Sales Trx...
  10. JSHoltsIT

    Query to create 1 row from 13

    I have a query that pulls product attributes from a temp table and marries the values with data in a table. My intent is to take each of the 13 rows and create a single row with the values from @productAttributes (attributeLabel in the query results) becoming the column name and the values from...
  11. JSHoltsIT

    sp_send_dbmail

    I have a trigger running on a table that contains customer info. When payment terms are changed, the trigger fires to send a message to a couple of people. I am having problems with sp_send_dbmail permissions. If I assign a single user access to msdb and assign that single person the...
  12. JSHoltsIT

    Sending Date Criteria to MSSQL

    I have a report that analyzes data based upon prompting for a date range. Within the report, I am looking at sales data from this range, the same range last year, and the YTD for the current range year and the prior range year. My Select Expert Formula and Show SQL results are below. It...
  13. JSHoltsIT

    Display Parameter Selected in Report Header

    I have a string parameter (Allow multiples; Discrete & Range) that I would like to display in the header of the report as a reminder of the values sought. Is there a standard function in CR 8.x that will display this? Jason
  14. JSHoltsIT

    Join returns dual results

    I have a join (I took the language from a crystal report "show query" window) that returns double records. The views joined v_Combinetable1 v_Combinetable3 v_Combinetable2 are each unions of two identical tables in differing databases. Can anyone shed light onto the below query returning...
  15. JSHoltsIT

    TCP/IP Routing

    I have the following two NICs on a monitoring server Ethernet adapter Local Area Connection 2: (Metric 1) Connection-specific DNS Suffix . : IP Address. . . . . . . . . . . . : 192.168.55.10 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . ...
  16. JSHoltsIT

    Zip Code Radius Results: Pull Customer Records from View

    I have a database of all US Zip codes. I've put together syntax to pull all zip codes from a radius of miles. I have two additional tasks to perform: 1. Calculate distance from each record returned to the original zip code 2. Use the result set from the query below to pull customer data...
  17. JSHoltsIT

    Stored Procedures and CR 8

    I have a report that is running through a stored proc in MS SQL Server. When I created the report two parameters were automatically created for @startdate & @enddate I would like to delete those parameters and instead prompt for a single parameter using a range, then use a formula to send the...
  18. JSHoltsIT

    Copy user to reporting environment

    I am running a separate SQL server to run reports against and to serve as an audit for our daily backup. I need some assistance with copying user names and passwords over to the reporting sql server (different machine) and would like to automate the update process with scripting if possible...
  19. JSHoltsIT

    Restore .bak files saved with date/time stamps

    On my production SQL2005 server, I run a nightly maintenance job that writes all of my user databases to .bak files to be picked up on the nightly tape backup. I have a second SQL2005 server that I want to restore my daily .bak files to for reporting and development. How do I either 1. have...
  20. JSHoltsIT

    replacing date range with first day of month and today

    I have a report that prompts users for a date range, then the date range is split into two formula fields: start prompt date Minimum({?Date Range}) end prompt date Maximum({?Date Range}) For the sake of simplicity, I would like to have the start prompt date be the first day of the current...

Part and Inventory Search

Back
Top