Search results for query: *

Hello, last week i lost my remote desktop profile, and several environment settings have been reset. I have CRD, by ChristianSteven, a 3rd party product to schedule/automate my crystal reports. When i'm trying to use CRD to generate a new schedule i keep getting the error "LOAD REPORT...

I apoligize in advance if this is the wrong forum, if so please let me know where to post this question. I have a need to create a task that runs daily, that runs a batch file ? that will rename a filename from today_2015-04-17_16h03.xls to today.xls plus the filename is on a share drive...

I have a report i'm building. One of the fields(WWNS) returned contains a list of "," comma separated variables. I'd like to split this field, and populate a new row with the same data, but just adding an element each time from the split field. LUN Service Level LUN Capacity (GB) LUN Used...

I have cr11 and I have this formula :- evaluateafter({@Create cluster}); global stringvar clustergroup; global stringvar currenthostorhbaalias; if "Orphan" in {@Get current hostorhba} and clustergroup <> "" then uppercase({@Get current hostorhba}) + " Possible Host(s) = " +...

I have a report with a details section, and 1 subreport. Every section in the report except the subreport is suppressed. But when the report is exported, i always get a blank row.(row 1), and my data starts on row 2 I am exporting to Microsoft Excel(97-2003) Data-only. I have tried many...

[smile][dazed]This is the data :- Policy Data Device GB used Period days Bronze-VTIER15-*25.00*Bronze-VTIER3-*75.00* abc 34.14 31 Gold-VTIER0-*5.00*Gold-VTIER15-*30.00*Gold-VTIER3-*65.00* xyz 620.38...

if there an easy way to accomplish checking date range other than using month(currentdate)and day(currentdate) ? Using current date i want to check just month and day i.e. if (currentdate) is equal or between this range //16-Nov 15-Dec Then "January" else if (currentdate) is equal or...

I have a formula that "Joins" data to create a single string. uppercase(Join(data,",")) This formula can return strings in excess of 255 characters. But when exported to excel, if the 1st row is not > 255 characters then the field type is String[255] and some data is truncated. When...

I have a field which is a number(its a formula created from a number field in an oracle 10g db i.e. {table.field}/1024/1024), when i export the report to .xls or .xlsx and verify in excel it is a number, and i sum, etc, etc. But whenever i try and create a report with the same .xls or...

When i export a report to .csv format AND the report has a formula to suppress some rows from details section, the exported data contains blanks rows for those rows that have been suppressed. When i remove the suppression formula, data is exported in .csv format without issue. I using all...

I have a .xlsx input file, defined as a linked/ODBC(RDO), so the file will always contain the latest data. I created a report and it works fine. However everytime i refresh the report with the new data, i always get the message "Failed to retrieve data from the database", followed by...

I have a details scetion with a formula in section expert to suppress some rows. It works fine and only the data rows i want are displayed. However, when i create a gruop, i get group names for elements that have been suppressed. Any ideas what the issue may be ? i have dome this sevceral...

I have 2 db's, access(.mdb) and oracle10g When i link the tables, i am not able to "select distinct records" the option is greyed out. Any help ? or is linking different db types not allowed ? i've created a odbc(rdo) connection for each.

I have .xls input file, 1 column, ~3500 rows, that changes daily. Serial-dev name "192603520-3666", "192603520-3668", "192603520-3669", "192603520-366A", "192603520-366B", "192603520-366C", . . . Currently i break up the column into batches of 1000, and prepare a formula like:- If...

I want a formula to get current date, and then create or return a numbervar. i currently have a field {SRMHOST.LASTDISCOVERYTIME} that returns 20,130,502 i use this and create then join them together with this formula. stringvar myyear :=totext(year({SRMHOST.LASTDISCOVERYTIME}),0); stringvar...

I managed to add a field to a subtitle, Under Chart Options/Titles/Subtitle i have:- For @FILESYSTEMDEVICE (which displays as "For K:\i1_dd_863" I want to add another field i.e. For @FILESYSTEMDEVICE and Host name = @SRMHOSTNAME i.e "For K:\i1_dd_863 and Host name = wasid999" But i...

i have a string field "WMKHPMD019A,WMKHPMD019B,WMKHPMA081A,WMKHPMA081B,WFLLPSSPDB01,WFLLPSSPDB02" is there a formula to return the count of commas(delimiters), (5) in this string ? Thanks

When i link an excel worksheet to an oracle table, i do not have the ability to "select distinct records", the option is grayed out. Hence my report returns double/triple...... rows. Anyway around this ? there is only 1 common link between the 2 tables, a string field for "name"

Record selection has this :- {SRMARRAY.ARRAYALIAS} startswith ["ROM", "UKA", "UKB", "UKP", "UKS"] and {@Hours DIFF} and {SRMARRAY.ISCURRENT} = "Y" I have a Formula called INITSTUFF in the Report header :- shared numbervar gmtoffset ; shared STRINGVAR array arraynames ; Select {?Site Name}...

Hello, i have 2 worksheets 2 columns each. I want to use the 1st column in one worksheet as the search criteria into the 2nd worksheet. when i find a match(or not i'd want "not found") i want to insert into the original worksheet i.e. original worksheet(named Original) 2 columns Task_Num...