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 bkrike 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: JC442
  • Content: Threads
  • Order by date
  1. JC442

    Append Query What values do you use to append a Yes into a Yes/No

    Dear Wonderful Person Who Can Help, I have to populate an access table that has fields with Yes/No Format. If I want the value to be checked "Yes" what value should be used in the append data query. Using "Yes", 1, and -1 have not worked. Software is Access 2003. Thanks, JC
  2. JC442

    BO 6.1 Verify Location of data sources

    I am a new user of BO desktop 6.1 and I need some help understanding how to determine where the datasources for a unviverse are located. In Crystal I would look use Set Data source Location. Is there a similar function for BO? I'm working on the front end of a system that has dev, uat and prd...
  3. JC442

    CR 10 pipe delimited txt output

    Im running CR 10 on CE10 and trying to produce a pipe delimited txt file. I do not want to have any quotes or additional spaces in the output. a sample row would be prog_id|Date(MM/DD/YYYY)|Comment for example 1000515|12/01/2007|OVER LIMIT| Is there a combination of txt output options...
  4. JC442

    Business Objects v 6.1 Training

    Dear All, Any Suggestions on where in the North East US one can find Business Objects training? I'm looking for Business Objects Classic Report development rather than Crystal. Any suggestion would be appreciated. Thanks
  5. JC442

    CE10 Letting Users Leave behind Parameters

    Dear All, In CE10 I want to allow users to copy a report to their favorites and schedule the report so that the next time they run the report, the parameters are filled in with whatever they chose the last time. Granting the rights to let the user copy the report is not a problem. Getting the...
  6. JC442

    Events within 24 hours of each other

    Report Purpose: show speakers with 3 or more events in a 24 hour period. Data: Speaker_ID, Event_ID, Event_DATETIME. It is very easy to Group the report by Speaker_ID and Event_DATETIME (day) and supress Event_DATETIME Groups with less than 3 Events. The problem is how to do the same thing...
  7. JC442

    Turning OFF Automatic Linking in CR10

    How does one turn off the automatic linking feature in the Crystal Report 10 desktop so that CR does not try to automatically link new tables?
  8. JC442

    Reporting Data that is not there

    The Report is grouped by Sales Territory and shows the number of Sales events in each territory. What is the best way to include Territories that do not have any events?
  9. JC442

    Record Selection YTD in Jan I want last Year's data

    This is a classic problem in monthly reporting. I want the report to select records Year to Last Month when it is run in February through December. In January, I want to report the prior full year. I'm sure there is an elegant solution.
  10. JC442

    Extra wide Crystal Reports

    In Crystal 9, What is the widest setting for report width possible, and how does one set the width. I have several reports that will never be printed on paper. Is there a way to go beyond the standard paper witdths in printer setup?
  11. JC442

    Email (SMTP), Distribution lists

    Working in CE 9.0. and sheduling for Email (SMTP), how does one separate the email addresses for the To: and CC: recipients. Is it , space or another character? Thanks
  12. JC442

    Crystal 9.0 Produces Blank pages in Adobe

    Crystal 9.0 is adding blank pages when a report is exported as a pdf. The report prints ok from crystal, but when it is exported to as a pdf, a single blank page appears after each printed page. I have deselected all keep together options and new page before/after options. Any ideas would be...
  13. JC442

    CE 10 on MS SQL Server 2000 w/Analysis Service

    Has anyone tried putting CE10 on MS SQL Server 2000 w/Analysis Service? How is performance? Is the MS SQL Server scalable? How does Crystal Analysis Perform? Please share any stories good or otherwise. Thanks.
  14. JC442

    Saving Linked Crystal Subreports in SAP/BW

    In SAP/BW 3.0b using Crystal 8.5, I can create a report and add a subreport to it and save it to a BW role. As soon as the subreport is linked to a main report parameter, it can not be saved to BW. It works fine in the designer, but can not be saved or published through BW. Has anyone else run...

Part and Inventory Search

Back
Top