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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: jrtex
  • Order by date
  1. jrtex

    Crystal page numbering withing subreports

    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...
  2. jrtex

    PLSQL loop

    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...
  3. jrtex

    Row sort order in table with no index

    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...
  4. jrtex

    Combo Box Slow Load/Search

    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...
  5. jrtex

    Combo Box Slow Load/Search

    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)...
  6. jrtex

    Multiple reports/different apps/1 CR viewer

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

    Multiple reports/different apps/1 CR viewer

    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...
  8. jrtex

    Subreport selecting all records from query

    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...
  9. jrtex

    Subreport selecting all records from query

    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...
  10. jrtex

    Subreport selecting all records from query

    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...
  11. jrtex

    Subreport selecting all records from query

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

Part and Inventory Search

Back
Top