Search results for query: *

Hi, I have created a report with 3 subreports in it. The subreports all reside in separate report footers. While printing the page number on the subreports they reset to 1. I have tried using just the Page Number formula, page N of M too and no luck. Since each subreport has different...

I'm trying to find a way to write a better, shorter script to loop thru some table data that has similar field names. The example would be that I have a table with fields defined like category_01, category_02, category_03, etc... In trying to create a simple loop is there a way to do it in...

We have a temp table that we are storing some info that will then be processed thru another program(Crystal reports). When we are loading records into the table we have already sorted the data based on certain criteria. As we read thru the recordset to populate the table, the data is being read...

Zemp, I am trying to pull in a large amount of data into a combo box that a user then could select from. The users were looking for a combo box of codes that total over 19000 but as you noted this is the wrong way to go about it and I'm just trying to come up with a better way. Users...

I have a situation where we have a combo box that has over 19000 items to load. It is very slow to load. It is also very slow when searching for the correct item in the list when the main record changes. An example would be I have a list of accounts and each account could have a value(say City)...

Steve, Yes, I am trying keeping the original viewer open. What I was hoping to do was be able to just keep adding forms to the viewer itself, even if it ment refreshing it. Based on what it looks like using the reportsourcerouter you can add mulitple reports and then when the viewer comes up you...

In looking over documentation and other tips and notes on the subject of multiple reports in Crystal Viewer I have not found a good way to use 1 crystal viewer to hold different reports from different parts of our application. In the notes I have seen it talks of having to define multiple...

This is record selection formula: {ttnames_ttx.ACCT_ID} = {?Pm-ttmaster_ttx.ACCT_ID} All that seems fine since if I change the database location to ODBC and point directly to the database tables it works just fine. The problem I'm having is that since I am using a different database...

Thanks for the response. Well, I just went back and recreated the report again from scratch. I created the TTX files for the 2 tables. I then created the report. After adding a few fields from the first table I then added a subreport using the report expert. I selected the the ttx file for the...

Ok, I found the option to turn off the prompt for the subreport parameter but I still can't seem to get the subreport to only show data related to each seperate account. If I create a new report using an ODBC link to the tables and do a simple link it works fine but when I the report from VB...

I have created a report with account info. Within that report I have created a subreport that will select certain contact info based on the account id. Problem I am having is that it is pulling all the records from the subreport query and putting it with each account. Also, since I am calling it...