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

    Splitting a contact name

    Hi there I have a field for contact name, which i need to split logically into 2 fields, being first name and last name. Currently the name could be formatted like.... J P Murphy John Murhpy JP Murphy The majority of records are split john Murphy, so I want to say anything to the left of the...
  2. lissa1974

    Cross Tab - Show Values with multiple fields

    Hi there, slight complex report I'm trying to create. Using Crystal 2008 with SQL. I am reporting off of one view, which makes this simple from a data point of view. What I have is this as lines of data..... Company Name Product Revenue Month Bob A £450 200907 Bob...
  3. lissa1974

    Supressing Page header when Graph appears

    Hi there, using SQL and Crystal 2008. I have a page header that has title for the columns in the report. This is all fine. However, the fist page on the first group is a graph for that group. I don't want the page header titles to show on a report, just the data pages. How can I supress the page...
  4. lissa1974

    Date Conversion - Number to Date

    Hi there, sure this is easy but cannot nail it down. I have a field thats a number field (SQL & CR2008) that I need converting to a date. The field example is..... 200810 I need to be able to see that as a date. Using CDate converts it very badly, as it then shows the year as 2449 on every...
  5. lissa1974

    Graphs - date range issue

    Hi there, CR2008 using SQL. I'm reporting from a Helpdesk call logging system. When you log a call it enters a record into a table, stamps it with the creation date, and has an action..... call No id Action Create date Modify Date 16919 23 Create 01/01/2009 01/01/2009...
  6. lissa1974

    Remove Group based on Parameter

    Hi there, using SQL with Crystal 2008. What I'm looking to do is remove a group based on the what's entered into a parameter. Currently I have data looking like this.... Item 1 Quality Tops 2 Socks 3 Jeans 4 Item 2 Shoes 2 Hankys 3 Blankets...
  7. lissa1974

    Date diff between two dates on different records

    Hi there, using crystal 2008 on SQL. I currently have a report that shows.... Stage 1% 01/12/2008 Stage 2% 10/12/2008 Stage 3% 21/12/2008 Basically they are three history records related to the same company, so it keeps track of when their issue is moved forward. Every time it moves...
  8. lissa1974

    Time Conversion

    Hi there, I'm looking for a time conversion into HH:MM:SS from a field that outputs the date as... 72233 = meaning it's 07:22:33 104532 = 10:45:32 130427 = 13:04:27 Any help would be appriciated. Regards
  9. lissa1974

    Showing multiple items value over a period of time

    Hi there, I'm using Crystal 2008 with SQL. I'm basically stuck, in that I can't think how I can go about creating a report that will show me what I need. I've been using Crystal for a number of years but this has stumped me. I have line items like below.... Item Start Date End Date...
  10. lissa1974

    Running total display

    Hi there, I have a problem in displaying a running total and wondered if there was any way around it. Using CR8.5 and SQL server. Basically, I have a header with totals based on the sums and counts of the groups below, so quite easy set up. One of the columns I need to use a running total for...
  11. lissa1974

    Converting a number to currency including formatting

    Hi there, we have a field in a database (SQL, running crystal 8.5 taking data from oracle Enterpriseone app)with numbers inserted into it. These represent the value of contracts. For instance... Row1 = 347660 Row2 = 98373322 Row3 = 48473 What they look like in the system and what they...

Part and Inventory Search

Back
Top