Search results for query: *

Hi, I need to display Operator Names in my report. From the front end, this field can be created based on Role or User Name. When created by UserName, entries are created in Worklog.AssignedID and when created by role this field is null. For Role based, entries are created in LoanOper.OperID...

hi Peter, Thanks for your reply. I am looking to pull the values in crystal using sub reports. My idea is to implement each condition in a separate sub report. Is this possible.

Hi, I need to pull city names from property table. Property_id in property_table is mapped to prop_id in worklog_table. If prop_id is not null then I need to pull the city name If prop_id which is present in a worklog_table is null then I need to pull the city name but based on a field...

Hi, I have a database ( say master) and another database ( say reporting) which are two different SQL databases present in the same server. Now I need to add tables from both of them to pull data into CR. But the requirement says I need to use a single DB connection. How do I do that? One way...

Thanks Madawc.. That helped!!

Hi, I have two subreports in which there are fields which need to be displayed in the main report. Say, A is the result which is obtained from a formula field in 1st report B is the result which is obtained from a formula field in 2nd report Now I need to compare A and B and display the...

Lbass, spacing was the issue.. got it now.. Thanks alot!! you are the BEST!!

Lbass, I was able to get the minimum value. But when the minimum value is ">7 Days and < 60 Days" , it displays 0.00. It is displaying correctly for other data

Thanks for the advice.. I tried the above way. But it is displaying a value of 0.00 for the last formula

The below are the ONLY possible values. 3 Days 4 Hours NULL 12 Hours 7 Days 24 Hours > 7 Days and < 60 Days

Below is the sample data from the field, 3 Days 4 Hours NULL 12 Hours 7 Days 24 Hours > 7 Days and < 60 Days

Lbass, No. The field just has days and hours.

Lbass, I have links to the other table. Also the recovery time is a string field. Do I still need to convert the days to hours ?

Lbass, I will explain in detail below In my tables, there are 2 types of processes, Business and Baseline. Business process has a recovery time while Baseline process do not have a recovery time. They need to be related to their Business process to have a recovery time (which is present in...

Sorry but how do i create a formula to show the lower of the two values

I have two types of processes like A and B. say, If there are 5 processes totally Sample data: Process Type RecoveryTime Proc1 A 4hours Proc2 A 5days Proc3 B 8hours Proc4 B 3days Proc5 A 12hours I need to...

Hi, How can we set "can grow' option conditionally for a sub-report? Thanks in advance...

Apologies.. I did not give the option can grow in expert and builder.. now its working.. but a minor problem though Owner Builder Expert MARK RICK Owner Builder Expert MARK RICK Owner Builder Expert MARK...

I did like above.. This is how the data displays Owner Builder Expert Owner Builder Expert Owner Builder Expert A B Each Role name appears thrice.. For the Owner role, the user names gets pulled up, but for builder and expert it doesn't.. How can i solve this? thanks again!

GH1 - has the Subreport1. (grouped according to plan names) This inturn has 1) SubreportGH1-> grouped to roles (Owner, Builder, Expert) 2) SubreportGH2-> grouped to user names. details section of this subreport contains the user names and has been formatted with...