Search results for query: *

I have a stored procedure which works and provides data. I now want to add more to it, and I am having syntax problems. The sp is provided with a start date and and end date viua parameters and then provides data grouped by week. I am trying to add the following to the sp and any help would...

Crystal Reports 9, CE 9, Active X viewer being used. I have a report that has sensitive pictures in it. It needs to be viewable, but NOT allow printing, exporting, or copying the pictures out (by right clicking on the picture and selecting COPY). I've been able to fix the EXPORT and restrict...

Interesting. We had this EXACT same thing, the day after our network folks were messing with the NIC cards. They swore up and down it couldnt possibly be that, and we spent a full 8 hour day messing with the darn thing!!! Of course, its never the networlk folks =) LMC LMC

Check the # of threads you are allowing open on your page server. We had it set to "unlimited" and nothing but trouble. Set it to 50 and it started behaving just beautifully. LMC LMC

Dunno if theres a difference in terms of "damage" but I was fed up with the processes not letting me STOP them, so I just go in aod do a cmd kill proc id. Works every time. LMC LMC

I know this is a weird approach but we were struggling with the same problem. Our solution was to KILL and restart the page server (not a good one!) One day I was fiddling around and found some info that stated the # of threads you have on your cache servers must equal the # you have set as...

Do a KILL command (KILL process id). LMC

We are using CE 9, CR 9 - When opening CR, I can log into the APS with no issues. Maneuvering through the file structure is no problem, it is fast and smooth (we had a problem with this some time ago, its resolved). However, clicking on any report and then trying to OPEN it does not work. I...

Wow, that was fast! Thanks, it worked! (yea, I wanted to make a table, but my data's in oracle and we dont have a way to make the table in there (controlled instance from corporate) Thanks! Lisa LMC

Using CR 9, trying to find the first day and last day of a week based on the weeknumber (provided by the system). I've tried datepart, datediff -- getting really weird data. Does anyone have a formula already built for this? Example = week 1 (jan 1 through jan 7 ) for 2004, the first day...

It is in my CMC and it is not customized (as far as I know!) Maybe I am just bonker. We did have DMG come in and do our install, but thats about it!? LMC

I have a button to the left of my New Report button that is called "New Excel". Our CE was set up for us, we didnt do it ourselves. I am unusre if it was part of the "real deal" or an add-on. I will shoot an email to our DMG contact and post whatever I find. LMC LMC

When you go to add a new report, theres an option (a button) that says "New Excel" thats by the "New Report" button... LMC

Not very well! I can get it in by using "New Excel" -- but if you change the Excel sheet, the change doesnt carry over into CE (because you're changing it somewhere else, not on the CE server).... I resolved this the hard way, I suppose, but it works! I created a little Crystal report, with a...

I didnt export it, I literally typed it into Excel. =( LMC

I'm using Crystal Reports 9, Crystal Enterprise Pro 9, and Excel (MS Office 2000) I've been asked to put together an excel sheet which shows the following information: 1. Folder structure 2. Report Name, Version#, & Report Description 3. Report "owner", Owner's Title 4. Date of validation...

I know, but I need it controlled within Oracle, and not within the VB app that is being built. I would really prefer NOT to do it this way, but the higher powers that be wanted that.... =( LMC

GOT IT! That was really close, I just had to tweak my grouping a bit. Posted below is the final version of my view. Thanks SO MUCH!!! SELECT PLGR.PROJ_ELEM_ID, PLGR.BID_CTGY, (SUBSTR(PLGR.PRD,2,4)) as ERP_PRD, decode (PLGR.PRD, '10212' , '200203', '10301' , '200204', '10302'...

GOT IT! That was really close, I just had to tweak my grouping a bit. Posted below is the final version of my view. Thanks SO MUCH!!! SELECT PLGR.PROJ_ELEM_ID, PLGR.BID_CTGY, (SUBSTR(PLGR.PRD,2,4)) as ERP_PRD, decode (PLGR.PRD, '10212' , '200203', '10301' , '200204', '10302'...

Nope, that wont work - mostly because the columns need different criteria. I think I need a subquery but dont know how to do this? The data for column 5 AND 6 comes from ONE db.field, and is split out by different codes in another field (so to speak). Any other ideas? LMC