[How to write if else statement using formula when exporting to excel?]

=IF(L43*M43=0,0,M43*(1-O43))

=IF(L45*M45=0,0,IF(LOOKUP(R45,$AE$22:$AE$29,$AF$22:$AF$29)<>0,LOOKUP(R45,$AE$22:$AE$29,$AF$22:$AF$29),IF(L45*M45=0,0,IF(LOOKUP(S45,$M$18:$M$37,$AD$18:$AD$37)<>0,LOOKUP(S45,$M$18:$M$37,$AD$18:$AD$37),AD45+AG45))))

 

I need some suggestions how to write all these formulas with dynamic expressions?

Please help anyone  as soon as possible ? it is very urgent

 

Any suggestions will be appreciated.

 

Thanks in advance

[How to do the Filtering in a table component using the column name?]

 

 

[How Can I change the HTML5 Chart Category and Measures dynamically?]

Ex:

I have Table with 5 columns.

In Chart need to change the Category and Measures should change by the User selection at the runtime.

Need it Urgent help me as soon as possible.

Thanks in advance.

 

Thankyou

Samba

[Hyper linking is not working in the jasperstudio6.2.0?]

Hi,

How to show the report in popup window?

Even I am using the Javascript in the Report Reference Expression it is throwing an error.

Can you please help me on this?

Thank you

Samba

[A popup window for a hyperlinked report?]

Hi Ajay,

 

I am Trying to add it in the Report Reference Expression it is giving an error.Where should I add this code?

Thankyou

Samba

[Hyper linking is not working in the jasperstudio6.2.0?]

Hi,

No,

Hyperlinking is not showing in the field and it is showing as texte field only.

 

Thakyou

Samba

[Hyper linking is not working in the jasperstudio6.2.0?]

 

 

[How to read data from stored procedure in jasper server?]

Hi

Thanks for your response.

Can we create domain using stored procedure?

In jasperstudio I am able to read fields from stored procedure like that I want to read the fields from Jasper server using stored procedure

 

 

 

 

[How to read data from stored procedure in jasper server?]

It is urgent can anyone help on this ?

 

Thanks in advance

[How to read data from stored procedure in jasper server?]

 

 

[How can I call sql stored procedure to the Jasper server domain?]

 

 

[Same data printing on multiple pages]

Put the reportcount==1 in the expression editor like print when condition

[How to access my stored procedure in sql server?]

Can I call multiple stored procedures?

[Can we add multiple table elements in the detail band? and Can we design a table ?]

No one is replied till now.We did not get much help from this forum.

[Can we add multiple table elements in the detail band? and Can we design a table ?]

I got the answer

[Can we add multiple table elements in the detail band? and Can we design a table ?]

I installed TIBCO jasper soft studio6.3.1 and working with that. I want to display different tables with different data in a single page. The data is from stored procedure. I got struck here any one can please help on this?