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

    Data 'clash' checking

    Hi all Just started working with Crystal after a gap of six+ years (I wasn't very good in the first place!) and have been handed what I think is a real 'doozey' of a problem. Hopefully I can articulate it properly, so here goes.. I have a report which shows a student's provisional course...
  2. Squeaks

    Use a row of data twice in a group

    Hi I produce a timetable by grouping rows of data into 'slots' within a matrix - it looks a little like a cross-tab. e.g. data looks like this: PERIOD, DAY, NAME, NOTES 1,Mon,Monday 1,1 1,Tue,Tuesday 1,1 2,Mon,Monday 2,3 6,Fri,Friday 6,6 I group the data by PERIOD (max value 7, headers...
  3. Squeaks

    Suppressing columns and blank lines

    Not sure if the thread heading is accurate but here goes.. using CR 8.5 have rows of data which include an unique ID, date and also a time field (amongst others). I've grouped the records by date and expect to see the time and other fields listed in the details section for each unique id (1...
  4. Squeaks

    Excel row to column Transpose question

    I have a dataset in this format Person1, value1 Person1, value2 Person2, value3 Person2, value4 Person2, value5 but need it to look like this Person1, value1, value2 Person2, value3, value4, value5 Because the values are variable a normal crosstab/pivot does not work and because the the...
  5. Squeaks

    Challenging String/Date Formula question

    I've been trying to come up with a solution to this for sometime but with no result. I have a report in crystal 7 which returns timetable information. It compares a parameter date range (startday and endday) to each timetabled activity startdate and enddate, and shows the data if the...
  6. Squeaks

    SQL Server Subreport not working at runtime

    Hello again, I have to write a disclaimer at this point..I'm a novice with Crystal and I'm sure the terminology and my understanding of it is poor so please forgive the longwinded explanation of my problem. I've created a report in Crystal Reports 7 which draws the main data from an Access...
  7. Squeaks

    Inserting images (from links) into reports

    Hi Everybody I'm looking into the possibility of creating access reports and labels which when printed would include a unique image for each record. Unfortunately the images are not stored within any database but only as a file path/location string attached to each record. In effect, at...

Part and Inventory Search

Back
Top