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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ProgressiveJL

  1. ProgressiveJL

    Nested Query?

    Hi all, I'm not sure if it's possible but I'd like to combine the follow two queries into one: select substr(reserved, 11, 10) as employees, tdate from jobs union all select employee, tdate from items select compname, storeid, address, city, state, country, pcode, telnum, faxnum from store...
  2. ProgressiveJL

    Customizing Group Names

    Man... I tried that using the MID function... haha thanks K! Works great!
  3. ProgressiveJL

    Customizing Group Names

    Hi all, I'm using CR 11 and trying to accomplish the following: 1. Get the distinct employee names from 2 different DB's for groupings. - Jobs holds the employee name in characters 11-20 in the "reserved" field. - Items holds the employee name in the "employee" field. 2. If the...
  4. ProgressiveJL

    SQL "mid" function?

    Hey all, Using CR XI and I'm trying to select the substring of a field. I've tried using MID(field, start, end) but it doesn't seem to be working. Am I using the proper function name? Anyone know where I can find a listing of CR SQL functions?
  5. ProgressiveJL

    Record Selection with an Array

    Thanks for the insight K! Helpful as always... I removed my formula from "Select Expert Formula" and created a custom function accordingly to clean it up. As for the employee selection problem: if teamAll = true then true else employee = teamID Thanks again! Until next time... Cheers!
  6. ProgressiveJL

    Record Selection with an Array

    Sorry for the poor description.. let me try again.. I'm ultimately trying to select the records based on user inputs. I've used boolean values to control whether or not records with specific values will be included in the report. I think I've been able to complete this task except for when...
  7. ProgressiveJL

    Record Selection with an Array

    Hi all, Using CR XI and trying to select records based on values in an array. I'm getting the following error message "An array's dimension must be an integer between 1 and 1000 when I execute the following formula: numberVar array itemtypes; numberVar counter; if {?VAULT_DEPOSITS} = true...
  8. ProgressiveJL

    Finite Groupings

    Hi All, CRXI Just wondering if it's possible to setup finite groups which would display the group names regardless of whether the database contained records for that group.
  9. ProgressiveJL

    Customizing User Input Dialog Box

    Hi all, Using CR XI and wondering if it's possible to customize the design of the parameter dialog box that users use for inputting. Is it possible to change the dialog box title and add instructional text?
  10. ProgressiveJL

    Working with multiple data sources

    I enlarged my test dataset which has revealed a bug in my report... =( It looks as though groups are created based on the records from my main report. The problem is that records contained in the subreport that do not fall into one of the groups created in the main report are omitted. (Main...
  11. ProgressiveJL

    Working with multiple data sources

    Great! Thanks for pointing me in the right direct LB. I was able to find a whitepaper on passing the print-time formulas to a subreport. Just out of curiousity, could I have approached this a different way? (ie. Other than passing shared variables to the main report to create the table and...
  12. ProgressiveJL

    Working with multiple data sources

    So I got my tables to work using the sample\logic you provided LB.. Many Thanks! Now, I'm trying to create a chart and depending on which summaries I choose: - I'm unable to use the summaries as values (don't show up in list) - Get the message, "A print time formula that modifies variables is...
  13. ProgressiveJL

    Working with multiple data sources

    Ok, so here's the scoop... I'm trying to summarize data from an archive DB with the current DB. There are two problems that I've noticed with my implementation thus far: 1. The shared variables don't seem to be resetting to 0 on change of GH2: Subtype Subreport Links - cardtype, subtype MAIN...
  14. ProgressiveJL

    Working with multiple data sources

    Ahhh yess... that just proves how good you are LB... worked liked a charm!! Well, at least my test data worked... lets see how the full implementation goes... =) Thanks again!
  15. ProgressiveJL

    Working with multiple data sources

    So I've made my shared variables and successfully passing data to my main report.... Now how do I tie the groups in my main report to the subreport? What I currently have is a count for all records with 2 groupings and my shared count variable doesn't reset on the change of the groups in my...
See more

Part and Inventory Search

Back
Top