Search results for query: *

I can't find this chart type in Crystal 8.5; are you sure that is available in 8.5? How can I recognise it? Thank you.

Sorry but do I change the x-axis to a value from a category? Thank you.

I have a report for which the grouping of the data based on the week number (1 to 52) doesn't return all of the week numbers based on the select statement criteria. Question: how can I have all the weeks (1 to 52) in the chart? Thank you.

Thank you!

I made the modifications based on the above. I can see now a header "1" (didn't have a "1" before ...) etc. There is only one problem. I can see the header "1" but there is no additional grouping in the data = "1". Do you know what I mean? My chart will be based on data not on the additional...

@weekly formula: ---------------------- if year({@Jeff_Date}) < 2009 then 0 else datepart('ww',{@Jeff_Date}); -------------------------- @final formula: ----------------------- local numbervar c:= {@weekly}; local numbervar p:=previous({@weekly}); local numbervar d:= c-p-1; select d...

The formula works now and there are additional headers appearing but as I said in the previous post I don't see new values for missing weeks (weeks that are not in the database for the specified select criteria). Any ideas? Thank you

The formula is always blank. There is something that I don't understand: the formula that you built will not create new values for missing weeks (weeks that are not in the database for the specified select criteria). The formula will create new headers in the grouping but that's all. Do I miss...

I will review tomorrow everything. I understand now the idea. If what you told me doesn't work I will manually create 52 headers and I will make them visible or not based on the value in @weeks. Other then this I don't have any other ideea. Thank you so much for your help!

I created a formula @FINAL: local numbervar c:= {@weekly}; local numbervar p:=previous({@weekly}); local numbervar d:= c-p-1; select d case 1: totext(c-1) case is > 1: c-d & " to " & c-1 default: "" I have 2 groupings now; the second one is the one that...

In "select x" ... what's x?

So: numbervar c:= {@weekly}; numbervar p:=previous((@weekly}); What about the rest of the formula? please remember that I don't have records for all of the weeks. Thank you.

Forgot to tell you: I need all of week number (1 to 52) in the report; I will make a chart based on this. Thank you

Hi Gordon, in the previous post I came up with a simple example. I actually have to deal with "the number of week in the year" where the number of week is 1 to 52 and the year is 2009 (I have however a few records where the year is 1980 or 1950 because the data in the database is not very...

In the field that I want to use for grouping I have this values: 01 02 05 Values 03 and 04 are missing (not in the data); however, I would like them to be included in the grouping. How can I do this? Thank you!