amount manipulation in crystal report

I am developing a project in vb.net .
I am displaying the amount in my detail section.
There is a situation in which , if the amount is negative it has to be displayed as receipts and if else it has to be showed as payments .

like

Description Payments Receipts
monthly instalment 6000.23 0.00
finance charges 0.00 6000.23(this is -ve value)

I have struck here . Can any one help me to come out of this situation.

I am attaching two jpeg files in which

1 vbcode_rpt : will show the present look of the report.

2 PBcode_rpt : will show how i want the report to be presented.

thanks in advance

vijiPlz explain one thing to me that do have single Field in the database for Payments and Receipts or individual Field.

in ur case u can apply formula as (if its single Field)

if {Reportname.Field}<0 then
Payments
elseif {Reportname.Field} then
Receipts|||hai silly star

i got the solution for that situation.

Both the columns are one column in the database ie. the amount column for that description.

if the amount column value is < 0 then it has to be displayed as receipts and if it is > 0 then it has to be displayed as payments .

i added two unbound currency columns in the details section and in the formula dialog I added this formula to get my requirement done.

This is in the unbound_currency_column1 ie. Payments
if {tmp_ter_pool.Amount} > 0
then {tmp_ter_pool.Amount}
else
0.00

This is in the unbound_currency_column2 ie. Receipts
if {tmp_ter_pool.Amount} < 0
then {tmp_ter_pool.Amount}
else
0.00|||Its great u find the solution but did u try the one i told u?? :cool:

Ammending Data in Field

Hi

New to crystal reports, but familiar with access.

I have been asked to ammend a label that is generated using Crystal 8.5.

Couple of questions:

(1) I cannot see any of the fields for the report, even when I lasso the entire report all I can see is the outline for each box - how can I change this?

(2) For one particular field I have been asked to add a barcode to this. I have the barcode font, and I have copied the exisiting field and changed the font. However, I need to add an '*' to the beginning and end of the exisitng component number - how can I do this?

(3) In the component field, I need to be able to delete any hyphens or spaces in the number (this is for the same field in (2)).

So for example if the component number is:

095-12-6567 7

I need to be able to convert it to:

*0951265677*

Please note that the space or hyphen may not always be present...

Thanks in advance...1 Give more details
2 Create a formula having the code
"*" & {field} & "*" and place it in the details section
(3) Create formula having the code
replace({field},"-","")|||Hi

Thanks for the help - that works like a charm :)

WRT item 1.

In design view everything is invisible, I cannot see text boxs or anything similar. When I lasso everything I see a blue dashed outline showing where it is. I then click at random, somewhere close to the box that I wish to edit/move until I hit the correct one.

When I populate the report with actual data everything (even empty fields) becomes visible|||Did you check this in Preview mode?

alternatives to crystal reports

does anyone know of any alternatives to crystal reports?I personally believe an Etch-A-Sketch is a valid alternative to Crystal Reports.

Try HTML web pages, MS Access, CSV files that can be imported into Excel, etc.

Here's a typical scenario I have to deal with: Crystal Reports is used to format data from a SQL Server stored procedure. The formatted report is then exported to Microsoft Excel (Crystal is lousy at exporting to Excel) and the Excel file is then E-mailed to the customer, who probably procedes to strip out all the formatting to put the file in a simple tabular format that they can actually use. The point is, it would be better just to pipe the data from the stored procedure directly to a CSV file which could easily be opened by Excel.

Find out how your users are actually going to USE the data, and you can probably find an alternative that will please everybody.

blindman|||going along with blindman's thoughts, I use the office web components from microsoft pretty extensively. There is a hithc though Microsoft has some licensing issues with them (everyone hitting the site must be licensed for microsoft office)

http://www.microsoft.com/downloads/details.aspx?FamilyId=BEB5D477-2100-4586-A13C-50E56F101720&displaylang=en|||I'd love to see Bill Gates' prenuptial agreement. Do you suppose his wife said "I do" or did she just click on "I accept"? One things for sure, they don't have an open-source marriage!|||What they really want is a bi-monthly/weekly report/presentation, so they dont really use the data themsleves, just for sales purposes......so a solution that would enable me to produce quality presentation reports would be ideal.........|||If your reports ar just into data presentation without using charts and graphs, try using Active Reports. Its interface and concept of reporting follows the reporting used in MS Access.|||Unfortuneately they require charts and graphs rather than raw tables of data........so I dont think this would be a viable option...i maybe wrong of course!|||I think an access data projects (ADP file) would suit your requirements. Crystal has some nifty features that Access reports do not, but I think Access' ease of use, compatibility, and simplicity of design makes it a good choice. You can embed MS Graph object into your reports. (OK, MS Graph stinks, but I don't know what other alternatives there are to MS Graph.)

Also, have you considered building web page interface that could server as an "Executive Information System"? Then your bigwigs could just browse to the information they want during presentations to get the latest numbers.

blindman|||Yeah, we have considered this but its way down the line yet but defineately in a possibility...........our data is stored in an SQL server database.will this effect anything?|||SQL Server should be capable of handling this. Access ADP files provide a nice, simple interface to SQL Server databases.

blindman|||Originally posted by achowe
does anyone know of any alternatives to crystal reports?

This is a high-end alternative to CRW:

