Hello,
I have a multi-value parameter (purpose codes) with 12 options including select all. I currently show a total count per user and how many rows returned-per user regardless of how many purpose codes are selected. What I would like to do is break down that total count per purpose code per...
Hello,
I’m trying to convert a stat report from Crystal to SSRS. In crystal I use a formula to do the calculations.
This is the crystal expression.
if {TRAFFIC_DATE_SUMMARY.TYPE} in (["Sober Designated Drivers Contacted", "Total DRE Evaluations"]) then '*'
else if Sum...
Hello,
I have a data set of two columns. Column A has values of 30, 45 and 60. Column B has various numbers. What I want to do is to have a formula in another field that checks column A for 60 and then sums up the numbers in column B that have 60 in Column A. I was trying to use an If statement...
Hello,
I have a query consisting of 3 queries all union-ed together each returning a specific count. My end result looks like this:
Kount Type
786 Duplicates
11737 Orders
38503 Calls
What I want is to do the following calculation within this sql query.
(Calls + Orders) - Duplicates...
Hello,
I have a query consisting of 3 queries all union-ed together each returning a specific count. My end result looks like this:
Kount Type
786 Duplicates
11737 Orders
38503 Calls
What I want is to do the following calculation within this sql query.
(Calls + Orders) - Duplicates
Is...
Hello,
I have a notes field that contains multiple lines of text. I would like to highlight red certain specific words when present, not the whole field. I am in the text interpretation field and have used the following formula which I have found on other postings. In this example I want to...
Hello,
I have a report that has a section for narrative that is limited to about 1900 characters on the main page. What I would like to do is see if there is a way to have the whole text of the narrative move to a new page if it exceeds over 1900 characters. If it is under 1900 characters than...
Hello,
I have created a query using unions that runs fine but runs slow. I was trying to speed this up and am thinking subqueries would solve the problem. I am having difficulty in turning these into subqueries. I've tried a few iterations but keep returning incorrect data sets duplicating...
Hello,
Not a programmer at all. Trying to do a formula in crystal.
getting boolean required here and highlights the else statement.
Trying the following:
If {INV_CODE} = 'PER' then
{CHG} = " "
Else {CHG}
What I'm trying to say is if involvement code is equal to PER then I want to the chg...
I have a an application that is using a front end .mde file with a SQL Server backend. The problem is that the Front end mde file is growing rapidly and causing fatal errors? Any ideas as to what the cause could be.
Hello,
I have an access database that contains a table called customers and a column called title. What I want to do is query this table and return records that contains sales in the title name but that doesn't start with sales. For example it would return district sales manager but not sales...
I have many Access apps in my workplace. Instead of using MS access tools to login, is there a way to use the windows login id to control permissions to the apps. I want some users to be able to view while others the ability to modify data. Also I want to use the login id to identify who...
Hello,
I am using Crystal X and want to know how to add a page border on every page of my report. I want the border to go around the whole page. All I can figure out is how to do section borders but this is of no use to me. Any help appreciated.
Thanks,
Chris
Hello,
I am using Crystal 10 and am creating a formula that combines a employee id with the first and last name. However, when I combine the employee id in it shows with a comma. I need the employee id to have no commas.
example of how it looks
111,111 John Doe
What I want:
111111 John Doe...
Hello,
I am using crystal 10 and working on a report where I have a name field that is using a formula that combines first and last name columns from my view. However, some records don't have a first name, just a last name of Unknown followed by a case number. So the field may look like UNKNOWN...
Hello,
Need some assistance with an if statement. It is returing values of true or false instead of other values I want.
Statement:
If {APPROVAL_LOG_HISTORY.APPLVL} = 2 and {APPROVAL_LOG_HISTORY.APPDESC} = 'approve' then {APPROVAL_LOG_HISTORY.ROLENM} = 'Final Approval'
else...
Hello all,
I am new to crystal and am using Crystal 10. I am running reports through an app that allows for parameters to be entered such as date, id#, and case number. I have labels for all the parameters and they show up on the report even if the parameter isn't being used.
For example, if...
Hello,
I am new to crystal and not a programmer. I have a quick question. I am trying to create a formula where I say if 1 field is greater than another field then display a certain value.
For example:
If {INVENTORY.REORDERPOINT} > {INVENTORY.REORDERQTY} then
I want the word "reorder" to be...
Hello,
I have a spreadsheet with hundreds of cells with time in the format as follows: 00:20 which means 20 seconds. My boss nows wants me to convert that 20 seconds into decimal format .3333. Any tips on how to do this easily.
All help appreciated.
Thanks,
Chris
Hello all,
I have a column of data calculated by taking the difference of two times. The valued returned is in a time format. I want that value to be a number.
Example
Time Called Time Arrived
14:30 14:45
The difference is 0:15 (This is what appears) I want it to say 15. When I...
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.