Search results for query: *

Original DateRange formula: //WhilePrintingRecords ; Global DateVar Range DateRange ; DateRange:= (if {?Date Range} = "Last 7 Days" then CurrentDate-7 to CurrentDate else if {?Date Range} = "Last 30 Days" then CurrentDate-30 to CurrentDate else if {?Date Range} = "Last...

Attempting to round time to 2 decimal places. The result of formula gives value: (58:59 when rounding to 2 decimal places, but when rounding to 4 - 57:59, the value is correct) Formula is: totext(abs({procRptIndProdUserModuleTime;1.TotalTime} / 3600),"00") & ":" &...

i have a crystal report that will run on a scheduled basis. The crystal report contains a box that is editable field. The instance will be in the format of a pdf file and will be emailed.Once emailed, can the pdf be opened and can user edit the field and type in the editable field box? Also is...

I have a report that looks like a chart but it is created using lines and boxes. There are 3 columns and 3 rows looks something like this. It suppose to look almost like a crosstab but it is not. There is data in column 2. Column 1 and Column 3 have calculatoins that are based on Column 2 so...

Hi I would like to know how to create a conditional double page breaking in crystal report thank you

Hello, I use the left, mid and right function to parse this string but am not getting it accurate. This is the data from the field: can you help with formula? Original: ABCDEFGHIJKLML - 12345678 - HelloWorld The output should look like this without the word "Original" and the "-"...

hi I have report that run daily but it is reporting full history everyday instead of just previous day or last 24 hours. I have a start and end time. My end time formula looks like this: Local StringVar dt; if isnull({AP_FinishedInstances.SI_ENDTIME}) or...

Instead of importing webi objects from one environment to another, is it possible to export the universe's xml file and then import it to another environment?

I have a crystal report that is scheduled to run on a daily basis The report has 2 parameters, a start and end date. Since the report is to be run on a daily basis, by selecting a start date and an end date would only give me the data between and including those dates, no matter if it is run...

Hi I have a crystal report The only issue I am now having is to not display the records if there are no data. The report is saved with data. It is filtered based on 4 parameters: location, start date/time, end date/time and processing time. The processing time is placed in a suppresion...

I have a field called line number. The type on this field is number I would like to suppress if there is there is no data showing. I am trying to write the code in the section formula of a group header under the suppress section. {Line.Line_number} = null is throwing an error indicating that...

I currently have a start and end time parameter and a processing time parameter. Is there a way to allow it so that these fields can be left blank and when the report runs, it will run for all records.

I have start and end times and have calculated the time elapsed which is difference between start and end time. I would like to calculate the average of the elapsed time. A formula field has been created for elapsed time. The code is as follows: Local NumberVar sec := DateDiff...

I am planning to create another schema for a new set of reports in a same database. I would like to know if this change of creating a new schema would impact DNS or new DNS need to be set up if the new reports point to a new schema under same dbase ?

Hi I was wondering if you can tell me how I can code this: There are 5 dates/times with start and end in the format below: Start End 01/05/2010 02:44:47 01/05/2010 03:22:09 01/05/2010 02:37:59 01/05/2010 07:16:27 01/05/2010 02:40:00 01/05/2010 03:23:03...

I set up for example: 4 parameter prompts that prompts the user to enter values to filter the return of data. All my parameters are static parameters and when I hit refresh, i would need to fill in the 4 fields. Field 1 Field 2 Field 3 Field 4 Is there a case where it's okay to just fill in...

I found this code for date ranges to choose from one one of the forums (see bottom) but I would like to have it so I can choose the dates using a calendar picker. How can i modify this code so to have the user choose from a date time picker calendar to display the dates and time in this format...

Hi, I'd like to know how to create a parameter for a report so that it is an optional parameter. User can decide to choose value or leave blank. Thanks.

I have a formula field that calculates the totals or sums the elapsed time. I would like to highlight or create a formatting field that will highlight all elapsed times that are greater than 25 minutes. This is my formula field for elapsed time at the group footer: Local NumberVar sec := Sum...