Recent content by kellytim

I am moving a VB/ CR application from CR8.5 to CR10 and I am having trouble getting my reports to show correctly. It works in 8.5. I had to change my CRViewer.dll to use the one in crystalreportviewers10\ActiveXControls. I am using ADODB.RecordSets for to hold my data. This is what my code...

virdu, Thanks for the info. I appreciate the help. Though, I really am trying to stay away from ttx files, if I can help it. I am adding reports to an existing project and trying to stay consistent. The existing project uses the database tables on the server to get it's fields, but the...

First of all, I am very new to Crystal Reports, so please bear with my ignorance of it's functionality. I have a CR10 report called from VB. I have an ADO Recordset that is populated with an SQL statement: select serial_number, latest_status, action_date from main_table, action_table In the...

lbass, Thanks so much for the help. Now that you showed me, it seems so clear. It works like a charm. Thanks for letting me butt in to another user's line. kellytim

I am also trying to show a total from a subreport on a main report. Your info is great, but I can't quite get it to work for me. I am extremely new to Crystal Reports and don't know all the ins and outs yet. I have a main report that shows counts for new, mod and delete records grouped on...

I was able to implement the ado without .ttx files. I have to figure out how to get all my data on my report from multiple database files, but, I got connected and was able to send data from a record set in VB to my database fields in Crystal Reports. Thanks for all the help, kellytim

Thanks zemp and dave. I think I may have to use the .ttx file if I want to use my recordset that I defined the fields in, since I am building it from several other sql statements. However, I think dave is correct about what the previous developer did. Before he left he said I needed to put...

zemp, Thanks for your response. I'll look into the link you sent. I am very new to both VB and Crystal Reports and I was wondering how the previous developer got the fields on the reports he did. When I look under the database fields I see ado. Under the ado the fields that the VB sql...

I am trying to use an ADODB recordset that I create by appending fields and addnew, update in VB as the data source for my report. I set the report.database.setdatasource to the recordset. I want the fields from my recordset to be used in my report and to show up under the database fields. Is...

I am having trouble making my sql statement any more effient. I used the explain plan to show the cost of my select and I found that I am doing a table access full. I have to access a database of several million records and this is too costly. My select is written using Dynamic SQL where the...