dbTalk Databases Forums  

Kind Attn pls - Urgent : Joerg Narr and other experts

comp.databases.olap comp.databases.olap


Discuss Kind Attn pls - Urgent : Joerg Narr and other experts in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bi_explorer
 
Posts: n/a

Default Kind Attn pls - Urgent : Joerg Narr and other experts - 07-19-2004 , 05:02 AM






Hi experts,

I'm considering migrating my crystal reports into MSRS to cut down the
(high licence) costs. Could you pls suggest me if its a right
decision. My reports in crystal reports are very complex in nature and
are data driven.

For example, one of my crystal report

a) displays a blob (binary large object) - pic of the user
b) report fields are derived from a Stored Procedure
c) 3 level grouping (grouping on column a, then column b and then
column c)
d) has a lot of computed fields (with IF ELSE clauses)
e) has 4 subreports (which are highly formatted - layout, field
arrangement etc)


Can I achieve all the above in one report in MSRS? Pls do suggest.

Thanks,

Reply With Quote
  #2  
Old   
Joerg Narr
 
Posts: n/a

Default Re: Kind Attn pls - Urgent : Joerg Narr and other experts - 07-23-2004 , 04:28 PM






Hello,

Quote:
I'm considering migrating my crystal reports into MSRS to cut down the
(high licence) costs. Could you pls suggest me if its a right
decision. My reports in crystal reports are very complex in nature and
are data driven.
To answer some of your questions I am sure about:

Quote:
a) displays a blob (binary large object) - pic of the user
Possible

Quote:
b) report fields are derived from a Stored Procedure
Possible

Quote:
c) 3 level grouping (grouping on column a, then column b and then
column c)
Possible, at least at you do not group on the grouped (derived) field.

Quote:
d) has a lot of computed fields (with IF ELSE clauses)
You can use Visual Basic expressions in your reports so this shouldn't be
too much of a problem.

Quote:
e) has 4 subreports (which are highly formatted - layout, field
arrangement etc)
Subreports are supported also. The question I am not sure about is, if you
will be able to reproduce your highly formatted reports - in my opinion CR
is one of the leading reporting tools in this aspect. So
I would highly recommend you to download RS and see if you can reproduce
your Crystal Reports reports. I know that MS is working on a migration tool
but it is not yet available.

Hope this helps. If you need more specific information to RS I would
recommend you to also post your questions in
microsoft.public.sqlserver.reportingsvcs newsgroup.

Kind regards,

Joerg




Reply With Quote
  #3  
Old   
bi_explorer
 
Posts: n/a

Default Re: Kind Attn pls - Urgent : Joerg Narr and other experts - 08-02-2004 , 07:34 AM



Thanks, Joerg Narr. Appreciate your inputs.

"Joerg Narr" <n_o_spa_mjoerg_narr (AT) hotmail (DOT) com> wrote

Quote:
Hello,

I'm considering migrating my crystal reports into MSRS to cut down the
(high licence) costs. Could you pls suggest me if its a right
decision. My reports in crystal reports are very complex in nature and
are data driven.

To answer some of your questions I am sure about:

a) displays a blob (binary large object) - pic of the user
Possible

b) report fields are derived from a Stored Procedure
Possible

c) 3 level grouping (grouping on column a, then column b and then
column c)
Possible, at least at you do not group on the grouped (derived) field.

d) has a lot of computed fields (with IF ELSE clauses)
You can use Visual Basic expressions in your reports so this shouldn't be
too much of a problem.

e) has 4 subreports (which are highly formatted - layout, field
arrangement etc)
Subreports are supported also. The question I am not sure about is, if you
will be able to reproduce your highly formatted reports - in my opinion CR
is one of the leading reporting tools in this aspect. So
I would highly recommend you to download RS and see if you can reproduce
your Crystal Reports reports. I know that MS is working on a migration tool
but it is not yet available.

Hope this helps. If you need more specific information to RS I would
recommend you to also post your questions in
microsoft.public.sqlserver.reportingsvcs newsgroup.

Kind regards,

Joerg

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.