About a custom Crystal Report

[Robe]

I need to do a Report using Crystal where:

Given a number in a field x. Ej. 150
I need to print it in a report that has 4 columns where each value in the
field must be located in the correspondant column according to the number

(0> and <100) (>101 and <200) (>201 and <300) (>301 and <400)
=============== =============== =============== ===
150

I don't know how to do this and how to define the interval col's in the report

any idea??

[Gabe]

RE: About a custom Crystal Report

Usually when I have to do custome reports like that, I create a table in the
database that will hold the information exactly as the report will show it,
fill the table when you need the report and delete it once the program is
done. not exactly a solution, but more like a work around.

"Robe" wrote:
[color=blue]
> I need to do a Report using Crystal where:
>
> Given a number in a field x. Ej. 150
> I need to print it in a report that has 4 columns where each value in the
> field must be located in the correspondant column according to the number
>
> (0> and <100) (>101 and <200) (>201 and <300) (>301 and <400)
> =============== =============== =============== ===
> 150
>
> I don't know how to do this and how to define the interval col's in the report
>
> any idea??
>[/color]

[Ignacio Machin \( .NET/ C# MVP \)]

Re: About a custom Crystal Report

Hi,


Use a dataset, you fill it in code as needed ( or in a SP if possible) and
then assiign this dataset to the CR.

In case the intervals changes you could also pass the column's titles as
parameters to the CR so it can be fully dynamic.



--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation



"Robe" <Robe@discussio ns.microsoft.co m> wrote in message
news:6A794AD1-0BFF-47D2-9253-5E3C48DC0797@mi crosoft.com...[color=blue]
>I need to do a Report using Crystal where:
>
> Given a number in a field x. Ej. 150
> I need to print it in a report that has 4 columns where each value in the
> field must be located in the correspondant column according to the number
>
> (0> and <100) (>101 and <200) (>201 and <300) (>301 and <400)
> =============== =============== =============== ===
> 150
>
> I don't know how to do this and how to define the interval col's in the
> report
>
> any idea??
>[/color]