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

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

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

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

My view (below) currently provides all of the info I need, but on multi-rows. I need it all on one row. SELECT PLGR.PROJ_ELEM_ID, PLGR.BID_CTGY, (SUBSTR(PLGR.PRD,2,4)) as ERP_PRD, decode (PLGR.PRD, '10212' , '200203', '10910', '200901') AS MPM_PRD, SUM_UNIT...

My view (below) currently provides all of the info I need, but on multi-rows. I need it all on one row. SELECT PLGR.PROJ_ELEM_ID, PLGR.BID_CTGY, (SUBSTR(PLGR.PRD,2,4)) as ERP_PRD, decode (PLGR.PRD, '10212' , '200203', '10910', '200901') AS MPM_PRD, SUM_UNIT...

I had a view that worked, but was really slow. The view is this: SELECT PLGR.PROJ_ELEM_ID, PLGR.BID_CTGY, ' ' AS RES, 'N' AS OT, (SUBSTR(PLGR.PRD,2,4)) as ERP_PRD, decode (PLGR.PRD, '10212' , '200203', '10301' , '200204', '10302' , '200205', '10303' , '200206'...

I have the view (below) working great. It is not throwing All I need to do is get one more value in there, but I am having trouble understanding what I am doing wrong! NOTE - field "R" is supposed to have the criteria 'sum_unit' = 'R' & the field "C" should be coming from 'sum_unit' = 'C' I...

I have a function that works like a charm in Oracle, and I need it to be in SQL so that a stored procedure in SQL can get to it...I dont understand what I am doing wrong -- definitely need syntax help. Can someone please, please swith this to SQL for me and then explain it so I learn how to do...

I know what I am trying to do, but not HOW to do it, exactly! I have a stored procedure in SQL that does this: ********************************* CREATE PROCEDURE [DBO].[BOM_SEARCH] @PART_NO VARCHAR(25), @1_PART_DESC VARCHAR(25), @2_PART_DESC VARCHAR(25), @3_PART_DESC VARCHAR(25) AS SELECT...

Using CR9 I developed a report with 6 parameters. I set them in the order which I wanted them to come up for users. I then put the report out on CE 9, and for some odd reason the report parameters are now listed "out of order". Example: Original report has 6 params @PART_NO [EMPTY]...

Reset never or on change of group, depending upon your needs. This assumes your only suppression criterion is {table.productionhours} = 0. I am using CR 9, will also use CE 9 / SecureView (if I ever get the report fixed!) Issue: Running total "reset" -- unsure how to achieve desired result...

I have a query coming off of ORACLE which works fine. For multiple reasons, I need to take this and modify so that it comes off of SQL (as a stored procedure). I am having difficulty with the JOINS - cant seem to get them to behave the right way. The ORACLE version = SELECT...

I am trying to do this in a view - grab the first 4 characters of a field only... In crystal it is like this: mid(fieldname,1,4) How do I do this in Oracle? LMC cryerlisa@hotmail.com select * from Management where proj_mgmt_skills <> NULL 0 records returned

I am using Oracle81. I have the following view which pulls in all of the data that we need: CREATE OR REPLACE FORCE VIEW MRPOWNER.CYCLE_COUNT_3 (TRANSACTION_CODE, SUBCODE, PART_NBR, PART_DESC, PART_CLS4, ABC_CODE, LAST_COUNT_DATE, STATUS, CINCOM_QTY_ON_HAND) AS SELECT 'INVADJ' AS...

I am in CR 9, reports deployed using CE9. I have a report which brings in data (correctly) grouped by 2 things - Group A = Project Number Group B = PRD (period) = this is a 4 digit number representing fiscal year, fiscal period The problem is that the user doesnt want to SEE it in the 4 digit...

I am in Crystal 9 - report will go into CE9. I understand exactly what is WRONG but not how to fix it! OK - report is for fiscal periods, bringing in records and needs to do several different sums (for graphing). I have 2 tables that are unlinkable (no option of changing them, either)!! 1 is...

I am in a CR 9 and CE 9 environment. I have a report that deals with fiscal month / year data. The report works great, but I need to set it so that the report KNOWS (at runtime) what fiscal year and month the CURRENT date is in. (I need this so that I can tell the system to go and pull 3...

I give up! The page server simply refuses to cooperate and I am at a loss as to how to go about troubleshooting. Situation: We moved to CE 9 a few months ago, and from the get-go we've had issues with the page server. It simply STOPS performing - and to get it to restart we have to go into dos...