Recent content by emcevoy

Hi, I am looking for some suggestions on gridlines in Crystal reports for enterprise. Seems they have stripped a few options out in this version compared to 2011. In 2011, I can format my chart force the number of divisions on the Axes to Five, which is what the requirement is; however, in...

Thank you! that is what I was missing was the gridrowcolumnvalue, I knew it was something simple. thanks again Eileen Eileen McEvoy Authorized Crystal Engineer Crystal Reports Consultant and Trainer www.crystalconsulting.ca emcevoy@crystalconsulting.ca

Hi lbass. the summary is a sum of a formula and the catagory would be 'white percent' thanks Eileen McEvoy Authorized Crystal Engineer Crystal Reports Consultant and Trainer www.crystalconsulting.ca emcevoy@crystalconsulting.ca

looking for some help here. Have a crosstab rows Column year TypeSort (showing type) Year CatagorySort (showing Catagory) Summary fields Sum(Formula) this works great, however what I want to do is based on the catagory I want to...

looking for some help here. Have a crosstab rows Column year TypeSort (showing type) Year CatagorySort (showing Catagory) Summary fields Sum(Formula) this works great, however what I want to do is based on the catagory I want to...

Hi Vongrut, I so agree with you on the torture on this one. The m/d is every day of the year with no date attached. the data in the table has what the equipment did for that day and the table which has the dreded m/d field has what the targets were for that day. this is the stored proc I...

Hi I have a table that was created where the date is stored as a m/d and this is causing me real grief. I need to do a look up to it and test this against a real datetime field in a stored procedure. I need to put add this table and link on this goofy field to another table in the stored...

hi I am wondering if any of you have any samples of using a UFD in a stored procedure to pass the function a datetime. I am using crystal reports which cannot see UFD's but can pass a stored proc a variable. If anyone has any samples I would be extremely greatfull! thanks Eileen McEvoy...

hi I am wondering if any of you have any samples of using a User defined function (UFD) in a stored procedure to pass the function a datetime. I am using crystal reports which cannot see UFD's but can pass a stored proc a variable. If anyone has any samples I would be extremely...

hi, Thanks for the info. will give that a try. as for the logic, what I need to capture is the stike of midnight. the way the database and the data is, this does the trick, anything else seems to miss it. thanks Eileen McEvoy Authorized Crystal Engineer Crystal Reports Consultant and...

Hi, I have a report that has the following record selection formula. ({tblEmpEvt.EmpEvt_RegDt} >= currentdate -1 and {tblEmpEvt.EmpEvt_RegDt} < currentdate) or ({tblEmpEvt.EmpEvt_FirstLaunchDt} >= currentdate -1 and {tblEmpEvt.EmpEvt_FirstLaunchDt} < currentdate) or...

Hi Newer person to Business Objects here and have a question. I know that an object embedded in a bo doc only shows up in webi .... you can not go into the doc any ideas other than ole to get a word doc in a report? Any Help will be greatly appreciated. Thanks Eileen McEvoy Authorized...

Hi I am in need of some help! I have a report with formulas I need to pass values to. I am using this code: cryTwo.DataDefinition.FormulaFields.Item(&quot;Jan3&quot;).Text = &quot;Hi&quot; to pass Hi to an empty formula in the report. when I go to run the report I get the following...

Hi Unfortunately, this is not something that is possible with Info Desktop. When Aspect bundled in the Crystal into their system, they made the necessary adjustments in runner to enable this, basically goes thru another step in Runner before the final export. Crystal Decisions have not...

Hi, I am wondering if anyone out there has come up with this issue. I have variable that calculates a number. I have formated the cell to show 0 if undefined. then in my alerter I have >= <mynumber> then green < <mynumber> then red = <mynumber> then yellow My issue is that the alerter...