Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. huytonscouser

    Load Report Failed

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

    Create a windows task(batch file ?) to rename a file

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

    Split a field and then populate each element in a new row

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

    Slow formula

    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) = " +...
  5. huytonscouser

    Export to Excel inserts a blank row

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

    Help with formula and indexing arrays with variable names

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

    Help with formula to check month/day range

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

    Export data to .xls and MEMO datatype

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

    Datatype appears as String when its defined as a Number

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

    Export to .csv problem with a formula to suppress details

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

    Cannot refresh report with latest data.

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

    Group displays for suppressed data

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

    Select distinct records for access/oracle tables

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

    Generating param from .xls with &gt; 1000 rows

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

    Get year, month and day numbers

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

    add a field to a chart subtitle

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

    Return the count of delimiters in a string

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

    Linking an excel worksheet to an oracle table

    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"
  19. huytonscouser

    Use shared variable from formula in Record selection

    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}...
  20. huytonscouser

    Use data in a different worksheet to populate/replace data in another

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

Part and Inventory Search

Back
Top