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

    Concatenate/Create a Horozontal String

    The data file is set up so that each Op_Number may have 1-to-many Resource_Id records. I'm sorting by Op-Number within date. I guess I'll chalk this one up to experience. Maybe I can put each resource in its own column on the detail line by calculating the column in which it belongs.
  2. lynnspeer

    Concatenate/Create a Horozontal String

    I've followed this thread because I also need to print things horizontally instead of the layered view. Here's the code: In the group header: ---------------------------------------------- whileprintingrecords; stringvar ResourceList; shared stringvar...
  3. lynnspeer

    Parameter AND Recordset

    I can pass a recordset OR I can pass a parameter, but I want to pass a recordset AND a parameter or two. I'm creating the recordset in VB from an Oracle database using SQL; then passing it to a Crystal Report template that defines the recordset via a .ttx file. This part, by itself, is fine...
  4. lynnspeer

    Recordset returned from Oracle view does not contain "number" fields?

    Some history: originally, back in the dim past, the reports were written using the VB reporting software and used several tables -- cribs.charge_history and cribs.ttn. This was Before My Time. When I came on the scene, I wrote a report that used the two tables cribs.charge_history and...
  5. lynnspeer

    Recordset returned from Oracle view does not contain "number" fields?

    The original report was created using the same view but accessed it via OLEDB instead of ADO. Both reports use the same view of the same database, but the OLEDB one works (i.e., the number fields are there and available for placement on the report) and the ADO/OLEDB one doesn't (the number...
  6. lynnspeer

    Recordset returned from Oracle view does not contain "number" fields?

    I am running Crystal Reports 8.5. I'm trying to connect my crystal report to my Oracle database using ADO (database -> add database to report -> more data sources -> active data (ADO) -> make new connection. In the resulting "select data source" box, I select "ADO and OLE...
  7. lynnspeer

    ADO -- using already-opened connection object?

    Our crystal reports 8.5 .rpt files are sitting on a server. Our users access them from a visual basic 6.0 client on their desktop computer. The vb client grabs all of the needed user identifying information, including the name(s) of the Oracle database(s). We are converting (if that's the...

Part and Inventory Search

Back
Top