Recent content by FishKiller

I am attempting to create a Gantt cart using CR9 Pro and SQL 2000static table. I am using the report wizard and cannot seem to get this to view properly. I want a Gantt chart which covers one full day only. This day will be sub divided into 15 minute increments and will show when a job...

Thanks for all your help LB. You did not recommend the 1 to 100 I changed this to give an actual percentage reading. The sloppy comment was directed towards my lack of programming skills. The instructions you gave for creating manual cross tabs are AWESOME and SIMPLE. This works better than a...

I looked at some of your past post and found one that indicates the same. There was a clue about using "Weighted Averages". I did this and changed the formula for @TA_UNDER from [... then 1 else 0] to read [... then 100 else 0] and added this to the cross tab changing the summary to Weighted...

LB- Sorry for the confusion and thank you. I always assumed a manual crosstab was a crosstab which you inserted formulas instead of actual fields. You know what they say about assume. I actually have the "whileprintingrecords" in the formula and have them inserted into the crosstab. I am not...

CR 9 PRO, SQL 2K USING STATIC TABLE. GOAL: I need to be able to indicate what percent of procedures were actually completed under 4 hours. 1st step: Create formula for manual cross tab to include total procedures performed during the same day. (This works) After creating this formula I added...

You might have a better solution all around. I am tring to create an expandable chart that allows users to see items sold across the top and dates grouping in months then weeks then day. Due to the mess of numbers I want it to only show months until you expand on a certain customer then show the...

I am using CR9 and SQL2000. The report I am creating shows Monthly totals in group 1 then weekly totals in group 2 and then daily totals in group 3. I do not want group 2 or 3 to display until I drill down however, once I drill down it opens (by default) to another tab. Is it possible to have it...

All of the data types match. I did some changes that seem to work however, not the way I want them I think I am going to have to use a custom front end. I am tring to get the parameter to only show depending on the {?Group 1} answer. EX: Group1 = "Modality" then a second parameter shows...

OK, Thanks for the help. Let me attempt to explain what is happening: When I use only: If {?Group1} = "Modality" Then {NDC_VR.Modality} Crystal formula works correctly returning no errors as it should. When I attempt to change the last line {NDC_VR.Modality}={?Select Modality} I get "A...

Thanks for the post sorry about the delay on getting back to you. When I use the code below I get an error message which indicates it must be a string. I rechecked the parameter's {?Group1} and {?Select Modality} to ensure they are both set to string. Any suggestions? If {?Group1} = "Modality"...

LB this is probably for you. I am running CR9 and SQL2K. The report that I am tring to create allows the user to select each level of grouping and from their selection allows them to select exactly which values they want in the parameter. This is what I have so far: In the first group I have a...

I am running CR9Enterprise with SP4 and a SQL2000 server. I have created a report using CR9 Pro and have added several parameters. Is it possible to change the type of parameter from a default drop down list to a check box style.

Sorry for the delay. Had an emergency. This worked perfectly sometimes thinking backwards helps.

I am running CR9 and tring to get use simple sum from SQL2000 returned values. Some of the customers have duplicate ID's and duplicate product id's so I am surpressing the duplicates by using a formula in the Details section expert: if not on firstrecord then {vr.id}=previous({vr.id}) and...

It works like a charm!!![thumbsup] Can I use the {@displpetct} formulas which are in the footer in a crosstab or charts? I have added 15 different combinations using your formula sample AGAIN THANKYOU!!!