Search results for query: *

Lb, Do you have your own CR consulting service or signature like ken hamady does? Regards, Jk

Thanks Jk

when i use: if {table.field} = 0 then isnull({table.field}) else {table.field} the last part {table.field} --> gives an error saying "a Boolean is required here. Jk

The field is a MAC address. I am thinking of right clicking the field. Common tab, suppress and in the x+2 write the following: {mac address_value}= "0" u think this would work ? I am using crystal v 10 thanks Jk

hi I am using crystal version 10. I have a field which sometimes have no data. For such results I would rather see the field as a blank rather than see zeroes. Please advise Jk

For a simillar chart i did the following: "Warranty Expiration Forecast For"+{@Criticality Flag}+" Assets" {@criticality Flag} formula: if {parameter.field}= "Y" Then "Critical" else if {parameter.field}= "N" Then"Non Critical" else if {parameter.field}= "{ALL}" Then "Critical/Non...

hi, I am using crystal v 10. I have 2 groups for my report group 1 ---> hardware criticality (Y/N) Group 2 ---> future warranty expiration info **@hardware criticality formula: (please end of this thread) **@Future Warranty expiration info: (please end of this thread) I have made a graph...

Lb, Your assessment is right. I guess I have to go with sub-reports then. I am following your advise on the sub-report idea "----You could suppress the unwanted charts using a section suppression formula that identifies the unwanted group instances and uses the drilldowngrouplevel function."...

LB, I am using your advise (your last comment). Also, If i have 4 groups: 1)Critical 2)Warranty expired (formula) 3)Future warranty expiration info formula) 4)Old warranty expiration info (formula) AND I created a summary for groups 2-4 so I can activate the "group layout" in the Chart...

I have 3 -4 groups. Their order is: 1)Critical 2)Warranty expired (formula) 3)Future warranty expiration info formula) 4)Old warranty expiration info (formula) I made a summary for Future warranty expiration and so activated the *group chart expert. What I want here is to: Place chart: for...

Ian Waterman: Regarding what you said earlier: "----You can then put a chart in there with specific headers and chart for the data you want" computers with warranty needs to be paired with Future warranty expiration formaul Computers that have warranty expired needs to be paired with Old...

If i want computers with warranty I will need to suppress the other two. But these are not columns but formula created by me: ( if isnull({comp.warranty_end_date}) then "compWith NO Warranty INFO" else if {comp.warranty_end_date} <= CurrentDate then "comp Out Of Warranty" else "comp Under...

Below is the breakdown of the report; Tier1: Computer are categorized into Critical and Non-Critical Tier 2: Each of the above (critical and non-critical) is further broken down into a pie chart having the 3 sections: (using formula) ( if isnull({comp.warranty_end_date}) then "compWith NO...

When the second chart appeared, I want that to be clickable so finally it should show me the details section. Secondly, When i click on computers under warranty, the drill down shows me the bar chart for * ALL the 3 categories under warranty/no warranty / out of warranty when I want to see...

u are right on: "--I am guessing you have them linked by your warranty expired formula." What do i link on? Also, When i click on the pie chart for comp under warranty - I want to see the sub-report on GHa. Ditto for the other two also Jk

I have put the 3 sub-reports one in each group header. GH 2 uses a warranty expired formula: if isnull({computer warranty.end_date}) then "comp With NO Warranty INFO" else if {computer warranty.end_date} <= CurrentDate then "comp Out Of Warranty" else "comp Under Warranty" so GH 2a:comp...

LB, I did not quite understand this part "-- If you hide group #2, the group #2 chart will appear when you click on a group #1 pie slice. You would also hide the detail section to then click from group #2 pie slice to details." What I am trying to achieve is...

anyone pleaseee. TIA Jk

Hi, I am using Crystal Version 10. I have one main Report with Page 1 having a cross-tab as well as 2 pie charts. The rest of the sections in this main report are all suppressed. Now I have 3 sub-report which are based off of the pie charts. Which each section of the pie chart representing...

Hi, Would you please recommend: Data matrix plugin for Crystal Reports version 10? (free or $$ software plugin) and any instructions to go along with it would be very helpful :-) TIA Jk