Search results for query: *

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

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

Madawc, Thanks for hinting me in the correct direction..... I actually accomplished above by creating a group by date BUT then grouping in SPECIFIED order. Thats where I put the ranges in.... also works across CR years. Z.

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

Turkbear & Synapsvampire phenomenal responses - both work great. Its guys like you that make this site awesome. thx again Z.

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

lbass, Works like a charm thx

lbass, I found the "section expert->details->suppress->x+2 and enter" and followed your example... Everything seems to work EXCEPT: the rank shows up in GH1b (with the rank for the first store in the respective group)INSTEAD of in the details! I assume that I went wrong somewhere but I cant...

lbass, where would I find the "section expert->details->suppress->x+2 and enter:" in the subreport? my CR version is 8.5 if that has anything to do with it. thanks again for your patience and help Z.

Madawc, The sort works fine for the detail level per group, however if I want to have a rank @ the detail level across all groups I need something additional. Example: Group West Store Sales Rank 100 $5000 1 200 $3500 4 300 $3000 5 Group East Store...

lbass, The ranking would be @ the detail level. (however I also have groups to rank... these would be @ group levels - for example by district) I dont understand the question of reordering items - what items? thx Z.

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!

dgillz, NumberToDate is not an acceptable function/opaeration in the version I use.... CR 8.5 It gives me the following error: 'The remaining text does not appear part of the formula' thx

Dave & Brian works like a charm.... appreciate your guys' help thx

Dave, my bad.... (its so easy just to copy/paste!!) now, how do I get it to be a date field as opposed to a string?? thx again for your help

Dave, thx for the replay works correct... however The date field should be 'flexible'.... now it returns 081904 for all dates.. For the AS400 number format 20,040,819.00 I used the following formula: //If {ART_Consumed_by_reason.IDDLM}=0 then Date(1900,01,01) else //DATE //(...

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

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.

Thanks a lot Crystalyzer - worked like a charm

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