Search results for query: *

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

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

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

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

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.

Hi, I am trying to create a parameter for the account_ID field. I need to set this up so that all values appear in the drop down list when the user runs the report. There are 6602 account IDs. I also need to display the account description. When I click Actions -> Append all database...

Hi, I have a report that displays 3 columns of data in the details section. I’m basing a line chart of this data. I need to restrict the data so that it displays only the last 6 weeks from the current date. I’ve looked at the Last4WeeksToSun function thinking I could use it but I’m not sure...

HI, I have a simple report where I am displaying the following: kpi_curr_dttm kpi_curr_val I need create a formula field that will show the change week over week for the kpi_curr_val. The report currently looks like Kpi_curr_dttm Kpi_curr_val 10-Sep 78,762,764,312 17-Sep...

Hi, I need to format the value of a date field to this format: Jan-00 The date is stored as 01/10/2010. I think I need to start with the DatePart function but I’m not having any luck. Any help would be much appreciated.

Is it possible to convert a string to a number if the value is ‘(27.10) bps’? I tried ToNumber({@3ML Spread: New DNs string}) But got the error ‘The string is non-numeric.’ Is it not possible because there are letters in the value? Thanks for any help. -Shannon

We have an application where users enter values and also enter the format that the value is supposed to appear. The purpose of the application is to allow users to enter data that will feed some tables which will then be reported against. For example: Table1.kpi_value has a value of -27.10...

Hi, Can someone tell me what’s wrong with this formula? I’m trying to set the condition in which the {TRANSACTION_REPORT_VIEW2.TXN_COUNT} field displays a value. I’m getting The keyword ‘then’ is missing’ Can I not do or if? I think I’m missing something really obvious. Any help would be...

Hi, I’ve got a Crystal Report that has two groups: Group 1 is the transaction type and Group 2 is the Month. I am trying to sort Group 2 chronologically so that the months are in the right order. I’ve been looking at the Group Sort Expert and Record Sort Expert but can’t figure it out. The...

I’ve got a report that compares the current month’s data to last year’s data for the same period (example: comparing August 2009 to August 2008). I set this up by using the following in the select expert which takes care of it: {INVOICE.INVOICE_DATE} in {?Start Date} to {?End Date} or...

I have a report that has a parameter on a date field (invoice_date). The report lists details like customer, invoice amount, etc. The invoice amount is summed at the customer level group to show the total invoice amount for the period entered in the parameter. The user is asking have another...

Hi, I’ve got my main report with 2 sub reports. Sub report 1 is placed within report footer A and sub report 2 is place within report footer B. My question is when I export this to Excel, (MS Excel 97- 2000 – Data Only) an empty row is added between where the main report ends and where the...

Hi, I’m trying to write an IF ELSE THEN query in Access. I’m trying to write the query so that if table1.column1 = table2.column2, then table2.column2 else table1.column2 Here is my syntax I’ve used in the query builder: IIf([Customer_template_09252008]![Country Code]=[Country...

I’m new to Webi/Universe and I’m trying to create a report that when the user runs it, they will be prompted to add values to the filters that exist in the report. I’d like it to behave the same way Crystal Reports does when a parameter field is included in the report and the user has to enter...