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
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
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
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"...
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...
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...
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...
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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.