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

  • Users: ianoctdec
  • Content: Threads
  • Order by date
  1. ianoctdec

    Report takes a long time to get to open in CE DHTML viewer

    Hi, Is there an explanation of what could make a report to need a significantly longer time to open in CE viewer (DHTML viewer)? By open I mean to get to the parameters page. Dana
  2. ianoctdec

    Authentication drop down list when log on to CE

    We have reports scheduled in Crystal format and the user receives the link to the report by e-mail. When they click the link they are taken to the log on window. Under the Authentication drop down list, the defualt is Enterprise, so they have to manually select Windows AD. They would like the...
  3. ianoctdec

    last 20 records for each group

    Hi, I am building a Crystal report (CR10) and I need a query that will return the last 20 wo's for each part. I have a table like this (each part can have many wo's): Part wo 1 1 1 2 1 3 2 5 2 7 2 8 3 9 I have Oracle...
  4. ianoctdec

    Chart to plot summary per week and per each shift

    Hi, I need to make a line chart that will show 4 lines: one for summary of qty produced per week and three lines for sumaries by shift (day, afternoon, night)for each week. I don't see how to put it in one chart. I can insert a chart for weekly summaries and a separate chart for shifts...
  5. ianoctdec

    Query to generate a table with a new column form a given table

    I have a table Orders (order_id, line_no, part_no). Ex: OrderID Line_no Part_no Order1 1 abc Order1 2 abc Order1 3 Order1 4 Order1 5 abc Order1 6 abc I need to eliminate lines 3 and 4 (null Part_no), and recreate the table as...
  6. ianoctdec

    Set the page range to default to All

    Hi, How can I change the page range in Export Options screen, DHTML viewer, to default to All? Currently it defaults to Pages From ..., and some time our users forget to change it to All and don't export the whole report. CE 10, DHTML viewer Thank you, Daniela
  7. ianoctdec

    Suppress lines in a crosstab

    Hello, CR10, Oracle 8i Is there a way to suppress lines that have the summary field 0 in a crosstab? The crosstab has one row and one column. EX: A 80 B 0 C 0 I would like to show this as A 80 Thank you, Daniela
  8. ianoctdec

    Printing a report from DHTML viewer

    We have a report the user previews via CE ePortfolio. He does then some changes in the application based on the data he sees on the report, then prints the report. He expects that the printing will be exactly what he saw on the report before he have done changes on the application, but instead...
  9. ianoctdec

    BO XI, DHTML viewer

    Hi, Has the parameters page changed in DHTML viewer in ver XI in any way? Also, when view the report in DHTML viewer, the group tree frame is quite narrow, so if the group names are large, they are cut off. Did this feature change in ver XI? My company is looking to upgrade to XI, hoping that...
  10. ianoctdec

    Extend group tree in DHTML viewer

    Hi everyone, Is there a way to extend the group tree frame in CE 10, DHTML viewer? Some of our reports have groups with long names, and our users would like to see the whole thing so they can easily jump from group to group. Thank you, Daniela
  11. ianoctdec

    Looping Parameter Input screen in CE 10

    Has this issue been taken care of in CE version XI? What I am interested in is if when run a report with many parameters with multiple default values, the user doesn't have to click each time to add the default value for each parameter. I was hoping for the same behaviour as in the CR designer...
  12. ianoctdec

    Set default End Of Range for date parameter

    Hi, CE 10, DHTML viewer When select values for a datetime parameter, the default is something like 2005,15,08,0,0,0. Is it posible to set the default end of range for datetime parameter to 2005,15,08,23,59,59? Our users expects that the default end of range will go to the end of the day! Thank...
  13. ianoctdec

    Print duplicates of the same group

    Hi, Crystal Reports 10, Oracle database I have created a report to print invoices. The report has a group (InvoiceID), each inv prints on a separate page and can have one or more pages. What I need to do is to print three copies of each invoice, each copy having a different text on it: like...
  14. ianoctdec

    Looping parameter input screen in CE 10

    Hello everyone, Has anyone found a solution to this issue in CE 10, DHTML viewer? There is something on the BO site, they are saying that the issue has been tracked down and there are hot fixes for it. We downloaded the hot fixes but they are not working. We get the same behaviour: you must...
  15. ianoctdec

    How to get conditional data from Oracle database into Crystal Reports

    Can anyone help me to find out how can I get data from oracle db into crystal report passing a parameter from the crystal report to be used in the selection criteria. For example: I want to build a summary data from table1 based on Date parameter, also building another summary data from table2...
  16. ianoctdec

    Getting data from Oracle DB into Crystal Report

    Can anyone help me to find out how can I get data from oracle db into crystal report passing a parameter from the crystal report to be used in the selection criteria. For example: I want to build a summary data from table1 based on Date parameter, also building another summary data from table2...
  17. ianoctdec

    Print detail lines horizontaly

    Hi everyone, I want to print detail lines horizontaly. My report has three groups Group1 - PartId GRoup2 - Whse Group3 - Loc Detail - TagNo Instead of having: A1 B C 1 2 3...
  18. ianoctdec

    SQL Command makes report run slow

    Hi everyone, I am using Crystal Reports 10, Oracle db with ODBC connection. I created a report based on a SQL command and is running very slow. Is this a known issue with Crystal Reports 10? Is there anything to do to improve the speed performance? Thank you for taking the time to answer to my...
  19. ianoctdec

    Problem with linking tables

    Hi everyone, I'm using Crystal Reports 10, Oracle database with an ODBC connection. I have 2 tables: inv_pcs (part_id, length, whse, loc, qty) and phys_inv_pcs (phys_ct_id, tag_no, part_id, qty, length, whse, loc). I have to create a report that will show all the records that match in both...
  20. ianoctdec

    Identify missing numbers from a sequence

    Hello everyody, Can somebody to give me an idea on how to create a Crystal report that will show and print all the missing values from a given range of numbers? I have a table with a field named Invoice_ID. The report will receive as parameter the Invoice Number Range. The output has to be...

Part and Inventory Search

Back
Top