http://www.brio.com/products/overview.html

alternative for crystal NEXT function

Hi,
Is there any alternative in SSRS 2000 for the NEXT function of Crystal. Or
can someone provide a code snippet or logic for the same.
--
Afaq ChoonawalaI am sorry, my Crystal knowledge is a little vague at this moment :-) Can
you tell us what this function does?
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Afaq" <Afaq@.discussions.microsoft.com> wrote in message
news:00748057-0DC5-4EE3-8C6D-A31EEEF1CA98@.microsoft.com...
> Hi,
> Is there any alternative in SSRS 2000 for the NEXT function of Crystal. Or
> can someone provide a code snippet or logic for the same.
> --
> Afaq Choonawala|||u can check the value any column in the next record while still being on the
current record
"Teo Lachev [MVP]" wrote:
> I am sorry, my Crystal knowledge is a little vague at this moment :-) Can
> you tell us what this function does?
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Afaq" <Afaq@.discussions.microsoft.com> wrote in message
> news:00748057-0DC5-4EE3-8C6D-A31EEEF1CA98@.microsoft.com...
> > Hi,
> >
> > Is there any alternative in SSRS 2000 for the NEXT function of Crystal. Or
> > can someone provide a code snippet or logic for the same.
> > --
> > Afaq Choonawala
>
>|||There is no alternative for forward or random navigation. There is a
Previous function but it is an opposite of what you are trying to
accomplish. I hope a future release of RS would give us access to the
dataset before it is "bound" to the region, e.g. similar to binding ASP.NET
user controls. For the time being, consider bringing the the next record
value in the current record by transforming data at the data source.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Afaq" <Afaq@.discussions.microsoft.com> wrote in message
news:408D700E-F282-467E-8B89-85D779958F4D@.microsoft.com...
>u can check the value any column in the next record while still being on
>the
> current record
>
> "Teo Lachev [MVP]" wrote:
>> I am sorry, my Crystal knowledge is a little vague at this moment :-) Can
>> you tell us what this function does?
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Afaq" <Afaq@.discussions.microsoft.com> wrote in message
>> news:00748057-0DC5-4EE3-8C6D-A31EEEF1CA98@.microsoft.com...
>> > Hi,
>> >
>> > Is there any alternative in SSRS 2000 for the NEXT function of Crystal.
>> > Or
>> > can someone provide a code snippet or logic for the same.
>> > --
>> > Afaq Choonawala
>>|||Not sure if you will find this useful for your situation or not, but I am in
the process of converting our reports from Crystal Reports to SQL Server
Reporting Services and I came up with the following alternative for the NEXT
function in our situation.
Many of our reports consist of multiple groups with subtotals and grand
totals in the group footers. On some of the CR reports, we have a
conditional page break which forces a page break only if the NEXT group value
is equal to the current value. For example: {@.Bank_Name/Bank_HEADER} = Next
({@.Bank_Name/Bank_HEADER})
This prevents a group footer from appearing on a single page by itself.
My SSRS solution is to place all the group footer information in the
innermost group footer, but within their own individual table rows with the
innermost group footer's Page break at End property checked. Then I define
the table row's hidden property to an expression which evaluates the row
number of the group with the row count of the group, such as
=(RowNumber("table1_Group2")<>CountRows("table1_Group2")).
My Group 1 and Report Footers row hidden properties have the following
respective expressions:
=(RowNumber("table1_Group1")<>CountRows("table1_Group1"))
=(RowNumber("table1")<>CountRows("table1"))
As for the aggregate functions in each of the table rows, I apply the same
scope values to achieve the Group 2, Group 1, and report totals as in:
=Count(Fields!Formula_Acct_Num.Value, "table1_Group2")
=Count(Fields!Formula_Acct_Num.Value, "table1_Group1")
=Count(Fields!Formula_Acct_Num.Value, "table1")
= Sum(Fields!Formula_Balance.Value, "table1_Group2")
= Sum(Fields!Formula_Balance.Value, "table1_Group1")
= Sum(Fields!Formula_Balance.Value, "table1")
Enjoy!
"Teo Lachev [MVP]" wrote:
> There is no alternative for forward or random navigation. There is a
> Previous function but it is an opposite of what you are trying to
> accomplish. I hope a future release of RS would give us access to the
> dataset before it is "bound" to the region, e.g. similar to binding ASP.NET
> user controls. For the time being, consider bringing the the next record
> value in the current record by transforming data at the data source.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Afaq" <Afaq@.discussions.microsoft.com> wrote in message
> news:408D700E-F282-467E-8B89-85D779958F4D@.microsoft.com...
> >u can check the value any column in the next record while still being on
> >the
> > current record
> >
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> I am sorry, my Crystal knowledge is a little vague at this moment :-) Can
> >> you tell us what this function does?
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Afaq" <Afaq@.discussions.microsoft.com> wrote in message
> >> news:00748057-0DC5-4EE3-8C6D-A31EEEF1CA98@.microsoft.com...
> >> > Hi,
> >> >
> >> > Is there any alternative in SSRS 2000 for the NEXT function of Crystal.
> >> > Or
> >> > can someone provide a code snippet or logic for the same.
> >> > --
> >> > Afaq Choonawala
> >>
> >>
> >>
>
>