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 bkrike 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: lilolee
  • Content: Threads
  • Order by date
  1. lilolee

    SQL to count how many ID's are in a table more than once

    Data is like below RefID - Date A1 - 01/01/2016 A2 - 01/01/2016 A1 - 02/01/2016 A3 - 02/01/2016 A1 - 03/01/2016 etc The output I would like is 1, as in only 1 RefID (A1) which occurs more than once. And then to complicate this, there are many tables ie Fault_Report1...
  2. lilolee

    Error Failed to open connection crweb00000119 when running a report with a Parameter

    I have created a report in Crystal 2011 getting data from a SQL server, and then place it on the CE server. The report runs fine in Crystal Reports, and runs fine on CE. However when I change the report and add a Parameter it the falls over with the error in the subject. Any ideas would be...
  3. lilolee

    cViewManager parameter list query

    I have been asked to evaluate cViewManager and overall it looks close to what my client wants. Just one thing, in the list of features it states "Lists - You can create lists of values... These can be used in the schedule for parameter values..." As hard as I try I can't work out how to use...
  4. lilolee

    Row Numbers in Crosstab

    Hi I am using CR9 and would like the following 2006 1 Lee 9 2 John 7 3 Jane 4 20 As in the Name and Year is a crosstab, but I would like to number each row. Any ideas? Many Thanks Lee

Part and Inventory Search

Back
Top