I did a search and I am not finding the exact answer to my help but I see that there is possibility. I moved from CR7 to CR10. In CR7, we connect to the "database" by using TTX files. With CR10, I realized that I can connect directly to a stored procedure and display better recordset than a single line from a TTX file. I use VB6 to get the user selections and pass them to a stored procedure to get the recordset then attach that to the CR file.
Now I have to debug the reports with grouping and such that requires me to test the functions or changes I made in the report files. What I do is, I would save the report after making changes. Run the VB program to generate the report so I can see the results of the changes. I don't use the Preview within CR to see them.
I technically can't remove the database connection to the TTX files for the reports. Sometimes the client support will use them to answer clients questions when they call.
What I want to know is that if you can have multiple DB connections stored in a report. When you open the report or preview it, you have to select or change the DB connection.
In my dreamland, I like to have two DB connections in each report. One is TTX file and the other is to our development DB server. Of course, I would be using the DB server connection myself. But when it is open by someone else as they can't connect to our development server but they still can use the TTX files as we give it to them. So is it possible for two connections stored in a reports and be able to switch them easily when need? If so, how does it work?
Now I have to debug the reports with grouping and such that requires me to test the functions or changes I made in the report files. What I do is, I would save the report after making changes. Run the VB program to generate the report so I can see the results of the changes. I don't use the Preview within CR to see them.
I technically can't remove the database connection to the TTX files for the reports. Sometimes the client support will use them to answer clients questions when they call.
What I want to know is that if you can have multiple DB connections stored in a report. When you open the report or preview it, you have to select or change the DB connection.
In my dreamland, I like to have two DB connections in each report. One is TTX file and the other is to our development DB server. Of course, I would be using the DB server connection myself. But when it is open by someone else as they can't connect to our development server but they still can use the TTX files as we give it to them. So is it possible for two connections stored in a reports and be able to switch them easily when need? If so, how does it work?