Recent content by tsjd

thanks guys, lbass, where in particular do you put that statement? so, lets say the field name within the table (e.g. glpost) is drilldown i should type {fn CONVERT({glpost.drilldown,SQL_VARCHAR)} ?

I'm facing a problem with crystal report 8.5 where the fields are unable to display the full range of numbers. The field which I am pulling data out from has 18 digits 221922000000000002 which is an account code. What i'm getting out of crystal when I display is 1.11e+017 which makes me unable...

Grats lbass! You've always been one of the posters apart from synapse who always has been there to answer my crystal queries. Hope to learn more from you guys in the future! =D

thanks got it already :)

I need a formula (using two parameters, month and year) which would display the records of a certain month without using any date formula as the fiscal year of the company is different compared to a calendar date. Basically the fiscal period (month) within the pervasive sql data is of a number...

solved :) It was my evaluation and reset arguements which were incorrect :) Thanks

I tried using the sum there but the values do not seem to be adding up. Also tried evaluating where on the change of the period field but still doesn't add up properly.

mind to elaborate there. Not quite sure of the solution there. I'm using crystal 8.5

I have a table e.g like this Fiscal Period Name Total ------------- ------ ------- 01 xx 5 01 xx 5 02 xx 4 02 xx 3 03 xx 2 How do I create a running total for each one of the periods at the end of each...

Works now. Tried using a numeric instead of date. So i'll have to enter two seperate parameters to ask for the month/year. Less flexible, but gets the job done :) Thanks man

Tried the solution outlined above, but it seems to be displaying a blank report instead >< The tables FISCYR and FISCPER are both string fields with lengths of [4] and [2] respectively. Due to the fact that they are strings, I also tried and {ARATR.FISCYR}>=Year({?StartingPeriod}) and...

I'm using crystal 8.5 and used the following arguements in my record selection. I get an error message for the second portion of the year and period saying that a string is required here {ARATR.TRANSTYPE}={?Transtype} //condition for document type to bring up and...

I need help on how to set 2 parameters to view a report from a certain period to another period. For e.g - Displaying a record from 01/01/06 - 31/01/06

thanks, works now. How do I do that? Tried sum(table.amt) > 0 but it displays "true" as output

I have a table and I wish to suppress certain fields where the amount is a negative one. E.g. Customer Name Total ------------- ----- zxczxczxczxcx 3 adb -4 llalal 5 How do I suppress the whole -4 field as I have to show the total sales? I'm running Crystal 8.5...