Crystal Reports 8.5 v. help please

[jello112]

trying to create a report, but my database i'm choosing from isn't showing an active accounts fourmula. only an inactive accounts one. and when i toggle with that, on both sides of ture or false if the account is invactive or not, it still shows inactive accounts! how do i make my lay out only show active accounts, or how can i create that formula to show on my report?

 

[dgillz]

Databases do not contain formulas, they only contain database fields. You could have a database field that gets populated progamatically by the application that maintains it, but it will still be a database field, with a certain data type - date, number, char, boolean, etc.

If a field called 'InactiveAccount' is a boolean and it has a value of true, that indicates it is inactive. To look at all inactive accounts only, write a record selection formula:

{InactiveAccount}

If you want active rather than inactive, change the formula to:

Not {InactiveAccount}

If this does not help, please post your formula.



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[jello112]

thank you, i will try this right now

 

[jello112]

okay last question since i cannot get the other thing to work, i have a field name called "investors" and it's a string, and when i pull the browse button, it shows me all my investors. but when i preview it it shows me gray squares. and nothing is surpressed!

 

[dgillz]

When you right click the field on the report canvas, and select format, go to the common tab. Is the suppress checkbox checked? It should not be.

Is the X-2 button to the right of the checkbox red in color? If it is not then it means you have no suppression formula.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[jello112]

no it's not surpressed, but I have tried both ways of it in red or black, and the one in black shows nothing, but in the red it shows my investors under the record browse button. but it doesn't show up in the report all it shows is gray boxes. in the black text it doesn't show up at all.

 

[dgillz]

Why are you browsing records? It is not a part of your solution. Go back to the X-2 button, click it and enter a formula.

Then is it does not work, post the exact formula and error message to this forum. Do not EXPLAIN yourself, just cut and paste the formula and error message.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[jello112]

Field @Lender
formula editor: {INVESTOR.INV_NAME}
no errors found

BUT it's not letting me view it in preview. IT shows blank boxes

 

[Turkbear]

Hi,
If it is a database field name, why use a formula to display it?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jello112]

okay I get that. So i'm using it from my data base. I tried to open up another file that has my investor listed, previewed it. and it's not showing up on that either, so maybe it will only show in my program when i upload it>?

 

[dgillz]

Jello,

Lets start over. You are trying to create a report and you only want to show active accounts on. Is there a database field that indicates this?

If there is no database field that indicates this, then what set of circumstances translates into an account being active?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[jello112]

yes the report shows up on active and inactive accounts. I had done it both ways true or false, and it just shows some inactive on both sides, but in my "program" that it's pulling from, are correct and the files say inactive. i've loaded into my program and i don't see any inactive accounts anymore on the report.

the hide option that yall told me, helps a lot. now i don't see a "TRUE" down the entire page. and the investors are comming up.

 

[dgillz]

So do you have any questions any more on this topic?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[jello112]

not at the moment/ now i need to add another field in it, but that field is not in my "program" so we have to figure out how to get the figures into my program they are actually in Quick books! so i'll have a few more questions maybe but for now. i'm okay thank you for your help it' all helps me. I'm new to this and no one at work seems to know how so i've done HTML stuff so i figured it wouldnt be so hard. hah

 

[dgillz]

You probably do not need, or even have the ability, to add a field to the database in this case. Crystal as a rule does not update databses,it reportson what is already in them.

In any case if you have another question please start a new thread.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry