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!

  • Congratulations TouchToneTommy 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: rune
  • Order by date
  1. rune

    Error:"Date format picture ends before......

    Is there no one who has experienced this problem before?
  2. rune

    Formatting

    If I anderstand you correctely this shoud work; schose "Format Field"-> "Font"-> press the "formula button" and write: IF {parameter} = "deparment1" Then crgreen Else IF {parameter} = "deparment2" Then crred Else etc. Rune
  3. rune

    Pulling data from one crystal report to put in another report...

    Remember to place your subreport so it prints before the data you want (use: "add section below") in your mainreport. If your data is incorrect, use the "evaluate after ()" option in the formula editor. Rune Flaathen SNT-Norway
  4. rune

    Formatting

    I guess it depends on what kind off data you are working with; her is how I have done it IF {@snitt kø dag} in [0 to 19,99] then crGreen Else IF {@snitt kø dag} in [20 to 59,99] then crYellow Else IF {@snitt kø dag} > 60 then crRed Rune
  5. rune

    Error:"Date format picture ends before......

    converting entire input string"- "Error detected by database DLL" All my reports who select by date/time field give this respond. I locked at the SQL query and found this(lock at the date): SELECT CC_CLIENTS."NAME", CC_CALLS."TIME&quot...
  6. rune

    Howe to shove a group if there is no data in it...

    Yes, we send this reports to our customers, who paste the information into their systems, they have macros who gets messed up if a period is missing. The reason this is a problem is that I'm replacing old reports made from an old system. My challenge is to make the new reports look the same as...
  7. rune

    Howe to shove a group if there is no data in it...

    I can make "dummies" but how do I get the "dummy data" to relate to my "date/time" field so it will print in the period whit no activity? If there is no way of doing this in CR I have to solve the it in Excel, so do you think I should focus on Excel or do you se a...
  8. rune

    How do i pass a parameter from VB6 to CR8?

    I can make "dummies" but how do I get the "dummy data" to relate to my "date/time" field so it will print in the period whit no activity? If there is no way of doing this in CR I have to solve the it in Excel, so do you think I should focus on Excel or do you se a...
  9. rune

    Howe to shove a group if there is no data in it...

    I have grouped my data by half hour, and the report is a summary report (details suppressed). If there is no data in a period the report skips the group. I want to present all time periods, if there is no data in a group I’d like a message saying “no activity in this period”. The solution, I...
  10. rune

    Group on 30 minutes.

    It is easy to group on 60, 15 and 5 minutes, but I need to group my in 30 min intervals, howe can I do that on a "Date/Time" field?
  11. rune

    Number of call's within a period of time

    I’ll try to specify my problem: I do have a Boolean for “night transfer” Y/N, but I cannot use this because we have one task whit several “subtasks”. A call arrives at the phone central; if we are closed you get a message from the VRU (“voice respond unit”) saying something like ”Sorry we are...
  12. rune

    Incorrect Returns on a Parameter Field

    I use: {CC_CALLS.TIME} > {?from} and {CC_CALLS.TIME} < {?to} :-) Rune
  13. rune

    Parameter field requires data!

    I usually use ”parameter” fields to limit the report (ex: from and to date), if I leave the parameter blank it returns all dates. You may write a formula: “IF {parameter} = 0 Then 0 Else {parameter} Good luck Rune
  14. rune

    Number of call's within a period of time

    I need some help getting started: I’m making a report who returns the number of calls(and what happened to them), in a call centre. The challenge is our opening hours, people calls when we are closed (for example between 22-08), and these calls must be sorted out from the report. I think...
  15. rune

    Not used to working with variables yet.....

    I’m a newbie working with CR. I try to get information from our telephone central ( I work for a Call Centre). I have one report ”Number off calls” shoving number off calls, calls lost, calls answered etc. The data can be broken down by date, client(customers off the call centre), and/ore...

Part and Inventory Search

Back
Top