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

    BOXI Enterprise / Link to a file in a folder

    Thanks much for the good info Hilfy! I'll take a look at your sample code. Appreciate you.
  2. zigstick

    Linked OLE word doc not refreshing when run in Enterprise.

    The suggestions and info are much appreciated from each of you! I did have to take the "tedious" route of opening each report, allowing the ole doc to refresh on open, and then saving the report. Time consuming and I'm a little cross-eyed. We are hoping to upgrade this year to the latest...
  3. zigstick

    BOXI Enterprise / Link to a file in a folder

    Hello, I'm using BOXI 3.1 Enterprise and need help with this situation: A user will push text and pdf files to a folder on our reporting server on a daily basis. I would like to add each of these files into a CMS folder daily. Is there a way to automate this process or to link the files to the...
  4. zigstick

    Linked OLE word doc not refreshing when run in Enterprise.

    Hello! I'm using Crystal Reports 2008 and Enterprise 12.1 and have a question regarding linked ole documents. I have linked an ole object (Word document) to approximately 800 reports that are published to Enterprise. The word doc resides on the same server as Business Objects Enterprise...
  5. zigstick

    Drill Down Report Fails To Open in BOXI Enterprise

    Hello, I'm using Crystal Reports 2008 and publishing a drill down report to BOXI Enterprise 3.2 The drill downs work perfectly in Crystal reports, but when published, I right click and VIEW, and the report flahes up quickly then disappears. Any suggestions VERY welcome! mark
  6. zigstick

    Crystal Report From SQL Not Pulling Decimal

    Hello, I'm running Crystal Reports 2000 and reporting against a SQL database view via an ODBC connection. I've been running reports against SQL for years, no issues. Today when trying to pull data from a SQL view, a number field if failing to bring in decimals. It shows 100.00 instead of 99.5...
  7. zigstick

    Summing a group summary formula

    Hello experts, I'm using Crystal Reports 2008 and have data that presents as: (in the group footer) Status #Events Total Duration Average Duration FinalAvgDuration Approved 2 37.12 18.56 Open 950 2079.48 2.19...
  8. zigstick

    Parse memo field to to next space

    Got it! You guys are great to take the time to help me. I tried the above formula with chr(10) and it works perfectly. I'm not familiar with line feeds and such but I will be googling it shortly. Thanks again guys!
  9. zigstick

    Parse memo field to to next space

    Tried that Brian, but it's returning data other than the size data. Here's the redo field: Service Catalog Request# 82974Details ----------------------------------------------Requestor_Name - Djikounou, MensahContact_Number - 904/527-4021Requestor_Email -...
  10. zigstick

    Parse memo field to to next space

    This is odd ... it doesn't appear to see any carriage returns. ?? Service%Catalog%Request#%82824 Details% ---------------------------------------------- Requestor_Name%-%Marim,%Marcelo Contact_Number%-%904/527-4453 Requestor_Email%-%Marcelo.Marim@lpsvcs.com Name%-%NA ITG_BU%-%NA...
  11. zigstick

    LastFullWeek function in CR

    {YourDateField} in Last7Days This will give you the last 7 days from the time the report is run. Also useful is LastFullMonth, MonthToDate, YearToDate. There are others as well.
  12. zigstick

    Parse memo field to to next space

    You guys are good. Is this what you're looking for Brian? Service$Catalog$Request#$82824 Details$ ---------------------------------------------- Requestor_Name$-$Marim,$Mark Contact_Number$-$xxx/xxx-4453 Requestor_Email$-$John.Doe@xxxxx.com Name$-$NA ITG_BU$-$NA Application_Owner$-$NA...
  13. zigstick

    Parse memo field to to next space

    I can see you're both on the right track, but I'm not quite there, and lack the skills to get there. :-) When I use fisheromacse's formula, all that is returned is "Size -".
  14. zigstick

    Parse memo field to to next space

    Brian, looks good, but it's still pulling in the subsequent line of data. Example, on the below record, it pulls Size = 64B, but when I set the field to "can grow", it also shows "Characteristics LUN" on the 2nd line. Since I will be exporting this to the client in excel, the 2nd line would...
  15. zigstick

    Parse memo field to to next space

    Thanks Brian, here are 3 records from the memo field. Service Catalog Request# 667665 Details ---------------------------------------------- Requestor_Name - Shinall, Damon Contact_Number - xx/xxx-xxx Requestor_Email - John.Doe@gmail.com Business_Segment - Segment2 Division - Portfolio...
  16. zigstick

    Parse memo field to to next space

    Hello, I've scoured the boards but can't find (or missed) anything specific to my needs. I'm using Crystal Reports 2008 and am trying to use mid and instr to extract specific data. Here is a sample of my code, which works, but doesn't cut off the data at the next space. if...
  17. zigstick

    Rows To Columns

    Hello, using Crystal Reports 2000 and am struggling with what seems should be simple but isn't. I've seen other related threads but none seem to aptly apply. I have rows of records for a particular ticket number such as below, only more of them. TICKET# REQ VALUE NAME REQ VALUE...
  18. zigstick

    Auto Kill Long Running Reports in Enterprise - BOXI 3.1

    Thanks! Good information. I should say that "long running" isn't the best way to put it, but rather ... hung. Reports that normally run in minutes can end up running for days if not monitored. I've checked the queries and they look good. Any way to actually auto-kill such reports after x...
  19. zigstick

    Auto Kill Long Running Reports in Enterprise - BOXI 3.1

    Hello, running BOXI 3.1 and have scheduled reports that are running excessively long, thus both using up resources as well as maxing out the 5 report at a time threshold. The only way we've found to remedy, is by regularly monitoring the instance analyzer and killing the "hung" reports and then...
  20. zigstick

    Crosstab Group Sort Challenge

    LBass ... I can't tell you what a help this is. This is going to save me many man hours. THANK YOU!!! Truly brilliant solution.

Part and Inventory Search

Back
Top