Search results for query: *

Thanks Ibass. I'll try that tomorrow.

When looking at the crosstab expert, i can create the two columns and I have the group options. I can't find the "on change of" (although I've seen it before). So in doing the report I've got the monthly column summary. What I can't do is select one month specifically and compare it to this...

thread149-1570816 Can this be done in a crosstab? I want to compare the same period in the current year vs. prior years. eg. mar 1-7 2011 mar 1-31 2010 ... 09 ...08 cust1 |------------ | ------------ cust2 | | cust3 | |...

Hello I am trying to do a line chart in CR9 where several years' information is shown together on the same chart for comparison purposes, but i've come across some obstacles. Data X axis is sales information summarized by month and sorted on a fiscal year end date of Aug - July. Y axis...

How to make a chart of running totals with year over year information? I've discovered how to chart two years information on one chart thanks to Ibass. I followed this: Try using a formula for month for the "on change of" field: monthname(month({table.date})) After adding this to the...

I have been trying to run a report where some of the denominators in a formula are zero ("cannot divide by zero"). The result is that the entire report is suspended. Is there a way to tell crystal to bypass the zero values or change them to another value ie. 1? Thanks for suggestions.

Thanks LB I'm beginning to understand how this works. However, regrettably I'm still missing something. The table I am retrieving the data from is called SALES. The fields are: sales.Name sales.Address sales.Quantity sales.Description etc. So what do you mean by "rowfield"? The crosstab I...

To explain this further, I have a cross tab as follows: date1 date 2 date 3 TOTAL cust puchases quantity xx xx xx xxx $ amount xxx xxx xxx xxxx I want to report only those records where the total quantity or dollar volume is > any value I...

I have just begun using cross tabs. I have a report and want to select records that total less than a specified value. However when I choose the selection tool, the totals are not showing up as a selection source. I can choose from any data table, but not from the summaries. In a regular...

Thanks for replying to an old message. In the above formula you refer to a "table" that holds the photos. The photos are actually in a folder as individual .jpg's not in a table. So how to cross reference a table with a folder of photos? TO explain further, I have item numbers (sku)in a...

i am trying to link photos from a folder to some data from a database table. You refered to this but perhaps you could help me to do it. I am linking sku numbers to .jpg photos with the same number (ie. sku 72012 with photo 72012.jpg). Could you tell me how to do this in Crytal Reports (i'm...