Search results for query: *

I had done that... my selection formula has been: {vwDownTime.DownDate} = {?Date} And Not(IsNull({vwDownTime.TimeDown}) And {vwDownTime.TimeDown} > 0) ttyre

I had tried both {MyTable.DownTime} > 0 and Not(IsNull({MyTable.DownTime])) without success.... Thanks, ttyer

I am trying to get rid of empty spaces showing in column chart in place of null values. I am plotting following fields: Category, Reason, Down Time, Date. Each Category has 1 to 5 Reasons. Not all Categories / Reasons have Down Time. In Chart Expert, Data tab, Layout I select: Place chart...

RT, Great solution! I applied my fields to your sql code and it works like a charm.... Thanks a lot! ttyre

John, I tried outer join... without luck... I am still getting Cartesian product if a number of rows in Child1 table is different from number of rows in Child2 table for a given ParentID. Ttyre

Need to join the following parent and 2 child tables: Parent ParentID Date Child1 ParentID Child1ID Qty1 Child2 ParentID Child2ID Qty2 When I run a query: Select Parent.Date, Parent.ParentID, Child1.Qty1, Child2.Qty2 From Parent LEFT JOIN Child1 ON Parent.ParentID =...

Can you change the size of the legend markers in CR 8.5? I have column chart for which I need to have bigger legend markers. Also, cannot change the legend font size if Legend Below Chart is selected from Analyzer / Chart Format / General / Look / Layout is selected. Any ideas? Thanks, ttyre

I was having chart resolution problems while exporting to PDF format. I followed Crystal Decisions Knowledge Base article ID: c2009714 which requires making some changes to registry and it worked! ttyre