I changed the link bar on my home page from horizontal (left-to-right) orientation to vertical, left-side justified orientation, and now all of the content that was below the linkbar is still below the linkbar. How do I move that content so that it's to the right of the link bar, leaving the...
I'm using CR 8.5 and I've created the following formula:
Maximum ({query.principal}, {query.endowment_nbr})
and placed it in my group #1 footer. Is it possible to get a summary of this field? CR won't allow me to create a summary, grand total, or running total.
I'm using CR 8.5.
I'm creating a report and the customer would like the total of the Dollar Amount field, but if the record has a payment type of "Due", "CWA", "No Charge", or "Pre-Need", that dollar amount should NOT included in the total. But it does...
Any SQL gurus out there? I need a statement that will select a string from within a string. For example: the contents of note.note_01 for one owner looks like this:
Line one
Line two
**line three
^line four
~This is the string I need~
Line six
The string I need is surrounded by two tilde...
Hi, I'm using CR 8.5 Developer Edition. I'm using the following formula ("Balance") in the Group #2 Footer:
Maximum ({query.balance_due}, {query.sales_contract_nbr})
All I want to do is get a grand total of the formulated field. Is this possible? If so, how? Thanks!
I've created a report (it's an analysis of open A/R) that currently looks like this:
Ctr# Purchaser Item 1 Item 2 Item 3
02-1548 Name 1 500.00
02-1548 Name 1 275.00
02-1548 Name 1 350.00
Is there a way to combine all three records into one line...
I read about changing the registry settings to allow browsing more data than allowed and populating default parameter values with more database field records. My question is, since I'm creating a report that will be generated from another user's computer, do I also need to change his registry...
I've created a simple if-then-else formula (am using CR 8.5) as follows:
if {query.co_owner} = ""
then {query.owner}
else {query.co_owner}
The purpose of this formula is to return the owner's name only if there is no co-owner.
The formula correctly returns the co-owner's name, but...
I've created a report that uses a SQL query for the datasource (created the query thru Crystal SQL Designer). Made a change to the query to bring in different data. When I go to Set Datasource Location, the whole program freezes. I log off the server, go to Set Datasource Location, highlight...
I'm using CR 8.5. I've created a report in which the user can search by a name or partial name (a string parameter field). Is it possible to ask the user if he/she also wants to search by date range, and if so, to then pop the date range parameter? If this is not possible, is there any way to...
I've created a Crystal Report (version 8.5) based on a SQL query. The database is a SQL 2000 database, and I'm connecting to it through an ODBC connection. I needed to add some fields to the report that were not on the original query, so I wrote a new query. Question is, how do I point my...
I've created a report which contains a subreport. Both reports have a parameter for the company name, and when refreshing the report data, the user must select the company name for both reports.
The main report's company name parameter is working fine. We added two new companies which didn't...
This is drivin' me nuts!
I'm using the following formula to calculate property cost:
{query.prpty_cost} * {@New Ct Spc}.
This formula, called Total Cost, is placed in my group header #3 because that's what the customer wants. Note that the formula New Ct Spc is also located in group header #3...
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.