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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.