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.
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.