Search results for query: *

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

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

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?

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?

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

Friends I have three groups and drill down setup, I have subreport placed in Report footer which has 3 groups with drill down. When i Drill down on Main Report can it automatically drill down the Subreport too to next level?. Any help please? Tob

Friends I have 2 columns offiname and office location I did group on two of them and moved the field to group footer two, and data comes up likes this ABP 01 CNV 04 DKY 09 i would like repeat these data like two sets in thi way ABP 01 CNV 04 DKY 09 ABP 01 CNV 04 DKY...

Hello friends, I been trying to create a formula to get all the months based on current date and I want to group on it. I know in SQL i create this, but wondering if there is a shortcut way to do this Crystal Reports too. Ia using XIr2. Thanks in advance, Toby

Friends I am getting this error when trying to publish a report "Reason: Failed to read parameter object" I have a main report and sub report and trying to get all dynamic values from main report and passing them to subreport. It runs file in Crystal Reprots, but when i try to publish the...

Friends, I have written a SQl qry in command statement and i would like create a parameter on Names , it should automatically display what are current values present in database for user slection. In the report fron end i created parameter and selected option Dynamic and then insetred name...

Frieds I have a field Firstname,Lastname i like write a formula to break it into First Name and Last Name as two separate fields. Thanks in advance for your time and help. Toby.

Hello friends , I have a small question. I have three paramters and I have subreport where I pass values to main report, I linked subreport to main report on those three paramters. I have grouping on amin report, I placed the subreport in grp footer 3a and in 3b below section i am showing...

I have a similar problem like yesterday but instead of minimun I have to do average. What I am thinking is convert the time to number of seconds and do average?. Any good ideas?, or how to convert the time to a number to I can do average of time?. Is this a good idea? or any better solution for...