Recent content by jizzycrystal

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