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

Pete, thank you very much, that's very logical and clear.

Thanks Mike, heres the exact date ranges i'm trying to handle //16-Nov 15-Dec = January //16-Dec 31-Dec = February A //1-Jan 15-Jan = February B //16-Jan 15-Feb = March //16-Feb 15-Mar = April //16-Mar 15-Apr = May //16-Apr 15-May = June //16-May 15-Jun = July //16-Jun 15-Jul = August //16-Jul...

Thank you.

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

No problem Pete, if i create a new formula from the Memo field, i can then group on it. Problem solved. Thanks

[mad]Ok, now i've corrected the data, and it exports fine as a MEMO type. I am able to add the Memo field in the details section. Now i cannot create a group on the memo type Is this a known Crystal restriction ? i am using CR11. Do i need a new forum entry for this ? Thanks in advance.

Thanks Pete, either of those options worked. Sure would be nice for the export function of crystal to flag it detected > 255 characters, and the data has been truncated as the 1st rows was < 255 characters..

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

After investigation, this is the problem. The field in oracel is indeed a number and so is the resulting formula {table.field}/1024/1024 But the oracle field can contain a null value, and if that null value is in the 1st row, then the field/my formula is defaulting to a string when exported...

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

Well i cannot wait, and appreciate all help. I export the data to .xlsx which does not have an issue when the data is suppressed, and only contains the correct rows. I then use the .xlsx file in another report, and just export to .csv. Long winded but at least it works. Thanks

Thanks Pete, that would certianly work if the data returned was unique. The report returns rows for devices, and the same device may get reported multiple time legitimately as there are several paths to it. As i only want to total the device size once, i use a formula to set the device size to...

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

Peter, i created a single row .xlsx file with columns containg 255 chars. Opened report, presed refresh, no error. Ran the job which creates the original(linked) .xlsx file. Pressed refresh, same error. Are you suggesting that the .xlsx file (row 2) after headers has to contain a row of padded...