Recent content by skries

Nevermind, I found my error. Using the = sign instead of the := sign.

Crystal 8.5 I am creating a report that I want to have display a coverpage that lists all the groups that result from the select statement. It is undetermined which groups will be displayed and there will never be more than 10 groups overall. In order to capture it I created a formula that...

Sounds like a minor syntax error you are receiving. Display what you have done thus far.

It sounds like you need 2 groups. First group by effective date second group by account # You can still use the same scenario for each account # group under the effective date. Hope this helps

Are you trying to group by account # or by the gifteffdate initially? You can create a group on the account # and then list the details of the account under that group or vice versa. It is unclear from your writing but it seems that you need to create a balancing formula. For each account #...

In the Font Format Formula editor for the date field on the report you can enter the following if today - CurrentFieldValue > 3 and WeekdayName (DayOfWeek ({your_referenced_date_field})) in["Monday", "Tuesday", "Wednesday", "Thursday", "Friday"] then crred else crblack //Enter whatever your...

In Format Crosstab, under the 'Customize Style' tab highlight the appropriate row that you want to suppress and check the box under Group Options 'Suppress Subtotal'

Thanks IdoMillet. That did the trick.

Crystal 8.5 SQL Database There are 2 tables 'WorkOrders' & 'TimeCharges'. I want to show all work order records only when there is no matching record in the timecharges table. Essentially I am trying to display when time has not been applied against a work order. Linking field is 'wonumber'

Version 8.5

I want to use a variable as the data and show the legend but don't want to show the @ symbol. How do you remove this?

I don't follow you on that. Why is it that functions that contain caluculated variables don't show as available data elements in the graphing expert field list? I simply want to be able to show a variable on a graph.

Crystal 8.5 SQL Database I am trying to do a line graph that I want to display a variable that is a counter. I am counting the number of work orders grouped by type and time period and am using an incrementer for the purpose because the counter has to be in a group header/footer. How do I...

Thanks, that did the trick. SLK

CR 8.5 SQL Database How can I display the selection of multiple parameters that I have chosen on the report i.e. in the page or report header? I have a crosss tab that tabulates work orders based on date created and type, but I use a parameter that allows you to select which shops you have...