Search results for query: *

Thanks PWise. This is what I was looking for.

Thanks PWise. My example was not a good one. There are several different years and I need it to sort by the year also.

I have a list of items that are strings containing the 4 digit year followed by a space and then a number containing a decimal point. They currently sort like this. 1994 115.04 1994 119.4 1994 12.4 1994 121.03 1994 121.6 1994 124.01 1994 13.12 I'd like them to sort like this. 1994 12.4 1994...

Thanks lbass!

I'm having trouble making what I beleive is a simple pie chart. I have the following data. Year 2005 Run Items Produced --- ---------------- 1 300 2 150 3 100 4 0 A run is successful if it produces anything over 0 items. I want to create a pie chart showing the...

Thanks LB. This is exactly what I was looking for.

Thanks for the reply Brian. I'm hoping to do this without creating an additional table. The two week range would not have to be dynamic. I was trying to create a formula based on the inputed dates and group on that formula but wasn't getting anywhere.

I've read through the threads but just can't get my head around what I need to do. I have several hundreds records in a table that each have a temperature and date attribute. I want to use parameter fields to allow the user to enter a start date and an end date. I then want to display an...

Madawc, Thank you for your tip! Your solution works great and without any programming. I just needed to link the tables correctly. Thanks Again!

Hello, I have this SQL table as a datasource in CR XI. Table A Columns Name Mom Dad Tim Mary Dave Mary Sue Rick Rick Amy Bob ... and so on I want to show the "family tree" of these people in a report like so. --Sue --Mary --...

Thanks gmmastros! That is just what I was looking for. I have a lot to learn and was getting hung up on doing a SELECT NULL as.

I have two tables. TABLE_1 TABLE_2 NUM DATE NUM DATE --- ------- --- ------- 1 1/1/08 1 2/5/08 2 1/5/08 2 2/17/08 3 1/8/08 3 2/13/08 I wish to create a view like this. NUM ALLDATE DATE_A DATE_B --- -------- ------- ------- 1 1/1/08 1/1/08 1 2/5/08 2/5/08 2 1/5/08 1/5/08...