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!

  • Congratulations strongm 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: *

  • Users: zigstick
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. zigstick

    Crosstab Group Sort Challenge

    Hello, I have a crosstab showing NameYear rows and Section columns; as shown in the below example: LSS Company Overall - 2009 5.1 4.8 LSS Company Overall - 2010 5.1 4.8 LSS Company Overall - 2011 5.1 4.8 John Doe - 2009 5.1...
  10. zigstick

    Chart showing group averages as well as Total.

    Hello, using CR XI and have created a bar chart on change of 2 fields, Year and Rating ... showing the average rating by year. Ex: Group 1: Year Group 2: RatingValue 5 - Excellent (avg for all values) 3 - Good 1 - Poor This is...
  11. zigstick

    Repository Object Deleted

    I'm using Crystal XI and have accidently deleted a repository object. The object was deleted months back and there is no backup from which to restore. I've tried creating the same object, with the same name, but I still get the "object not found" error when updating from the repository...
  12. zigstick

    Excel Forecast

    I'm trying to use either forecast or trend in Excel on data as shown below. I want to forecast the loan counts for future dates. The actual data will cover a 6 month known and 6 month forecast period. (A1)LoanCount (B1)Date 773723 3/2/2009 773723 3/3/2009 773723...
  13. zigstick

    Business Objects XI Repository Database

    Is there any way to locate/access the actual repository image files in Crystal Reports XI? We would like to copy the images to another location, for another use. Thanks in advance!
  14. zigstick

    Skip Group Labels - Zero setting

    Hello, using BO reports XI and am stumped as to how to force x axis group labels to skip zero. I change it to zero, and it goes back to 1. I've tried increasing the size of the chart (width) but still no luck. Is there any way to force it to skip 0 group labels? Thank you!!
  15. zigstick

    Respository Graphic

    Hello, I'm running Crystal Report XI and have a document repository question. We have 400 reports that have a bitmap graphic of the company logo on each. The logo has changed. Is there any way to overwrite the existing graphic in the repository with the new logo, so that it propagates to all...
  16. zigstick

    Cross Tab Summary Question

    Hi, Using Crystal 11.5. I'm probably making this harder than it should be, but using the example below: Late Emergency Exceptions Total Changes 5 16 200 221 I want the crosstab to show Late and Emergency only, but still show the Total Changes of...
  17. zigstick

    Sharepoint 2007 Document Linking

    Hello, using Sharepoint 2007. We use Crystal Enterprise to auto-generate reports in pdf format that are posted to our report server. Is there a way to point to those reports from Sharepoint? The Crystal pdf will change daily, and be overwritten with the same name, would Sharepoint pull this...
  18. zigstick

    Macro to paste on focus

    Help; trying to write a macro in Access that will open a table, copy a field, then return to an already opened form and paste append the values to the end of the string that is in a memo field. The form where I'm pasting the data would already be opened and the cursor positioned at the end of...
  19. zigstick

    2 ODBC Drivers Same Driver Name/Different ODBC Name

    Help! I have 2 subreports, each using a Service Center ODBC driver. Each points to a different SC database. The name of the ODBC driver is different for each, but when the login prompt comes up, they both show the driver name "sc_odbc5.1". Once I log into the first subreport, the 2nd fails...
  20. zigstick

    Powerpoint Dual Monitor Issue

    This is very strange. I'm using a dual monitor setup, which works perfectly with all apps but Powerpoint. When I bring up a slide in powerpoint and then move the slide to the 2nd monitor, it doesn't transfer the graphics. I see the titles only. Has anyone enountered an issue like this? Thanks!

Part and Inventory Search

Back
Top