Search results for query: *

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

Gentlemen, it is easy to see that the answer to this question is 4 [cow] Eileen McEvoy Authorized Crystal Engineer Crystal Reports Consultant and Trainer www.crystalconsulting.ca emcevoy@crystalconsulting.ca

hi If you are looking for a roll up for the day for, you can use the dagent table and use the sql as select uday, ext_num, dur_signon from dagent where uday = 1030307 uday is the date field (1030307 = March 7, 2003) dur_signon is a rollup duration of signon time ext_num is extension number...

Hello I have written an FAQ on how/why the ocx will not register faq768-649 . Take a look at this and let me know whether you need further information. Hope this helps. Eileen McEvoy Authorized Crystal Engineer Crystal Reports Consultant and Trainer www.crystalconsulting.ca...

Hi To locate the error log, you can produce the error again and then do a search for a event.log file with the date/time of the error. This will give you the location, you can then open this event.log file and should give you the date, report and event that happened. for example, 12/08/02...

Hi Another way you can do this is to use the DTSToDate() function. You can find information on using this and other date functions in the crystal technical document at the following link http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr567_datetimefunctions.pdf Hope this...