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 bkrike 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: suefhmis
  • Content: Threads
  • Order by date
  1. suefhmis

    Changed link bar orientation, now can't move content

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

    Can I summarize the results of a maximum formula?

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

    Is it possible to conditionally add dollar amounts?

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

    How do I select a string within a string?

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

    How do I get a grand total for a field with a maximum formula?

    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!
  6. suefhmis

    Combining records with duplicate field contents (?)

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

    Registry changes for browsing data/default parameter values

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

    Problem with a simple If-Then-Else formula

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

    Change datasource location not working in CR 9?

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

    String and date parameters in the same report

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

    How do I point my report to a new SQL query?

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

    New parameter values don't show up for subreport when prompted

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

    Unable to insert summary/subtotal on formula

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

Part and Inventory Search

Back
Top