Search results for query: *

perfect......thanks!

i have a report that groups by company name, transaction id and order date. all the data is printed in the deatils. i would like to know how to create a counter that prints in the deatils and reset it self by the order id. data below: ACME INC. AKV878 mar-04-06 Counter: T1 ACME INC...

CR Version 8.5 Oracle 9 I was looking for a formula that would auto increment a counting sequence for the records printed only (no blank feilds). 1. CCCCCCC 2. fffffffffff 3. dddddddddd this is a group called accounts and depending on the vendor they may have a number of accounts assigned to...

yes, the connectivity is there if i take out the parameter it can be published on the enterprise and runs with no errors.so this puzzels me and the fields are being used in the report as well and all i'm doing is assigning them in a cascading parameter. go figure eh.

(CR XI, Oracle 9i, XP Pro) Hi, I have a command I created and I am using 2 fields from there to assign to a cascading parameter. When I run the report it prompts me as usual for my parameters and the report runs with no errors and bring back the correct data. (I want the parameter to populate...

CR 11 I have a date parameter call rig date and if the users does not know the rig date i want them the parameter to return the current date

I have a main report that is filtering out revenue accounts and using this one table only. {ACCOUNT_GROUP_ACCOUNTS.MAJOR_ACCT} ='700' and {ACCOUNT_GROUP_ACCOUNTS.MINOR_ACCT} <> 'CLR' I have a subreport that is called revenue which is linked by these 2 feilds. {LINE_ITEMS.MAJOR_ACCT} =...

i am using crystal 10, does anyone know a top 10 formula for sales I can play with as I am trying to pass this to a subreport. Basically in the main report i have used the expert button, but in the subreport I would like to pass a formula so I can get a running total from the subreport.

when i view it on enetrprise it shows the correct %, but onec scheduled with the same param the % is incorrect

This is so puzzling, but I have a report that when scheduled it shows an incorrect sales %. I have checked the parameters, dates everything. I even copied the report to my folder on enterprise and recreated the scheduled report with the same parameters (date)and it shows the correct %. I ran...

I have CR 10 and I am doing a query of number of true and false vales that are produced off of my original formaula. original formula: if mid({Product.Primary SKU/PLU/UPC},1,5) like "-?*" then true this gives me a list of true and false values for which I though I could do a count on, but it...

hi just would like to know if there is a code to change the font colour on drill down. I am drilling down from a Department to a Sub-Department and when I drill down to the Sub-Department I would like the Department font colour to change from black to blue. I am using Crystal Report 10.....Any...

i will be using all the row, but the user will not be viewing these rows just the summary of the rows( sales), so the database need to pull these rows. as it is a comparision of sales by item for the this year and last year. the number of stores are 115 stores. i read in a crystal book about...

i am running version 10, odbc connection and a sequal database

I have a report that is pulling 10,046,018 records off the server. I am also running the report off the server not as a local copy on my computer. This report is pulling all our last year sales and current year sales by items. YEH, does anyone have a suggestion as to making this report run in...

can't use this cause this is based on a company's fiscal year not a calander year and quarterly dates depend year by year

i would like to calculate quarterly sales..so far i have this. cStr(((datediff("q", ({Lwi_Periods.Year_Start} ),{Lwi_Periods.Year_End} )) -2),0); but this was just an idea. I need to incoperate my date parm which selects on day and based on that day the report should select the quarter in which...

I am try to find sales for a selected month based on a (Date pram) for the current year and for the same month for last year...problem is I return the sales for the same month (good) but don't know how to have it call to last year and current year...not sure if the script is correct. any...

my date feild is {DailySales_Summary_vw.SalesDate} (a datetime)

i have a date param in the main report and need to see sales for a week based on the date pram for the current year and last fiscal year. ELSE IF {?DateRangeType} = "Weekly" then if({?Date })in Last7Days then if ({MMS_Store_Region_vw.Region}="USA")then...