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 Mike Lewis 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: jpstoehner
  • Order by date
  1. jpstoehner

    Highlight max/min row values for each group

    Trying to highlight/format the max value of each column for each group using CR10. Thought I could use the highlighting expert but it does not evaluate min/max/avg values for the field(s) you base it on. I have the following report layout... Calls Answered Calls...
  2. jpstoehner

    Formula based on parameter input

    Sorry, please disregard. I had the parameter set up as a discrete value instead of range. Thanks!
  3. jpstoehner

    Formula based on parameter input

    It gives me an error saying my parameter field cannot be summarized. Here's the code... if minimum({?PERIOD}) in cdate(2006,12,27) to cdate(2007,1,23) then "Period 1" else if minimum({?PERIOD}) in cdate(2007,1,24) to cdate(2007,2,20) then "Period 2" else if minimum({?PERIOD}) in...
  4. jpstoehner

    Formula based on parameter input

    I have a date range parameter in my report and need a formula that prints the accounting period corresponding to whatever dates are selected. For example, our "Period 1" runs 12/27/2006 to 1/23/2007. How would I create a field that I could insert on the report that reads "Period 1" if these...
  5. jpstoehner

    Importing custom Crystal Report to Symposium

    I exported one of the canned historical reports ("Application Performance") from the web application and added a new grouping of the data. I added no new tables and kept the datasource the same and it looks perfect when I preview in Crystal. I imported the report to the web application but...
  6. jpstoehner

    Reports Using MS Access

    NEVER MIND!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I was using the wrong login/password. I'm in!!!!!!!!!!!! Thanks again for your help!!
  7. jpstoehner

    Reports Using MS Access

    Wow, thank you very much. I feel so close but yet so far. When I test the ICCM_PREVIEW_DSN connection from the ODBC Data Source Administrator it gives me the following error... "user api layer: internal client library error: HAFAILOVER: Trying to connect to server." I tried adding the CLAN...
  8. jpstoehner

    Reports Using MS Access

    Geez, I went to Sybase and it appears you have to have an account with them to get Open Client 12. Anyone know of a way to get the driver I need without accounts/registrations? By the way, our IT guy came down and handed me two CD-ROM's while saying "I hope this is what you need." One of them...

Part and Inventory Search

Back
Top