Recent content by huytonscouser

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