Search results for query: *

Charliy thanks for you response too but I don't really under stand (({?Type of Search = "Unit" and {table.bus_unit} = {?Lookfor}) or ({?Type of Search = "Group" and {table.bus_group} = {?Lookfor}) ) My formulae for group is like...... (if {?Business Group} = "AUDIT" THEN...

Hi Kray It wasn't the parens unfortunately. I then tried.... if hasvalue({?Business Unit}) then {nlmastm.nominal_code} startswith{?Business Unit}) like {?Business Unit}+'*' else if hasvalue({?Business Group}) then {@businessgroup}) like {?Business Group}+'*' Crystal doesn't like this. says...

SPOKE TOO SOON...I over simplified the second parameter I want it to look to a formulae if it has a value not a field so.... (hasvalue({?Business Unit}) and {nlmastm.nominal_code} startswith{?Business Unit}) OR if(hasvalue({?Business Group} then {@businessgroup})) but crystal is not liking...

GOT IT! (hasvalue({?Business Unit}) and {nlmastm.nominal_code} startswith{?Business Unit}) OR (hasvalue({?Business Group}) and {nlmastm.nominal_code} startswith{?Business Group}) THANK YOU!!

Thanks so much. Yes on my new laptop where I have the later version CR 2013 I see it now. So I set both to optional and entered the following to record selection (IF not(hasvalue({?Business Unit}) = true) then ({nlmastm.nominal_code} startswith {?Business Group}) else true) It works when I...

Thanks guys so I tried the if is null (If is null ({?Business Unit} then ({nlmastm.nominal_code} startswith {?Business Group}) else ({nlmastm.nominal_code} startswith {?Business Unit})) and it is saying it needs "one of the comparison operators <, ,=>. <= etc. How do I use the hasvalue...

I have set up two parameters and want to allow the user to select a value from either one or the other parameter but it is insisting that both parameters be selected. I have entered Par1 "OR" Par2 in the report selection but it is ignoring the "or" bit Thanks

I'm using SAP 2013 SP4. Can I get a service pack from SAP marketplace? What about all the users of Crystal who logon to the launch pad, how can I fix the problem for them? Thank you!

Thanks for reply. Funny when I uncheck "Display internet sites in compatibility view" it fixes the problem but creates a new problem....I have to view the report at 75% because at 100% it doesn't show full page and I can't scroll down.

Crystal BI launch pad can't see the menu bar (home, documents tab) properly I'm using internet explorer 11 Also when I open a document the name isn't visible on that menu bar. I have to scroll down. I can't widen by dragging either.

ok thanks!

Thank you

Thanks Charily when you say "before" do mean in a section before. The subreport is in the report footer section of the main report

Sub report: I created a formula called YTDFTE Whileprintingrecords; shared numbervar ytdxxx := {@YTDxxx} I then dragged into my sub report Then in main report I created a formula called TOTYTDFTE Whileprintingrecords; shared numbervar ytdxxx;ytdxxx I then dragged into main report. RESULT...

Hi is it possible to add or subtract or create a formulae between a field from the main report and a field from the sub report? Thanks Jizzy

actually there are some nulls.....I have used formuale if IsNull ({@YTD_amt}) then '0.00' I don't understand If isnull({field}) test (must be first) can you explain? Thanks

Thanks Charliy but no nulls now I have created a running total for the formulae that tries to add the other two formulaes (lets call it XXX) So I'm running it for ?ytd period "03" so I would expect to see the result of ({bud15_1.base_amount01} +{bud15_1.base_amount02} + {bud15_1.base_amount03})...

Thanks Charliy but didn't work. It gnores @Prior YTD amt formula and just gives back the result of the @PriorYTDkfBUD formula I am using groups....does this effect it?

Hi I'm trying to add two formulaes: {@Prior YTD amt} + {@PriorYTDkfBUD} @Prior YTD amt: IF {nltran15zeverydb.trans_period} >= "01" and {nltran15zeverydb.nlyear} = "14" THEN {nltran15zeverydb.journal_amount} else IF {nltran15zeverydb.trans_period} >= "02" and {nltran15zeverydb.nlyear} =...

How can it have different values if the two records have the same unique no?if I run the query from the server it only pulls each record once. I can't understand why it only happens to this nominal and all others pull each record only once Baffling!