complicated derived column

I have a complicated derived column. In a Crystal report it is this:

if isnull( {YSA.YSAbA}) then
(
stringVar accountPart1 := "1";
stringVar accountPart2;
stringVar accountPart3;
stringVar accountPart4;

if left({YAAREP.A7KMCD},2) = 'aa' then
accountPart4 := '01'
else if left({YAAREP.A7KMCD},2) = 'bb' then
accountPart4 := '02'
else if left({YAAREP.A7KMCD},2) = 'cc' then
accountPart4 := '03';

select {YAAREP.A7KNCD}
case "39000": accountPart3 := "115" //this is freight
case "35000": accountPart3 := "110"
case "36000": accountPart3 := "105"
default: accountPart3 := "105";

if "SERVICE" in {YAAREP.A7KMCD}
//if MIKE RYAN
then accountPart2 := "3300";

if {YAAREP.A7KNCD} = "39000" //this is freight
then accountPart2 := "4300";

if cdbl({YAAREP.A7KNCD}) > 44000 then
accountPart2 := left({YAAREP.A7KNCD},4);
if cdbl({YAAREP.A7KNCD}) > 44000 then
accountPart3 := right({YAAREP.A7KNCD},3);

accountPart1 + "-" + accountPart2 + "-" + accountPart3 + "-" + accountPart4
)
else {@.PrintDefaultSalesGL}

How should I do this in an SSIS? Or do I need to show how do this in SQL Query?

Thanks for the help!

Ashley:

I would avoid using the Derived column for what you are trying to do. Not that it cannot be done; it is just that I have not figured out a way to make the cell where you type the logic larger. Consequently, you end up having to keep typing a horizontal string and pretty soon you lose track of which elements stay together. It is great for "short" logic but for what you are trying to do I would just do it using SQL in SSIS.

desibull

|||

Or put it in a script component.

Complete beginner needs help with record selection

As a complete beginner to Crystal Reports I hope I am not asking stupid questions of what looks like a very technical and knowledgeable forum...if I am please feel free to direct me elsewhere!

I am trying to select records using several Tables but filtered from a 'Transactions Table' but only want the last dated record (ie the last dated record is equal to [input date range]. In Access I would use a query asking for 'LastOf...[field name] - but I don't know how to select the LastOf in Crystal Reports. I have stumbled around the Help for ages...can anybody please advise me on what I am sure is a simple question!
Many ThanksOne way would be to group by the table.column you're interested in and add the 'lastof' clause into the group selection formula:

{table.column} = Maximum ({table.column})|||If you use Access query for that, then design report based on that query and supply that value as parameter

Compilation

Hi
I want to know how to compiled a report in crystal report 8.5 or 9.0??
In the previous version of crystal Report (Version 8.0) I could do this task, but in the newest version I can find the option...
Please help meHi
This file contains an add-in that enables you to compile and distribute reports in the English version of Crystal Reports 8 and 8.5. This is the instalation File scr8_distr_expert.exe

Thanks

Compatibility Crystal report

i have application developed in MS ACCESS 2003. (not VB and Access)
can i use CReports with my mdb;
i split the mdb into frontend and backend.
can i use CR Successfully.
Kindly reply.
ThanksSearch here
http://support.businessobjects.com/

Comparison with Crystal Reports

I showed my boss the functionality of ad hoc reporting in SRSS and he likes
it. He asked me if we could completely move away from Crystal Reports (CR) to
SRSS.
Does anyone have any issues with SRSS that didnt exist in CR.
One question i have is programmability capabilities. Some time back i had to
make a very complex report in CR. I create a table in the dataset. Designed
the report to pull data from that table and the table was being populated
through some VB.NET code. So the users will open a GUI and hit RUN, which is
when i will populate the table and show the report. You can assume that
populating the table required complex programming and couldnt have been done
through user defined functions in a report.
I dont suppose stuff like this can be done in SRSS?RS is designed a lot more around creating the query or the stored procedure
as the source for the report. You can have multiple datasets in a report and
you can easily create 1-many reports using subreports. If you absolutely
must create the dataset via code you can do this either using the VS 2005
report control in local mode (no server, you had the control the report and
the dataset) or you can create a data process extension. Neither is
non-trivial. I have done very complex reports and have never flelt the need
for creating the dataset in code. All my reports either have the query or a
stored procedure with it.
The reports have parameters that the user selects (can be either from a list
(which can be filled by a query) or date control etc). The parameters can be
cascading. i.e the second parameter list depends on what is picked with the
first parameter. Also you can have multi-select parameters as well.
The only issue I have seen are people that have a set of business objects
coded or they want to code that way. You can do this but it is harder (data
processing extension).
HTH,
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tk_Neo" <TkNeo@.discussions.microsoft.com> wrote in message
news:9DB999DE-15AF-4E6F-BAB9-AF0D71FAC886@.microsoft.com...
>I showed my boss the functionality of ad hoc reporting in SRSS and he likes
> it. He asked me if we could completely move away from Crystal Reports (CR)
> to
> SRSS.
> Does anyone have any issues with SRSS that didnt exist in CR.
> One question i have is programmability capabilities. Some time back i had
> to
> make a very complex report in CR. I create a table in the dataset.
> Designed
> the report to pull data from that table and the table was being populated
> through some VB.NET code. So the users will open a GUI and hit RUN, which
> is
> when i will populate the table and show the report. You can assume that
> populating the table required complex programming and couldnt have been
> done
> through user defined functions in a report.
> I dont suppose stuff like this can be done in SRSS?

Comparison with Crystal Reports

I showed my boss the functionality of ad hoc reporting in SRSS and he likes it. He asked me if we could completely move away from Crystal Reports (CR) to SRSS.

Does anyone have any issues with SRSS that didnt exist in CR.

One question i have is programmability capabilities. Some time back i had to make a very complex report in CR. I create a table in the dataset. Designed the report to pull data from that table and the table was being populated through some VB.NET code. So the users will open a GUI and hit RUN, which is when i will populate the table and show the report. You can assume that populating the table required complex programming and couldnt have been done through user defined functions in a report.

I dont suppose stuff like this can be done in SRSS?

Depending on the version of Crystal you have, there are various differences, though it is a good path to move to in my opinion.

Here is one summary I have found outlining differences:

http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp

There's lots of information out there on this.

It is also possible to use a dataset as the source of report data in a custom application with Reporting Services.

cheers,

Andrew