Search results for query: *

@Ian - I tried that but it didn't work. The family with two codes still get counted twice under the two codes. I have to find a way to know that when a family has been counted once under the higher priority code, it should not be considered again for the rest of the report. @lbass -...

Hi, I am having an issue where I have to count the number of families according to a certain program code. The information I have looks like this. Family# program Code $amount X 2 $$$ Y 1 $$$ X 1 $$$ Z...

I have to agree with what you said earlier that this process is unnecessarily long. I had a long talk with my supervisor and convinced him to allow me to pivot the table and display data the way we discussed earlier. It looks fine right now. Thank you very much for your help. gkw

I did group by name. I cannot specify the name in the evaluation section because it could be anything. There are no fixed values for the name field. I tried doing - if {table.name}=Rtotal1 and {table.requirement}='AST' then {table.status}, But that didn't work as well. There are only fixed...

Yes. That is what I did. So my report will look like this. Rtotal1(name) Rtotal2 ....... AST #AST1 #AST2 FAT #FAT1 #FAT2 CPR #CPR1 #CPR1 CPS #CPS2 #CPS2 . . . . and so on. There is another field called...

I have gotten the running total to work for the first name. I am having trouble getting it to work for the second name onwards. I have grouped by {table.name} and created a running total of {table.status} evalutate when table.requirement='AST' reset on change of group table.name I...

Hi, I tried it and I can get it to work that way except for a few alignment issues. Unfortunately, that is not the template that the client wants to see. Are you saying that it is impossible to get the layout that I want in crystal reports? I am thinking of using opus for this purpose. I...

I have to create a grid like report. I already made a thread regarding doing this in a crosstab a few days earlier and got some great advice from the user 'lbass'. However it did not come out exactly as planned and I tried creating a grid using running totals. I decided to post in a different...

I will ask my supervisor if that will be acceptable. I hope it is. Thanks a lot for your help.

Hi, There are a total of 8 requirements and all 8 have to be displayed each time. However, there is no limit to the number of names, and the names are not the same. I have tried using running totals to create a grid as you mentioned but am not getting the results the way I want and am running...

Another thing about the grid, The grid is supposed to run across the whole page. Even if there are only two names, there should be spaces on the grid throughout the rest of the page. Thanks, gkw

Hi, I tried doing that and it works fine except for one problem. I want to display all the requirements each time but the cross tab only displays those requirements which have values.For example the report should look like this ABC XYZ FGH Y SDF N HJK...

Hi, Sorry if I wasn't clear enough. This is my first post on a forum and I had difficulty explaining my problem. Let me show you exactly what I mean. The data coming from the database looks like this. table.Name table.Requirement table.Status ABC SDF Y ABC...

Hi, I'm new to crystal reports and I have to create a report that has to display data both down and across, similar to a crosstab. I tried using a crosstab but am unable to format it the way I want. The report looks like this Name1 Name2 Name3 ...... requirement1 status1...