Page 2 of 2

Re: How to use Stimulsoft Reports like EXCEL

Posted: Thu Mar 28, 2013 1:42 pm
by shrek
Aleksey wrote:Hello,
shrek wrote:Hi,
Whether can use the formula in the Table,
After I used this formula({Cells[1,1]}) in the Table shows the result is '0'
You can use the expression from Cells[1,1] in your formula.

Thank you.
But you have said that the formula({Cells[1,1]}) worked in cross-table only.

Re: How to use Stimulsoft Reports like EXCEL

Posted: Fri Mar 29, 2013 7:30 am
by Alex K.
Hello,

Yes, expression Cell[] working only for CrossTab.
In your "cell" you set a some expression (for example {DataSourceName.ColumnName128}), that's expression you can use in your formula:
{1.5 * DataSourceName.ColumnName128}

Thank you.

Re: How to use Stimulsoft Reports like EXCEL

Posted: Mon Apr 01, 2013 2:17 pm
by shrek
Hi Aleksey,

We made a demo, as you can see the enclose screen2.jpg, the expected value in the red frame should be the same value as the above cell instead of 655, could you please clarify what happens for it?

Thanks
BR

Re: How to use Stimulsoft Reports like EXCEL

Posted: Tue Apr 02, 2013 6:38 am
by HighAley
Hello.

Please, try to use next code in the Process Cell event of the summary cell.

Code: Select all

e.Value = Cells [0, -1] ;
Could you also specify what do you try to get in this cell?
Thank you.

Re: How to use Stimulsoft Reports like EXCEL

Posted: Tue Apr 02, 2013 9:20 am
by shrek
Aleksey Andreyanov wrote:Hello.

Please, try to use next code in the Process Cell event of the summary cell.

Code: Select all

e.Value = Cells [0, -1] ;
Could you also specify what do you try to get in this cell?
Thank you.

Code: Select all

public void CrossTab2_Sum2__GetCrossValue(object sender, Stimulsoft.Report.CrossTab.StiGetCrossValueEventArgs e)
        {
            e.Value = Cells[0,-1];
        }

Re: How to use Stimulsoft Reports like EXCEL

Posted: Tue Apr 02, 2013 10:26 am
by Alex K.
Hello,

You need use the additional code in ProcessCell event.
Please see the following topic in our knowledgebase:
http://stimulsoft.helpserve.com/index.p ... icleid=350

Thank you.

Re: How to use Stimulsoft Reports like EXCEL

Posted: Wed Apr 03, 2013 1:49 pm
by shrek
Hello.
How to control the decimal digits.
Tanks.

{4H1D051%MWOWN4J]%}8H[W.jpg
{4H1D051%MWOWN4J]%}8H[W.jpg (26.26 KiB) Viewed 1885 times

Re: How to use Stimulsoft Reports like EXCEL

Posted: Thu Apr 04, 2013 11:31 am
by Alex K.
Hello,

Please try to use the TextFormat property.

Thank you.

Re: How to use Stimulsoft Reports like EXCEL

Posted: Mon Apr 08, 2013 1:06 am
by shrek
QQ截图20130408090308.jpg
QQ截图20130408090308.jpg (75.27 KiB) Viewed 1871 times

Re: How to use Stimulsoft Reports like EXCEL

Posted: Mon Apr 08, 2013 6:53 am
by HighAley
Hello.

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.