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...

...chart, those expiring in 30, 60 or 90 days)and showing all "Hardware under warranty") --> aka -subreport 1 2)user clicks on pie chart "Hardware *Out Of Warranty" --> user is taken to an other pie chart(breakdown of *OLD warranty chart, those expired in 30, 60 or 90 days showing all Hardware...

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...

...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 each critical flag on change of: future warranty expiration info show: count of...

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...

...3: computers with no warranty info. Non-Critical computers: same breakdown 1-3 as above. Tier 3: Computers under warranty is broken down to a * Bar char using the formula: (basically how many computers which currently have warranty will be expiring in the future) formula used: if...

...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 only "under warranty". Is there a way to specifically hide...

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

...placing them in report headers. I have tried the linking also ------.When i click on the pie section of the chart in the main report it ** shows me the relevant section of the sub-report ** BUT i see only the details of the sub-report not the chart in the sub-report. How do i see the chart...

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