Carry Forward Balance

Hello All,
I'm creating a "stock ledger" using Crystal Reports 8.0. This report is printed monthly and requires that the previous month's closing balance become current month's opening balance. How do I do this?
Regards,
Rajmathihi.........

i dont know wts ur tables structure is.................but u can apply condition in ur query as

select sum(AmountField) from TableName where Month(TableName.DateField)=Month(TableName.DateField)-1

Best of Luck|||Hello "Silly Star"

Thanks for the reply, but the opening balance stock quantity and stock value are to be calculated as follows:

Every time new stock is received, the new quantity and its value gets added to the existing stock and a new rate-per-unit is calculated. suppose say I have received two consignments of a particular item on different dates, one of 100 units at 1 Re. each and the other also of 100 units, but at a cost of Rs. 1.10 each then the total stock with me is worth 210.

The same concept is applicable when stock is issued. Now when I have to issue an item I have to issue at Rs. 1.05 each.

Therefore directly considering the total of the quantity recieved and quantity issued can give me info on the quantity used, but there is huge variation in the cost (value) factor. There is fluctuation in the value and the RPU gets changed everytime new stock is received.

The report that I have designed could be used to get stock across months (say Apr - Oct). The closing balance of Apr should be taken as opening balance for May and so on.

It seems in D2K there is separate option using which this can be performed. I just wanted to know if there is a way out in Crystal Reports too

Regards,
Rajmathi|||RajMathi,
I am not sure about this.
I think you can use formula field having the code

currencyvar opbal;
whilprintingrecords;
if month{datefiled}="April" then
opbal:=opbal+{ClosingBalField};

Use other formula to check whether the month is may, if so
add opbal value to openingbalance value of May|||Hello madhi,

Well, I missed out one thing. There are several items in stock and the grouping is on items, so opening balance is separate for each item.

Regards|||RajMathi,
Ok then use other formula named @.Reset having this code

currencyvar opbal;
EhilePrintingRecords;
opbal:=0;

and place this in Group header and other formula in Dectails Section

Carriage returns

I'm migrating from Crystal. When I inserted address fields which contained
carriage returns, Crystal seemed to recognise them automatically, putting
the second line beneath the first line, etc. RS doesn't do this - obviously
I have to do something more explicit. Cam anybody help?
ThanksFirst: You need SP1. Second: I've only had success with carriage returns
when there physically was a CRLF pair. With the HTML output, the <BR> tags
are not rendered unless said CRLF pair exist.
--
TIM ELLISON
"Microsoft" <mitchellpaul@.blueyonder.co.uk> wrote in message
news:%23Kkhi714EHA.524@.TK2MSFTNGP09.phx.gbl...
> I'm migrating from Crystal. When I inserted address fields which contained
> carriage returns, Crystal seemed to recognise them automatically, putting
> the second line beneath the first line, etc. RS doesn't do this -
obviously
> I have to do something more explicit. Cam anybody help?
> Thanks
>|||Seem to have got this sorted with an expression:
=replace((Fields!AD_ADDRESS.Value),chr(13),vbcrlf)
Thanks for the help anyway, will get SP1 installed pronto...
"Tim" <TimmyDotNet@.direcway.com> wrote in message
news:eINaxi24EHA.1976@.TK2MSFTNGP09.phx.gbl...
> First: You need SP1. Second: I've only had success with carriage returns
> when there physically was a CRLF pair. With the HTML output, the <BR>
> tags
> are not rendered unless said CRLF pair exist.
> --
> TIM ELLISON
> "Microsoft" <mitchellpaul@.blueyonder.co.uk> wrote in message
> news:%23Kkhi714EHA.524@.TK2MSFTNGP09.phx.gbl...
>> I'm migrating from Crystal. When I inserted address fields which
>> contained
>> carriage returns, Crystal seemed to recognise them automatically, putting
>> the second line beneath the first line, etc. RS doesn't do this -
> obviously
>> I have to do something more explicit. Cam anybody help?
>> Thanks
>>
>

Carriage Return in Crystal Syntax

I am sure there is a solution already out there, but I couldn't find it. I am trying to insert a carriage return in some Crystal Syntax I am writing. I am doing the following

cstr(currentfieldvalue) + chr(13) + "FG"

and instead of displaying

"$300.00
FG"

it displays

"$300.00 FG"

Can someone help?Try sending a linefeed only
cstr(currentfieldvalue) + chr(10) + "FG"

or

sending a cr + linefeed
cstr(currentfieldvalue) + chr(13) + chr(10) + "FG"|||Try sending a linefeed only
cstr(currentfieldvalue) + chr(10) + "FG"

or

sending a cr + linefeed
cstr(currentfieldvalue) + chr(13) + chr(10) + "FG"

I tried both of those and it does not work. I have attached a screen shot of the coding area, maybe you can see what I am missing?

Thanks,
Michael|||Forgot to tell you that you have to check the Can Grow property
You can find it in FormatField / Common / CanGrow
Sorry!

Cant turn off tool tips !

Hi,
I am using CR10 ASP.NET with CR10 merged module & crystal report viewer, if I create a report in the crystal IDE and use file/options/review/tool-tips this turns off/on tool tips ok but when the report is viewed in the web asp.net the tool tips are always there and what's more you can't suppress individual field tool tips with CHR(9), can anyone helpI found this thread awhile ago. Not sure if it will work with your versions (I use VB6 and CR 8.5).

http://www.dev-archive.com/forum/showthread.php?s=&threadid=297373|||I agree , I have done same thing and it works. Phil let us know if this helps.

Thanks
Dilemma|||Nah this don't work, this is just suggesting using CHR(9) which as I pointed out initially dosn't work in the web browser, I know it works in CR developer
any idea's?