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: *

  1. jedoublefunk

    intergration with Lotus Notes

    We have Lotus here and use the SMTP email feature in BOE. It works when sending the report as an attachment. I'm not sure if you can send a link to the report instance though (that would be nice.) Just make sure your Port 25 (typical SMTP port) is unblocked by your antivirus.
  2. jedoublefunk

    Hiding watermark when printing/exporting to Excel

    Using Crystal XI. Does anyone know if there is a way to hide a watermark if the report is going to be printed or exported to Excel? The watermark tends to muck things up when the report appears in Excel and I'm hoping I can suppress the section based on the print/export type. I'm guessing...
  3. jedoublefunk

    Record Selection on multiple value parameters

    Nice work! I knew it didn't have to be that difficult but my logic cap just isn't working today. Thanks MrBill!
  4. jedoublefunk

    Record Selection on multiple value parameters

    smcnulty2000, I like the idea, but you because the parameter is an Array, you can't use the instr function. The other wrinkle I see is there is no guarantee what order the user will select the Dates to use, so you could end up with BDay, Hire, Term, or Hire, BDay, Term in the Array dimensions...
  5. jedoublefunk

    Record Selection on multiple value parameters

    The more I look at the formula, the more I realize it won't work. Still, I am stumped. I've also tried this formula: if "BDay Date" in {?DatesToUse} then {Employees.BDay} in {?DateRange}; if "Termination Date" in {?DatesToUse} then {Employees.Termination Date} in {?DateRange}; if...
  6. jedoublefunk

    Record Selection on multiple value parameters

    I feel like I'm missing something obvious, but I can't seem to get this to work. Using CR XI, I've setup a report that has a date range parameter to allows a user to limit the data that appears on the report. However, I'd also like to setup another parameter that lets the user choose which...
  7. jedoublefunk

    Incorrect Log On Parameters after 9th page

    Thanks synapsevampire, I'll try that out to see which subreport it is. What seems odd to me is that all the subreports are working up to page 9 and then on page 10 they fail. I should also mention that if I run the report locally (not on the server), it runs without problems. Oh and the...
  8. jedoublefunk

    Incorrect Log On Parameters after 9th page

    I've seen a lot of Incorrect Parameter posts when trying to run a report from the Crystal Server, but unless I've missed it, I've never seen someone with this error. I run my report (Crystal Reports XI) from the CMC and it generates. I navigate through each page, but on page 10 I get the...
  9. jedoublefunk

    Time elapsed for report to generate

    Is there anyway (besides looking at a clock) to determine how long a report actually took to generate? I'd like to try a few things out on some reports to speed them up as they take a long time to load but I don't want to have to sit and watch the report chug along so I can figure out how long...
  10. jedoublefunk

    Last Day of Last Month formula error

    lbass, Yours works too, although I should say I tried that before and was getting the error that the remaining text didn't seem to be part of the formula. I'm going to chalk it up to wierd crystal or computer behavior. I appreciate the quick response though. Thanks again.
  11. jedoublefunk

    Last Day of Last Month formula error

    Interestingly enough, I tried the formula in another report and didn't get the error. So I copied and pasted the formula from the working report into my broken report. Lo and behold, it worked. I have no idea why it didn't work considering I eyeballed the two formulas and they look exactly the...
  12. jedoublefunk

    Last Day of Last Month formula error

    I'm trying to write a couple of formulas that determinethe first day of last month and the last day of last month. Currently I'm trying to use the following formulas: MinDate: DateSerial(Year(currentdate),Month(currentdate)-1,1) MaxDate: DateSerial(Year(currentdate),Month(currentdate),1 – 1)...

Part and Inventory Search

Back
Top