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 Mike Lewis 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. smueller72

    Back up SCo on Win 2k server

    We recently purchased Backup Exec to use with an autoloader to backup one of our remote locations network. The network itself is a mix of Win2K, Win2K3 and a SCO 5.0.7 server. We are now having problem backing up the SCO box. We were under the impression that there was a remote agent for SCO...
  2. smueller72

    Report formatting question

    Sorry about that - CR XI
  3. smueller72

    Report formatting question

    Hi all - My apologies in advance if this is a simple question or has been answered in these forums(I couldn't find an exact match when searching). I have a table that contains client #/name, invoice count/amount that is grouped by year/quarter. I will group the report by year and I want...
  4. smueller72

    Report formatting question

    Hi all - My apologies in advance if this is a simple question or has been answered in these forums(I couldn't find an exact match when searching). I have a table that contains client #/name, invoice count/amount that is grouped by year/quarter. I will group the report by year and I want...
  5. smueller72

    SI 7 on Win2K3 Server/IIS 6

    The virtual directories were created during the install and, going from memory on a previous install on IIS4 all seems ok. I've read through the webaccess installation verification tech doc on the business objects site and, although it doesn't reference IIS 6 directly of course, much of what it...
  6. smueller72

    SI 7 on Win2K3 Server/IIS 6

    I know it's a stretch, but has anyone gotten SI7 to run on Win2k3 server? Actually, I do have it installing fine and the Info Desktop/Report Designer/APS/Sentinel etc working fine on a Win2K3 box but I can get Info WebAccess to work. I suspect this is more a IIS6 issue than a Win2k3 server...
  7. smueller72

    optimized formulas for aging buckets

    Sure - sorry, I should have done that in the first place: Year 1(user supplied, numeric param) Year 2(user supplied) Office Number Jan Invoice Count, Invoice Amount Invoice Count, Amt Feb Invoice Count, Invoice Amount Invoice Count, Amt Mar Invoice Count, Invoice Amount...
  8. smueller72

    optimized formulas for aging buckets

    Thanks for the responses. I've went one step further and decided to create summary tables in the database that summarizes invoice data. This has reduced the number of records by nearly 90%. Now, I have another question about how to accomplish a report request that uses this summary table...
  9. smueller72

    optimized formulas for aging buckets

    Hi all - I have a pretty basic report(at least I thought) that sums invoice totals and puts them into various 'buckets'. Through much trial and error I thought I had gotten the formulas working correctly. However, today, one of our marketing folks noticed an issue with the numbers not adding...
  10. smueller72

    Sub Report Help - variable passing

    Sorry to be such a pain but I still can't get this to work. I've added the same formula that I had as a record selection formula as a formula in the 'Suppress' option of the 'Section Expert' thinking that this would cause the records not meeting the criteria to be suppressed. However, this...
  11. smueller72

    Sub Report Help - variable passing

    Ok - sorry for so many questions. So you're suggesting to remove the record selection and create a formula to do the selecting but how/where do I put/use the formula so that the inspections appear in the Detail section? Make sense? Just a bit more expounding on your last post would probably...
  12. smueller72

    Sub Report Help - variable passing

    Thanks again. I think I'm getting there. The left outer join is working but all offices still not showing. I think the problem is that I have a record selection formula on the main report that selects the inspections that fall between the 6th of the prior and 5th of the current month. Is...
  13. smueller72

    Sub Report Help - variable passing

    Thanks for the prompt response. I had previously tried every combination of linking the tables and just received a variety of errors. The tables are as follows: Office(contains general office info with OfficeID as the key) Inspections(contains inspection detail - ties to office by OfficeID)...
  14. smueller72

    Sub Report Help - variable passing

    Thank you very much!! It seems to have worked perfectly. Now one more question/problem: Even if an office does not have any inspections for the given time period - aka no detail records to report they still need to show on the report because there are minimum commissions they may need to pay...
  15. smueller72

    Sub Report Help - variable passing

    I have a very similar(I believe) need: Here's my situation: General: The report displays details and $ totals for home inspections performed by home inspections franchisees between the 6th of the prior to the 5th of the current month. The main report layout is as follows: GH1: Office Id...
  16. smueller72

    Crystal 8.5 - Sums on main & subreports

    I have a very similar(I believe) need: Here's my situation: General: The report displays details and $ totals for home inspections performed by home inspections franchisees between the 6th of the prior to the 5th of the current month. The main report layout is as follows: GH1: Office Id...

Part and Inventory Search

Back
Top