Search results for query: *

I am trying to save a list of variables in the repository then call it in the select formula of my reports. We have crystal reports XI and crystal server running. I can upload a text file with crystal server. But I can not call it from the select formula.

I need to link the Name.SSN to get the account numbers of the loans that need to be added. A member can have more than one account with loans on every account. I need total loans for the SSN even on multiple accounts.

CRXI r1 I have an SQL Database with a Name table and a loan table. I have dropped in the name table twice and the loan table twice. I have a left outer join with the name.SSN = name_1.SSN and name_1.AcountNumber != name.AccountNumber and a left outer join on from the name tables to the loan...

The relevant field is the account. Since the account meets the criteria of not closed it shows. The account is the master table linked to the other three. The tables are linked with inner joins. When I add in details, then alter the select, it removes the details, like the cards, names, and...

Sorry about that I did not understand want you wanted. out of your sample data i would want: account 100 123 main street account 300 345 some street These are in the group section, there is nothing in the detail of my report. This is for a mailing list. So I imported in 4 tables. Linked them...

The detail data shows all the names that do not have a suffix and mutiple times group: 100 123 main st details: 100 123 main st 100 123 main st 100 456 some st 100 456 some st if there is only a name with a suffix then I get group: 100 details: 100 100

I have account:number in the as the group. The I have name:street in the group header. account 100 123 main street account 200 account 300 345 some street

I do not have any or statements. I left it off because that part is working and would just add confusion. The suffix part is working like it designed, I just have the design wrong. It is removing the name record, i do not want it to show the account at all. I have the formula in the group to...

Cr 11 sql data base I have a 4 tables, accounts, names, shares, cards I only want accounts without a certain card type, with a certain share, without name suffix I am getting the account that match the the account statements in the select, such as close date is null on account, but it is also...

You rock man thanks alot.

That worked Awesome, thank you so much. Now if I can just get it to exported to excel.

I am only getting the name type 0 address in the group header. I also tried the below code and got blank. stringVar street; if {NAME.TYPE} = 3 and {NAME.MAILOVERRIDE} = 1 then street = {NAME.STREET}; if {NAME.TYPE} = 0 and street = "" then street = {NAME.STREET}; street;

I did that and I get... account address --------------------------------- 12345 type 0 address 12345 override adress So I am getting both addresses. I only want the override, or the primary if there is no override.

I need to print a specific address. I keep getting the address printing twice or not at all. I am new to cr 11. Crytsal version 11 SQL database name type = o name type = 3 and maileoverride = 1 if account has a name with type = 3 and override = 1 then print override address else print...