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

    how to find what is causing the block

    Ok folks, after multiple attempts to cover bit by bit areas of one that is getting snagged, we have narrowed in down to the invoice number (51782) and still don't see how this would snag. Heres the freaky thing, we figured out that if you rotate (can't believe this!) the document it makes it...
  2. skootsu

    how to find what is causing the block

    We have an issue where we have problems with attachments (pdfs) getting deleted because they had something that hit a rule. We absolutly can't find anything that is on the rule list to trigger it. Is there any way you can get at the information for the Exact content/item that caused a match on...
  3. skootsu

    QRP

    We have 1.5.1.
  4. skootsu

    error CS0117

    Help, new to C#, machine down, don't know what the user did (of course denying everything), getting CS0117 error when compiling. Like 'Can't find commit'... Any help/hope? MS Development Rnv 2003 Ver 7.1.6030 MS .NEW Framework 1.1 Ver 1.1.4322 SP1 MS Visual C# .NET , MS Visual Studio .NET 2003 SP1
  5. skootsu

    QRP

    Struggling with Centura report builder with Visual . Can anyone tell me how I can add a field from the REASON table into the RMA deatil report VMVMRMARP2? I can't find in any centura doc anything specific to Visual and I can't find anything in Visual docs about modifying an existing report by...
  6. skootsu

    frontend applications

    Thanks for the pointers. Took your advice and started checking it out, looks very similar to access, nice wizard, short learning time. Haven't yet really seen the 'menu' type interface (form in access). We have an ERP package (Lillysoftware/Visual Enterprise)using Oracle as the database (9i)...
  7. skootsu

    frontend applications

    New to Oracle, I thought I saw something some where on this, where to start?
  8. skootsu

    frontend applications

    Figive me if this is not the right place for this question, I am interested in finding a frontend solution for running reports off an oracle 9i database. We have a number of Access databases only because of the interface (menu, form). We also have Crystal 9.5 which I have been creating the most...
  9. skootsu

    percent ontime

    Help? I got a report nearly complete but I have a percent showing in reverse. I need to show %ONTIME but I am showing the opposite, %LATE. This is the formula on my groups,Sum ({@@Count_Late}, {@@ProductID_Grouper})*100/Count ({CUSTOMER_ORDER.ID}, {@@ProductID_Grouper}) The result is 29%...
  10. skootsu

    group by quarter

    Can anyone tell me how to make by report (shipped orders, last full year, grouped by product catagory, summed $$ by catagory) show by quarter? I am guessing I would need to some how create a group for quarters them group by the product code? I have to have only one report (it will be published...
  11. skootsu

    data coming in but not heading

    SaberLogicity has update now for export data only. Solved the issue.
  12. skootsu

    data coming in but not heading

    No, if I run in CR, export as 97-2000 data only, save as type xls but name file extension .csv, it works perfect. When I load to run in SaberLogic RRD tool, export as csv it drops the first heading. Expert as excel drops one or more headings. I am understanding now about the fact CR is more a...
  13. skootsu

    data coming in but not heading

    I have a report that I am exporting as csv (will be used in excel), the data is coming in but not the heading for the first column/field. I'm using 9. It seems to happen when I go beyond 12 columns. I can save as application and it will work but we are using SaberNet Logicity to run them...
  14. skootsu

    Previous day total

    Is there a function or formula for selecting records where the date (Entered_Date) is previous day? I have daily reports that can only be run at 4am and need to show previous days totals (like Orders Entered, Invoiced, Shipped). I know about the MonthToDate, WeekToDate, those will work if used...
  15. skootsu

    Add leading character

    Thank you, Thank you!! Just started at a new job with all new tools. Had no books, mgr was holding out ;) Now I'm off and running.
  16. skootsu

    Add leading character

    Can anyone tell me how to take a field and add a leading and ending character? Example, my report will list Part#, *Part#*, Part Description, Location, *Location*, Warehouse. IE, the part# and Location fields are within *'s. Any ideas? I'm thinking its a string function but thats as far as I...
  17. skootsu

    TR0705 Category Orphans

    Yippie skippy! Success! I saved it as an mdl on the old server, under the PowerCube area, left the AllEasternSales (easternsales.mdc), deleted the Sales Reps (all the individual sales reps mdcs), resaved it (mdl) on the new server. I was then able to pull it up in Transformer (new version)edit...
  18. skootsu

    TR0705 Category Orphans

    How would I 'clear all of the catagories from the sales rep dimension?
  19. skootsu

    TR0705 Category Orphans

    yes it opens.
  20. skootsu

    TR0705 Category Orphans

    Thats how I have done them up until this point. On this one I can't open it to do the save as. STEPS Pulled up the phyin the older version Saved it as an mdl Opened in new version, changed datasource and output (cube) locations Save in new version as pyi. It has worked on all except this one...

Part and Inventory Search

Back
Top