Plz Tell me what I did wrong...

I have a column in my crystal report(of VB.Net 2005),this column is a Balance where there's fo example '1000 C' or '1000D' in the page footer I want the sum of this column,since it's type is string because of the letters Cr and Db I created a formula,named SumBalance:

numberVar SumBalance;
SumBalance:=0;
whilereadingrecords;
if Right({StatOfAcc.Balance}, 1)="C" then
SumBalance=SumBalance-ToNumber(Left ({StatOfAcc.Balance},Length ({StatOfAcc.Balance})-2 ))
else
SumBalance= +ToNumber(Left ({StatOfAcc.Balance},Length ({StatOfAcc.Balance}) -2));

I had put this formula in the page footer it gave me False,and if I right click,
FormatObject,I find a tab Boolean,where did I specify that my formula is a boolean...Wher's my error...Plz Tell meI knew my wrong it's that I have to write
SumBalance := not SumBalance=

But this formula is not doing what I'm expecting to do,it give me the last Balance but I need the sum of all the line of the column Balance...|||You put the formula in the page footer, so it'll run once per page and it'll only work on the last record for the page.
If you move it to the detail section (where it should be to work on every record) you shouldn't reset SumBalance to 0 every time in the 2nd line, you should create a new formula for the page header to do this. You'll then need another formula for the page footer to display the balance.
Does a balance of 0 have either C or D after it?
Do you really want to subtract Credits and add Debits?
Your previous post said you had Cr or Db on the end of the balance, and this formula half says that too - you are checking the rightmost character for 'C' but then discarding the rightmost two characters to get the number.
And finally, what's the business logic in summing a balance field?

Pls help me manually remove SQL 2005

Dear all,
I uninstalled SQL 2005 Std on Win 2003 Server, with the intention of
re-installing. However the uninstall somehow went wrong and not everything
was removed. When I try to reinstall a default instance it tells me there is
already one there.
Can anyone point me to a detailed process for completely removing SQL 2005
and its related components and servers (reports, BI etc)?
I would be so grateful - if I don't get this back up by Monday I am doomed!Hi Albert
There are instructions regarding un-installing in the help file {root
path}\Setup Bootstrap\Help\{lang id}\setupsql9.chm. This also tells you
where
to look for the log files to check what has failed.
John
"Albert" wrote:
[vbcol=seagreen]
> Dear all,
> I uninstalled SQL 2005 Std on Win 2003 Server, with the intention of
> re-installing. However the uninstall somehow went wrong and not everything
> was removed. When I try to reinstall a default instance it tells me there
is
> already one there.
> Can anyone point me to a detailed process for completely removing SQL 2005
> and its related components and servers (reports, BI etc)?
> I would be so grateful - if I don't get this back up by Monday I am doomed![/vbcol
]

Pls help me manually remove SQL 2005

Dear all,
I uninstalled SQL 2005 Std on Win 2003 Server, with the intention of
re-installing. However the uninstall somehow went wrong and not everything
was removed. When I try to reinstall a default instance it tells me there is
already one there.
Can anyone point me to a detailed process for completely removing SQL 2005
and its related components and servers (reports, BI etc)?
I would be so grateful - if I don't get this back up by Monday I am doomed!Hi Albert
There are instructions regarding un-installing in the help file {root
path}\Setup Bootstrap\Help\{lang id}\setupsql9.chm. This also tells you where
to look for the log files to check what has failed.
John
"Albert" wrote:
> Dear all,
> I uninstalled SQL 2005 Std on Win 2003 Server, with the intention of
> re-installing. However the uninstall somehow went wrong and not everything
> was removed. When I try to reinstall a default instance it tells me there is
> already one there.
> Can anyone point me to a detailed process for completely removing SQL 2005
> and its related components and servers (reports, BI etc)?
> I would be so grateful - if I don't get this back up by Monday I am doomed!

Pls help me manually remove SQL 2005

Dear all,
I uninstalled SQL 2005 Std on Win 2003 Server, with the intention of
re-installing. However the uninstall somehow went wrong and not everything
was removed. When I try to reinstall a default instance it tells me there is
already one there.
Can anyone point me to a detailed process for completely removing SQL 2005
and its related components and servers (reports, BI etc)?
I would be so grateful - if I don't get this back up by Monday I am doomed!
Hi Albert
There are instructions regarding un-installing in the help file {root
path}\Setup Bootstrap\Help\{lang id}\setupsql9.chm. This also tells you where
to look for the log files to check what has failed.
John
"Albert" wrote:

> Dear all,
> I uninstalled SQL 2005 Std on Win 2003 Server, with the intention of
> re-installing. However the uninstall somehow went wrong and not everything
> was removed. When I try to reinstall a default instance it tells me there is
> already one there.
> Can anyone point me to a detailed process for completely removing SQL 2005
> and its related components and servers (reports, BI etc)?
> I would be so grateful - if I don't get this back up by Monday I am doomed!

please help.. exported excel something wrong

HI,
when I export to excel that consist of hierarchy(five leavels),
the exported excel show me only two levels.
I want to make whole levels of Web form leavels in exported excel.
as same as I can see the Web form. (hierarchy!!)
what can I do? what's the problem?Is the toggle positoned right above the toggled items or you have other
report items between them? Could you share the rdl, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"woo" <woo@.discussions.microsoft.com> wrote in message
news:D3272A59-059D-42AC-A2D9-317F4BC034D8@.microsoft.com...
> HI,
> when I export to excel that consist of hierarchy(five leavels),
> the exported excel show me only two levels.
> I want to make whole levels of Web form leavels in exported excel.
> as same as I can see the Web form. (hierarchy!!)
> what can I do? what's the problem?
>