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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jazbar

  1. jazbar

    CSV File Format unavailable in Infoview Export

    Hi All We have Enterprise XI and have never had the option to export to CSV while using Infoview. I can schedule reports and have the file export as CSV but it's just not available when users run reports on the fly. Goes anyone have any ideas what I can do to rectify this? Could it be a...
  2. jazbar

    Use Parameter based on results of a formula or to populate a formula

    Thanks Turkbear and lbass for your responses. Much appreciated. I'll try the solutions that you've posted. Problem I have currently is that the report is based on a Business View at present over DB2 so, as far as I'm aware, SQL Expressions aren't supported. Is this the case? Thanks again
  3. jazbar

    Use Parameter based on results of a formula or to populate a formula

    Hi All I'm using CRXI and I'm unsure if this is possible but hopefully someone can give me some advice. I have a report that queries a table containing products, the dates they were ordered and the quantity received. My report uses a formula called {@Last Recd} which is Maximum(Date Received)...
  4. jazbar

    Exchange 2003 OWA hyperlinks in emails requiring logon

    Thanks gigahertz Unfortunaely that hasn't worked. The reason I think it may be due to something in IIS is because this behaviour wasn't apparent until some changes were made in IIS to enable connection to Exchange via a Windows Mobile Device. The problem is is that it is so long since any...
  5. jazbar

    Exchange 2003 OWA hyperlinks in emails requiring logon

    Hi All I believe this will be a setting in IIS but has anyone come across the issue where Exchange 2003 OWA hyperlinks in emails requiring logon? When you click the hyperlink in the email in OWA you're presented with the login box, but while using Outlook it just goes straight to the website...
  6. jazbar

    Command Button to Update a Field

    Thanks PHV. You're right, for some unknown reason the field was unbound. I can't understand why that would have happened but thanks, all's well that ends well!
  7. jazbar

    Command Button to Update a Field

    Hi All I'm using MS Access 2003 and have created an autoform from a querie. On the form is a text box called Closed Date that links to a field called Closed Date in a table called Table1. I have created a Command Button called Close. What I want to happen is for the user to be able to click on...
  8. jazbar

    Pie Chart Legend Doesn't Display All Labels on the Chart

    Hi All I'm using CRXI and have a problem with the pie chart legend. The pie chart is split into 45 sections but the legend only displays 43. This is still the case when I export the report to pdf. Does anyone know if there's a limit on the maximum number of groups that the legend can display...
  9. jazbar

    Scheduling Reports with Date Ranges

    Thanks for your input kskid. I've amended the reports to run without parameters, setting the Start Date to CurrentDate - 7 and End Date to CurrentDate - 1 and then schedule them to run on a Sunday night. This will then give me the previous weeks Sales info. I just wondered if there was a way...
  10. jazbar

    Scheduling Reports with Date Ranges

    Hi All I'm using BOE XI and have a number of reports that I want to be able to schedule to run overnight. The issue I have is that the reports have manual date range parameters. Some reports should be run monthly, pulling the previous months Sales Info, some should run weekly, pulling the...
  11. jazbar

    removing the first char in a string?

    Worked a treat! Thanks for your help dgillz.
  12. jazbar

    removing the first char in a string?

    Hi All Does anyone know if there is a function or a formula for removing the first char in a string? I'm using CRXI. Thanks in advance.
  13. jazbar

    Exporting / Printing problems in Infoview / CMC

    Hi bleuys Thanks for your reply. Did you have to reinstall the Crystal Reports Server software to do this? Would I lose all of the user account details, published reports, etc, if I did this? Thanks again.
  14. jazbar

    Exporting / Printing problems in Infoview / CMC

    Hi hily, Thanks for your reply. It's an IBM iSeries server (or AS400) that is running db2. I too found the same article relating to the numeric precision in Oracle. I'm going to try and the suggestions made in the article and see if the same principle applies in this case. I'll post my...

Part and Inventory Search

Back
Top