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

    Report File Size. Saved Data with Report.

    Any chance you've got an embedded graphic like a logo that is causing the overhead? Or maybe something else? If the 'save data with report' is unchecked, that should work. I believe one of my larger reports is 478k, since we don't save data. Smallest is 11k. When you open this, do you see...
  2. smcnulty2000

    formula help

    I would rewrite it this way: (if length({?DeptName}) >= 1 then {DeptName}={?DeptName} else 1=1) and (if length({?EmpID}) >= 1 then {EmpID}={?EmplID} else 1=1) and (if length({?EmpDescription}) >= 1 then {EmpDescription} like '%{?EmpDescription}%' else 1=1 ) Note the parentheses...
  3. smcnulty2000

    Uninstall CR Server Lite

    I don't, sorry to say. I guess you might be down to contacting BO directly or uninstalling by hand.
  4. smcnulty2000

    Uninstall CR Server Lite

    Try this link: http://technicalsupport.businessobjects.com/cs/forums/10830/ShowThread.aspx A potential solution is about third in the list. If that doesn't work, come back. I personally would just remove the extra slash. But I work in my registry all the time. Usually I would just put the...
  5. smcnulty2000

    CR Viewer Generates Errors For Large Reports

    Sounds like a memory error. I'd look through the web server configuration, and check it's logs. Reboot the thing if that hasn't been done in a while. Sometimes a memory leak is enough to cause this kind of grief.
  6. smcnulty2000

    Bad Date Format String

    I think I'd just turn the parameters into string parameters, then convert them over to dates as you are doing the field value. Maybe someone knows a paramter trick with XI. I haven't worked with that version too much.
  7. smcnulty2000

    Assign Formula name to Variable

    Umph. Kinda kludgy. I think I'd take the same route. I would like to see that as well. I would also like to be able to tell using a function which section the formula is sitting in. I have yet to ask the people at crystal if they'll ever build this but I think they would give some report...
  8. smcnulty2000

    Suppressing Problem and Formula

    Your selection formula doesn't dictate this. I'll presume for the sake of speed that you don't know some things so forgive me if I'm going over ground you already know. You first write a formula to determine whether the date in question is in the last full month. It will return a true or...
  9. smcnulty2000

    Week Number

    Depends on what you want to use it for. DateDiff, DatePart, and WeekdayName all support a first day of week constant. DatePart also supports first week of the year values.
  10. smcnulty2000

    Assign Formula name to Variable

    I'm interested but skeptical. I'm worried that the evaluation time would cause them to all run at the same time. Interested to hear your results.
  11. smcnulty2000

    Assign Formula name to Variable

    The short answer is no. If someone has a way to do this, I can easily imagine having multiple uses for it, so hopefully someone else will speak up. When I've had to do the equivalent my code looked about like this: shared numbervar array numArrGeneral; local numbervar numInstance...
  12. smcnulty2000

    Date Help

    Just tested it. Nifty. Adding it to my cookbook.
  13. smcnulty2000

    Date Help

    lbass, I think that has the same Dec-Jan problem. Don't you agree?
  14. smcnulty2000

    crystal long distance

    Outlook hooked into a server that is over the same vpn will continually send traffic. If you don't see a reduction in problems at that point then either it isn't the vpn causing the issue or the vpn is garbage. Unfortunately it's not a trick with outlook. It is just using outlook because it...
  15. smcnulty2000

    crystal long distance

    Probably the problem is with your VPN. I doubt a crystal setting will help. I've used a vpn that was more friendly and another that was less friendly. It is possible that a VPN setting can solve this. Maybe a conversation with your network person. What seemed to help me the most was to...
  16. smcnulty2000

    Math Formula - Creating Record

    If you need to 'create another row' right under the first, the best way to do that is to add another section and then suppress it unless it needs to show this extra remainder information. Say you have put all of the above into a detail section. You go to your section expert, then click on...
  17. smcnulty2000

    Date Help

    Of course you'd need to cover the December-January year changeover differently. Which requires a more complicated formula. You might try the dateadd function. something like this: dateadd("d",12, (dateadd("m",-1,{@date})) ) The inner version is supposed to subtract 1 month from the...
  18. smcnulty2000

    "Scanning" Function

    This might be a slightly easier route. detail level formula if {ClientPacket.PK} = 42 then ToText({ClientPacket.Date}, "mm/dd/yyyy") else "Open"; then just insert summary object in your group footer based on this. Set for 'Minimum'. That's your Sigma button if you aren't...
  19. smcnulty2000

    How to use LIKE in expression

    Here is an example: if {@formula} like "*ABC*" then true else false Another example if {@formula} like "A?C" then true else false In the first case, the asterisk is for any number of characters, in the second, the question mark indicates one and only one character. You can use fields or...
  20. smcnulty2000

    Decimal to Fraction

    Cool, I'll try it myself. Ken's stuff is usually pretty solid.

Part and Inventory Search

Back
Top