Search results for query: *

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 was actually able to achieve my desired result by using a Running Total - Sum - Evaluate on change of group function. Thanks!

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...

mwolf, this worked beautifully. Thanks so much (everyone) for your help.

That's possible. Although I was assured that each record that needed one was edited to contain an ending ~...

I've tried each of the statements you wonderful folks sent. The first one gave me an error about PATINDEX operating only on certain data types. So I tried the second one, as follows: SELECT substring (note.note_01, charindex('~', note.note_01)+1, charindex('~', note.note_01,charindex('~'...

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...

synapsevampire, I bow to you, CR genius. It worked perfectly. Thanks so much. -s

Hi Mike, I tried it...not sure I did it correctly. I created the following TWO formulas: "Def Variable" = whileprintingrecords; numbervar addit; "GF2" = whileprintingrecords; numbervar addit:=addit + Maximum({query.balance_due}...

I get a "The summary / running toal field could not be created" message.

I tried to do that. Unfortunately, my formulated field, @Balance, isn't listed as one of the fields for which you can insert a grand total.

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!

Worked brilliantly. Dummy me...I never even thought to add another group. Thank you!

synapsevampire, Thanks. I'm using CR Developer edition version 8.5. I grouped by CTR # and placed summaries for each of my item fields in the group footer, then suppressed group header and details. Now the only problem is how do I sort by the Purchaser name INSTEAD of the CTR#? Is it...

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...

That worked beautifully, Naith. Thank you so much.

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...