Search results for query: *

Thanks for the quick reply from Madawc Williams and -LB. With your directions I was able to create the % in the monthly group and in the total. MS

I have a report that give summary and count in all the group levels and a grand total for each variable. I will need % of few variables in one of the groups. Here a short sample. I have a table of after hours calls. Groups - Account number, monthly. At the monthly group - I have total calls for...

Andrew, Thanks. Malka

Crystal Report 8.5. Access 2000. I have 2 tables in Access, that I need to link. visual linkingd links between the keys. Customer table key on - Customer ID. Company table key on - Company ID. I would like to link Company IDs in both tables. How do I force it to link this way. Thanks, Malka

Thanks you all for your help. By trying Ken's solution I actually understood it. And it is working so far. My fields probably will be longer than 254 char. But I will worry when I am done with writing all these formulas (3 for each fields). I still have some questions but it is time to wrap it...

Is there any reason why you cannot create a group to use Ken's three part solution, and then supress the GH and Details. Since you are concatinating your field values it seems like your details section would be unnecessary and everything could be displayed in the footer? I can actually create...

I am using 2 foxpro 2.6 tables that are linked by an indexed fields (key). These tables are constantly used by another program that updates them. One table has one detail line for each passenger and the other table has a detail line for each leg in a passenger itineary. I only need 2 flights for...

I am trying to create a fligth manifest, to combine arrival and departure flights on one line. Both lines are detail lines in a foxpro table. I have looked at Ken hamady's web solution and I was wondering if anyone tried his solution. I have tested it on one field. I have about 6 fields to...

Ngolem, Thanks again for your reply. I still have some more questions. Yes, the Agent name is the complete reason for the subreport. I do not need any other info from the 2nd table. I believe we already established that creating a subreport is the only way to link between these 2 unlinked...

I was wondering if I could get the Agent name in the Primary report. The agent name is in the subreport that I have created. How can I integrated all data from both tables eventhough the tables are not linked. They can be linked as I mentioned by extracting the 2 rigth char. or witht the...

Thanks for the quick reply. Answer to your questions: Agent no. is Unique regardless of the branch. Branch no. does not appear in table1. I will try your solution which according to what I read is the right one. Thanks again.

I am trying to write a simple report that gets data from 2 unlinked tables. Actually one field in one table is embedded in a field in the other table. From what I read - I will need to have a subreport done. But is there a way to still link with extracting part of the field with a formula. Ex...