Search results for query: *

Thanks everyone! I created a second crosstab and I can now get the breakdown... thanks for your assistance!

I have a cross tab as follows : Countries Grand Total Canada USA East West Tot East West Tot 10 8 18 12 18 30 48 I have a request to break down the grand total so that rather than just displaying the total of 58, it would...

yes, at the moment they do have the ability to select all buildings (not just those which are related), so I will either need to restrict the parameters, or make the changes you had suggested ... you are correct that the report will work incorrectly if they choose to select multiple unrelated...

Thanks lbass.. the reason everything worked so far is that they have only been expecting one ratio.. they have been testing the report on either one single building, or a complex/campus (a group of related buildings which share a ratio, as at the moment the ratio is calculated in the report...

Hi lbass, I tried the "sub-report in the header" idea, and it worked perfectly! And the sub-report actually processes faster than expected, as I did a "non-linked" sub-report.. since it is not linked to the main report it runs faster than a linked sub-report would. Thanks again as this...

Thank you very much lbass. That information is very helpful, and I will try those ideas. Thanks again and have a good weekend!

The fields are: {Space.SpaceID} {Space.SquareFt} {Floor.FloorID} {Floor.SquareFt} {Building.BuildingID} Table Joins: {Building} one to many {Floor} one to many {Space} The sub-report idea (in the report header) sounds intriguing. As I assume that it would process prior to the rest of the...

I just tried this and I think this should work for you ({string_field} would be the user defined field you are using with a the date value): DateValue(ToNumber({string_field}[5 to 8]),ToNumber({string_field}[9 to 10]),ToNumber({string_field}[11 to 12]))

The floor record is displaying correctly on the detail level. It displays 500 sqft. For example: Floor Space ID Space SqFt Floor Record 001 100 100 sqft 500 sqft 001 200 200 sqft 500 sqft 001 300 100 sqft 500 sqft Floor 001: 400 sqft Floor Record: 500 sqft...

I need to do a calculation based on the report data and use that calculation in the report detail section. Is it possible? The tables are: Group 1: Building Group 2: Floor The report runs for a building, looks at each floor, and looks at each space on the floor (to pick up office sq ft) In...

Thank you very much fisheromacse. I will try this solution and get back with my results. Thanks again. ============================================= p.s. I had tried the following solution this afternoon that was working for many of my records, but some of them were not calculating...

I am trying to calculate the term between two dates (MM/DD/YYYY format) using Crystal Reports XI. Examples: start date: 01/13/2006 end date: 01/12/2011 I think the result should be: 4 years, 11 months, 29 days start date: 06/26/2006 end date: 08/31/2011 I think the result should be: 5...