Search results for query: *

Thank you fisheromacse , a very good idea.

Hello everyone, need some help to build a logic formula. I have 3 groups and sample data as below GH1 CA GH2 Santa Barbara GH3 94015 Det 10 S RA 20 A PA 30 S JA where ever I have Value as S in second column, i need to sum up those values separated by / and show data like below 10 S RA/JA 20...

Hello everyone, need some help to build a logic formula. I have 3 groups and sample data as below GH1 CA GH2 Santa Barbara GH3 94015 Det 10 S RA 20 A PA 30 S JA where ever I have Value as S in second column, i need to sum up those values separated by / and show...

It works like charm thanks so much.

Friends need help on doing a running total like reset on Previous function Example: AA CA 123 AA CA 101 AA CA 341 AA MD 231 AA MD 222 should be shown as AA CA AA CA 123 AA CA 101 AA MD AA MD 231 1st and 2nd fields are groups. and first value of previous should be null. Any help...

Hello I have a simple store procedure whihc is created to insert records into other table. I like to execute this store procedure from Crystal reports command statement. It does not have any parameters. I use Oracle and Crystal 2008. When i say exec ABC in command, it throws error. Any help...

Problem was with access , direct access to the tables...seems for store proc i need direct access to the tables. Now it is working fine. Besides that I am creating this store proc because my query was running very slow I was using DB links to. I was told instead if i use store proc or...

I have created below but i get same error when i execute the procedure. BUt when i remove the table to DUAL it runs fine, when ever i use real table i get error. CREATE OR REPLACE PROCEDURE ritheshest IS Emp_number integer; BEGIN SELECT count(distinct BCBS_ASSOC_PLN_CD) INTO...

Thank you all, I will try the above solution, I am new to store procs in Oracle. I will rephrase my store proc in above format

Hello thanks for quick reply. I am new to store procedures since my select statement was running slow, i thought I will create Store procedure on my select so that it might help fasten the query. I get below error. ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in...

Hello I have a created a store proc on a simple store proc, but i get error , please help CREATE OR REPLACE PROCEDURE p_procedure2 IS BEGIN Select PROVIDER.PROV_ID_NBR, IDS.PROVIDER_TYPE_SPECIALTY.PROV_TYP_SPCL_USG_CD_SK, PROVIDER.PROV_FULL_NM, IDSXREF.PROV_TYP_SPCL_XREF.PROV_TYP_CD FROM...

Friends I have multiple subreports and places in different headers. One of the subreport has less data and has lot of blank space, i tried supress blank space, but i can still lot of blank space in the bottom, any way to supress it?

LB only problem how will it know min and max on string field.I did other way i did difference on the currenttimestamp and datetime field and converted the difference value to text and attached into colum 2 totext(@diff)+" "+field2 which is a string. Then i was able to do min and max since it has...

Hi friends Need help on below, I have records like this T1 abc1 10/20/1008 8.00.00 T1 abc3 10/20/1008 10.00.00 I want to show this as t1 abc1 abc3 Basically i like to min and max of recirds for the time stamp. Max(column2,datetime), etc Any help on this?

LB it works like charm whenver it has .com it would grab only till .com or else returing the original value. Thanks!

Friends I need help on a formula I have field with values like opslib.vip.smf.ebay.com or opslib.vip.smf.ebay.com-8091 ,etc I want to capture the value till only .com , is there a way to do it? right now I am already using formula to eliminate few values stringvar str1:=...

Friends Is there a way I can supress the rows or colums in Cross tab if the row total is 0? . Also I have percentage value i want to insert into cross tab and I want to get rows and colums for percentage <50%. Any help would be great. Thanks a ton. Tob

Friends I have a small question on shared variables, I know how to pass them from sub report to meain report. I was just wondering when to use reset formula, do i always need to use it?. GH i have subreport, GHa i have shared variable placed.Its working fine now, but would like to know when i...

Friends I had to put 20 fields on the report. SO i selected page setup , document image writer and manauly increased the page size. I can see it fine from designer. How in info view I am not able to view all the fields. Any help?

Friends I had a very long report, so I did change the display to tabular form and changes printer settings to Micrsoft Image viewer so I can increase length of my report. I am able ti view report from Crystal. But not able to see it from Info view. Any help on how to resolve this? or is there...