Recent content by WhiteKnight2K

On a related note, how does the Links window correspond to the report data...i.e. how will outer joins affect data in comparison to inner joins?

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

Thanks for the reply lbass. Here's some more information: "I'm making a lot of assumptions about your tables. Maybe you should specify what tables you are using, what fields from each you are using in your report, and how you are linking the subreports to the main report." Within a...

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

No need to answer...i was wondering why I couldnt select the field in the subreport to link to. I had to use the Date() function on my database.date field for some reason, and then it was available in the list.

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

You are a genius lbass...I never knew of that function. Thanks again as always!!

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

ok thanks...thats a fairly basic article and I understand what a Left Outer Join is, I guess what I'm having a problem with is how these relate to the Link Tables screen and why the inner join does not give me the result I want.

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

sorry lbass but thanks for the reply. What I am trying to do is the following: The Report section look as follows: Group Header (contains various fields from database) Details section is suppressed Group Footer (also suppressed) Since I have no Details section, all of the information from...

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

Thanks for the reply. I dont mean i want CR to show erroneous data, I just want it to show 0 for the combinations that do not have a result. I would like it to show something like this: Species Location Class American Elm Siberian Elm Japan Elm BLVD 1...

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

Thank you so much Kenny, works like a charm! You are my saviour! How did you ever figure that out?? Thanks so much again =o)