Search results for query: *

Great - thanks!

Hi, I created a variable where the formula is =Sum(MonthsBetween(Min([Timesheet Start Date]);Max([Timesheet End Date]))) This works as expected but there are instances where it returns 0. If it returns 0 I need 1 displayed. I’m not sure how to add this syntax in my variable (if 0, then 1)...

I’m attempting to use a Sybase stored procedure in my Crystal Report. In my stored procedure I have parameter that I’ve defined as a date. However, Crystal Reports is recognizing it as a string. When I refresh the report and uncheck ‘Set to Null’ and enter a date I get the following error...

Adding this table without any joins give me the following error when refreshing the report: ‘Failed to retrieve data from the database. Details: Only one command can execute at a time.’ It’s generating two sql statements which Crystal Reports cannot handle. My next step is going to attempt...

Hi, I have a report where I need the eff_date to = a value in a table that is not able to be joined to the tables currently being used in my report. There is a calendar table within our DBMS that has 4 columns (date_id, prev_bus_date, curr_bus_date, and next_bus_date). It always has only one...

Hi, Please disregard my earlier post. This got me what I needed. DateAdd ("s",{metric_hist.numeric_qty},{metric_hist.datetime_dttm} )

Thanks for your response. I created a formula field using this following syntax: WhilePrintingRecords; Local NumberVar x := {metric_hist.datetime_dttm}; Local NumberVar H := Int(x/60/60); Local NumberVar M := Int(x/60) - (H*60); Local NumberVar S := x - (M*60) - (H*60*60); DateAdd('s', S...

I need to create a formula field that adds time in both hours and minutes to an existing database field. I have a start date/time and need to add the duration to create an end date/time. My start date field is metric_hist.datetime_dttm. I have a @Duration field...

Sorry for the late response - that worked. Thanks!

I have a report where I have a DateTime field and I need to add time to it to create another field. Field 1 is Start Date Time. Field 2 is a formula field where I converted seconds to hours. ({metric_hist.numeric_qty}/60)/60 Field 3 needs to be End Date Time. I need to add Field 1 and Field 2...

Hi - Thanks for your response. It turned out that I needed to do a right outer join but its still the same idea. The only thing I'm still unclear on is if it should be Not Enforced, Enforced From, Enforced To, or Enforced Both. I've currently got it set to Enforced Both which seems to be...

Forgot to include subject - sorry. This is regarding linking tables.

Hi, I am having a problem displaying data and I believe it is related to the way my links are set up. I have 3 tables: Nps_initv_proj Nps_cap_initv_outlay Nps_exp_initv_outlay Initv_proj_no is what I am joining on amongst the three tables. Here is my problem: I have an example of where my...

Thanks LB - I've got everything working now.

After looking at this further it looks like there are spaces, not null values in this particular field which is likely why I'm having an issue with this. No need to respond. Thanks again.

Thank you for your responses. They were very helpful. One last question - I also have some text fields which are appearing in Crystal Reports as memo fields. There are null values in the database and I’d like to highlight those with a color. I created a formula field: if...

I'm running in to a problem when trying to do this for a number field. Here is an example of what I've done for the string fields: Created a formula field if isnull({nps_initv_proj.proj_process_code}) then " " else {nps_initv_proj.proj_process_code} Placed that formula field in the details...

Thanks LB - this works for what I need. Unfortunately I need to create a lot of formula fields.

Hi, I am trying to highlight the null values of a field in my report. Is it possible to use the highlighting expert to do this? I set the value of my field to " " but it didn't highlight the null values. I'm using CR 2008 ver 12.3. Any help would greatly appreciated.

Also, I’m using a dynamic prompt because the account IDs change occasionally. I’m not sure if that matters but my earlier post about clicking ‘Append all database values’ doesn’t apply when using dynamic prompts. It still doesn’t bring in all values though.