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 wOOdy-Soft 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. JuliaFarber

    Crystal Reports fetch 1 record at a time

    Hello, We have crystal reports 2008 that are based on oracle store procedure that returns ref cursor. When the report is run the records are being fetched one at a time. Is there a way to change this? Is it possible to fetch records in bulk, like 1000 or more at a time? Thank you. Julia
  2. JuliaFarber

    Change Database at runtime throws Catastrophic failure exception

    Hello! BOE server 3.0 and Java RAS. I tried to change database at runtime using the following code: origTable = (IProcedure)tables.getTable(0); newTable = (IProcedure)tables.getTable(0); IConnectionInfo cnInfo = newTable.getConnectionInfo(); PropertyBag innerProp = cnInfo.getAttributes()...
  3. JuliaFarber

    Highlighting Values in CrossTab

    Hello, I am usign cr10. I have regular crosstab. I would like to highlight a value in the row that is equal to row total. Is it possible to do in crosstab? Thank you. Julia
  4. JuliaFarber

    Embedding a field into the “Total” label of a cross-tab

    Hello! I am using CR10. I have a crosstab that looks like this: Prod1 Prod2 Jan 09 01/05/2009 1 2 01/30/2009 1 3 Total: 2 6 Feb 09 02/01/2009 0 1 02/03/2009 2 2...
  5. JuliaFarber

    Is it possible to save rpt file with saved data using ASP?

    Hello, We are currently using CR Developer Edition 10 and RDC Component in ASP. Is it possible to save rpt file with data, so the next time I open the report I would have the saved data from previous run? Thank you. Julia
  6. JuliaFarber

    Using one report for multiple databases

    Hello, I have 1 report that I need to use for several databases. I am using crystal reports 10 developer edition and preview it with ActiveX Viewer on the web using asp and RDC component. In asp file I am changing database connection info at runtime. The problem is that sometimes the report is...
  7. JuliaFarber

    Database Level Password

    Hello! We have Access 2000 database. The person worked on it left the company and none of us knows the password to the database. Is there any solution how to change or remove this password or at least open the database in read only mode . Thank you. Julia
  8. JuliaFarber

    Multiple Lines in Tool TIps

    Hi, I am using CR 8.5. I would like to create tool tips with multiple lines. In x2 I am typing "This is my tool tips"+chr(13)+"multiple line". In runtime view I have | instead of carriage return. Does anyone know how to fix that? Thank you. Julia.
  9. JuliaFarber

    Report with hyperlink open in the same window

    Hello! I have a very big report with a lot of subreports( on demand and regular). I also have hyperlink. My problem is when the hyperlink is clicked, new window is opened(that is good), but when I close this window to get back to the report, after switching to next page the hyperlink data...
  10. JuliaFarber

    Export Legal Size Report to Excel

    Hi, I need to export legal size report to excel.Report opened from ASP. When I put a file name and choose type(excel) click on Save as button, I have box with status line and words exporting to file path and Cancel button and it takes forever to run. Although the same report exports perfectly...
  11. JuliaFarber

    Ranking

    Hi, I would like to rank the data based on Profit on my report. I have 2 columns: RepName and Profit. And I want the report be sorted by RepName. Does anybody have an idea how to do that? Thank you very much. Julia
  12. JuliaFarber

    Connect to SQL Server using ASP

    Hi, I have a report which is based on SQL Server stored procedure. The client version works fine. But when I use ASP to connect to report, connectivity is false. I am using crtable.SetLogInfo "server","db","user","password" Does anyone know why?What am I...
  13. JuliaFarber

    Parameters from ASP to CR with subreports

    Hi, My report has 3 subreports. Each subreport based on sp with one parameter. Main report has one parameter too. All these parameters are the same. I linked subreports' parameters to main report parameter and cr is working perfectly. But when I am passing the parameter from ASP page, only main...
  14. JuliaFarber

    how to disable drill down

    Hi, I am using Crystal v8. I have a report which has only one group and not a lot of details. My report look like this: Branch Item Sales Profit ------------------------------------------ NY 150 20 This is group...
  15. JuliaFarber

    total of 10 records only

    Hi, I need to get totals of 10 records only. How can I do that? I have a report where records groupped by branch. When branch is drilled down I have details for this branch - only 10 records which I got by cretating running total and counting number of records and if it 10 I am suppressing the...
  16. JuliaFarber

    Group header

    Hi, I have 3 groups, each group has different group heading. First two groups have only one page each, so I do not have problem with group headers. When I drill down third time I am getting details on two pages. On a first page group header appers, but it desappears from the second page. I have...
  17. JuliaFarber

    Group header question

    Hi, I have 3 groups, each group has different group heading. First two groups have only one page each, so I do not have problem with group headers. When I drill down third time I am getting details on two pages. On a first page group header appers, but it desappears from the second page. What...
  18. JuliaFarber

    Transformer, Dimensions

    Hi, I have a model. In this model I have two dimensions: Company and Product Group. I created cube and opened it with browser. Now when I select one of the companies and then when I want to choose product group, it gives me all product groups, not product groups of selected company. Guys, do you...
  19. JuliaFarber

    How to create crystal report based on dynamic sql

    Hi, I need to create crystal reports based on stored procedure which is using dynamic sql. Thank you.
  20. JuliaFarber

    Top 10 Records

    Hi, I've published cude to upfront. I need to print only top 10 records of 9000. I sorted in desc order and changed number of rows to 10. But when I export to PDF in order to print it exports all 9000 records. Can Anybody help with this issue? Thank you.

Part and Inventory Search

Back
Top