How to use Stimulsoft Reports like EXCEL

[shrek]

Hello,

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.

[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.

[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

[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.

[shrek]

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];
        }

[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.

[shrek]

Hello.
How to control the decimal digits.
Tanks.

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

[Alex K.]

Hello,

Please try to use the TextFormat property.

Thank you.

[shrek]

QQ截图20130408090308.jpg (75.27 KiB) Viewed 1868 times

[HighAley]

Hello.

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

Thank you.