Search results for query: *

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

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

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

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

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

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

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

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!

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

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

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

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

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

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

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

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

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

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

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

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.