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!

  • Congratulations bkrike 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: *

  1. WhiteKnight2K

    Select Expert in Subreport and Main Report

    I was just wondering, does the Select Expert in the Main Report have any impact of the records that would be present in a subreport. If I have select records in the Main Report based on criteria in the Select Expert for the Main Report, does this have any bearing on the records that will be...
  2. WhiteKnight2K

    Subreport in Group Footer of Main Report Not Showing Data

    I know I said I wouldnt post another question today but I've got this project to finish and I cant figure out for the life of me why my report setup wont generate the subreport results. Heres the layout of my report Main Report (contains Year parameter field) Group By Municipality Group Header...
  3. WhiteKnight2K

    Parameter Record Selection for Subreports

    Hello once again...last question for today I promise. Here's my problem, I have a report, the main report has 2 Details sections, each Details section containing a subreport. I have two parameter fields in the main report, StartYear and EndYear. I also have a Record Select in the Select...
  4. WhiteKnight2K

    Padding number with leading zero?

    Hello, quick question, is it possible to "pad" a number field with a leading zero in CR? The number I pull from the database does not have a leading zero for years < 10. I have a parameter field which allows the user to select records based on the Year field corresponding to that record...
  5. WhiteKnight2K

    How to know when to use Outer Join

    Hello. I know this probably sounds like a dumb question, but I'm having trouble determining when to use a Left OUter Join vs Inner Join. When i wasnt getting the results I wanted from the default Inner Join, I switched one of the links to Outer Join and voila, the result i wanted...
  6. WhiteKnight2K

    Conditional Summary?

    Hello there. Is there such a thing as a conditional summary? The reason I ask is because i need to display the number of records (trees) such that the tree number is between 1 and 24. I know this can be accomplished with a Running Total but I need to display this number in the Group Header...
  7. WhiteKnight2K

    Crosstab object

    Hello, I'll first describe the situation then I'll ask the question so its makes sense what I am asking. Currently I have a database that stores Species of a tree as well as Location Class. Right now there are 3 Species and 6 Location Classes, however this could change because it is user...
  8. WhiteKnight2K

    Problem when Page Header in subreport becomes Report Header in main re

    Hello there. Yes, I'm having yet another problem with CR. This time it seems like it should be easy to solve, but ...oh well, here's the situation. I have a main report, and within this main report all i have is a Page Header for the name of the report and the date. In the details section...
  9. WhiteKnight2K

    I'm lost...how do i write a stored procedure that will....

    Hello there! I have encountered a problem that I think is solvable with nested subreport but CR doesnt allow for this. For starters: A Tree Group can have many Contacts. Each Contact has a certain Contact_Type where the Contact_Type can be Owner, Renter, Manager etc. Also a Tree Group...
  10. WhiteKnight2K

    Formulas dont work with Running Totals that Sum and return nothing

    Hello there! The problem I am having (and I hope there is a work around to this) is that sometimes my running total that is set to Sum will not return anything (i guess it returns NULL) so when I try to use this running total in a formula such as where i subtract or add this running total to...
  11. WhiteKnight2K

    Subreports within subreports? is this possible?

    Hello, This is the problem that I am encountering, but first a little background to set the context. A property can have many contacts. Each contact can have many email addresses and /or phone numbers and/or mailing addresses. I have a main report and within this report there are subreports...
  12. WhiteKnight2K

    Nested groups (using same group more than once in same report) or

    Hello there. Here's the problem I'm having and I'm not sure if there is a solution for this or not, but here goes anyway: My report is grouped by Area and within each area I have a Tree Grouping, which identifies all the Tree Groups within a region, and within each Tree Group the details of...

Part and Inventory Search

Back
Top