Search results for query: *

Hi LB, I used your suggestions, started from scratch and it worked. Thanks again for your help!

Hi LB, I put in the command into a blank report and inserted the fields and it showed only 1 record per the undisplayed date, which is what I want, so that was good. When I inserted the Max Date field into the report to see what happens (this will not be on the final report), it displayed the...

Yes, it runs once the command is unlinked, however the records seems to be duplicating.

hi LB, I ran into the same issue where I got back a blank report. After I changed the links on the tables (thanks for the linking tip), i went back and refreshed the data, got the blank report, then i tried to pull the fields under the command into the window and that did not bring anything up...

COMMAND: COUNTRY_POOL_TABLE HISTORY_TABLE Max date-------------------------->Undisplayed Date Country--------Country------------>Country------/-----/ US State------>US state Comment code/ / Acct Number----Acct Number-------->Acct Number/-----/----/...

Hi LB, Here is the command I put in, I have substituted the names for the tables as the tables I am using do not have intutive names: SELECT max (history_table. history_date) as maxdate, country_pool_table.cntry_code, country_pool_table.US_state, country_pool_table. acct_num FROM...

Hi LB, I tried what you suggested and after I tried to refresh the data on the report I got the following errors: "Failed to retrieve data from the database" AND "If the tables are already linked, then the join type cannot change" Not sure what the problem is or what I might have done wrong...

Sorry, here is the sort I want: Country :USA State: CA Date Account # Date User ID Comments 12/02/06 123 11-27 XXX XXXX 11/27/06 678 12-02 Using the example above, I want to sort first by Country (which is a group), then by State...

Hi LB, Thanks for the suggestions regarding limiting records to more than n days in the future. I'll give it a shot. For the first part of my question - from my last post I got information on how to only display the maximum record for each group. However, I now have to pick a maximum record...

One more thing, I have created a parameter field for this report where the user has to enter a date and the report will return only those records that have a date greater than the date the user entered. Is there any way the user can only enter a number such as 10 days in the future, and the...

Hi, I use CR XI with DB2. I am creating a report that has 2 groups as shown below. One of the fields in this report is a date field. I need to only pick up the latest date from this field for each of the distinct account numbers. So, for the example below, I want the report to just show...

Thanks hoho for your suggestion and for getting me started. LB, your knowledge in this area is unbelievable! This combined with your willingness to help is something rare. I truly appreciate all the help you have given me and your willingness to spend the time looking into my questions. BTW...

Hi, I use CR XI with DB2. I have created a report where I need to group the data by Group "A" and then by Group "B". The problem is that the field for group "B" also has some other information, so my report comes out like this: A B01 B02 C01 C02 I need all the Bs in one group and all...

Thanks, LB!

Hi, Thanks for your suggestion! I might be doing something wrong here, but I followed the wizard and incorporated your suggestion, but it seems to only total up the records the records within each group. I need for it to total individual records within each group and create a total at the end...

Hi, I am a new CR XI user and have created the following report. The main group is by User ID, and within each user ID there are a number of US States. So, the report will look like this: User ID States Amount Bob MO 10 CA 20 TN 30...

Rock on, thanks!

LB, Thanks once again for the help! It worked great. I am new to Crystal Reports, and am picking things up as I go along. I had one more question; all the books I have say that when you select a date range, there is no way for the dates the user selects to be displayed on the report, and I was...

Hi Turkbear, I get the data from the range entered without any problem. My problem arises when I try to create another column with just a subset of data from the date range data. I have included a better explanation above in response to LB's question. Thanks!

Hi LB, I need to report on which cases were created during a particular period. This period will be entered by the user in a date range. These cases identified by their id numbers will form one column on the report. I then need to create another column on the report that shows cases that were...