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

    Charting :Comparing This Years Sales to Last Years

    Hi all, I am using CR XI and have the following Data: Week Year Sales 1 2005 100 2 2005 225 3 2005 200 1 2006 125 2 2006 200 3 2006 300 Q1: How can I show the weekly sales with two series (2005,2006) on the Chart where the x-axis is week (1,2,3) and the y-axis...
  2. zupnik

    Conneceting to DB via ODBC - delta between CR 8.5 & XI

    I wrote reports in CR 8.5 with the DB being MS Access. The connection was ODBC. works great! After installing CR XI, opening the old reports (8.5) worked. What did not work was refreshing (running them) in XI....Database connectivity error.DAO error Q: Does anyone know: 1)why I need DAO if the...
  3. zupnik

    Grouping by date - using other date ranges than in CR

    Hi all, CR: 8.5 DB: Access Is there a way to define the date range for a group and then have it displayed in a crosstab? i.e If I just group by date and print the section for each month then for the month of May the dates will be 5/1/05 thru 5/31/05. My Month of June 2005 however runs from...
  4. zupnik

    Date Parameter: allowing multiple values - NOT dates but Ranges

    CR: 8.5 DM Access 2003 Due to a different schedule between our fiscal calendar and the CR calendar, I would like to know if the following is possible: When a user refreshes the report a date parameter field pops up and lets him choose from a list of months by name, i.e January 2005, February...
  5. zupnik

    How do I rank in CR 8.5

    Hi all, DB : access 2002 CR : 8.5 Example: Store# Sales 100 $3255 200 $8999 300 $5466 Q: How do I rank the stores by sales... what is the formula?? thx for the help!
  6. zupnik

    Date Format Conversion

    Hi all, My Specs: CR - 8.5 DB - DB2 AS400 The Date (Number Format) I get from the AS400 is: 200,408.19 The way it should display in CR is 081904 as a dateformat. appreciate all the help thx
  7. zupnik

    4-5-4 calendar

    Hi all! Does anyone know if CR v85 has a 'retail' calendar function built in?? i.e month w/4 weeks, month w/5 weeks, month w/4weeks etc. Thanks Z.
  8. zupnik

    Adding empty fields

    Hi all, CR version: 8.5 DB: Access 2002 ex: I have the following table: Date Store1 Store2 Store3 1/1 100 200 2/1 200 600 3/1 400 300 500 All fields are number fields please note that in the DB table Store 3 does NOT have a 0 but a BLANK. Q: In CR...
  9. zupnik

    sum of distinct counts

    Hi All! Versions: CR 8.5 ; DB Access 2002 I am trying to get the following result: # of Trailers 2004 33 January 15 1/2/04 6 1/10/04 7 1/15/04 2 February 18 2/1/04 6 2/12/04 12 The issue that I have...
  10. zupnik

    Link Subreport - SR View Should "jump" to the same as Main Rpt.

    I am using CR 8.5 and have the following issue: Q: How can I see the subreport information which corresponds to the main report page that I am currently 'viewing' through. (A)I have a Main Report which has the following variables: Name Jobcode Date Hours RE Total PPH +/-RE...

Part and Inventory Search

Back
Top