Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by emcevoy

  1. emcevoy

    Crystal Reports for Enterprise Charts and Gridlines

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

    format crosstab cell conditionally

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

    format crosstab cell conditionally

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

    format crosstab cell conditionally

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

    Crosstab Cell formatting

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

    varchar "1/2" convert to date

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

    varchar "1/2" convert to date

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

    UFD in Stored Procedure

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

    Stored Procedure vs User Define Function

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

    record selecton only evaluating first block

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

    record selecton only evaluating first block

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

    embedded doc in Report

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

    Remaining text error passing formula value - Urgent request

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

    Exporting Crystal Reports With Date In File Name ?

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

    Alerters and undefined variables??

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

Part and Inventory Search

Back
Top