Migrating complex Crystal reports into MSRS

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,Yes.
Question (a): Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp?frame=true
Question (b): Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_7kj8.asp?frame=true
Question (c): Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_structure_objects_v1_3cok.asp?frame=true
Question (d): Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_6fhv.asp?frame=true
Question (e): Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_2584.asp?frame=true
Also take a look at the sample reports
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/h
tm/rss_samplereports_v1_9pmb.asp?frame=true) that ship with the product
which demonstrate these features.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"MSProgrammer" <MSProgrammer@.discussions.microsoft.com> wrote in message
news:6A1AB37F-5B3C-49DC-A8C0-CA50723F8F52@.microsoft.com...
> 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,
>|||Thanks, Rob. Very valuable inputs. Good to know that the migration from CR to RS is smooth. I'm pretty convinced that MSRS comes with wonderful features. However,
1) I'm trying to figure out whether the highly customized formatting, layout etc options that we have in CR are possible in RS too bcoz most of my reports are rich in formatting etc.
2) Can we push an ADO recordset into MSRS (instead of MSRS pulling the data) to create a separation between the report and the underlying data source? This would help us to swap the data source without changing the reports. This is possible in CR and my existing reports are working on this mechanism.
Ravi/Rob - I will appreciate your inputs on the above queries, particularly, the 2nd one.
Thks
"Rob 'Spike' Stevens" wrote:
> I have manually converted between 20 and 30 Crystal Reports so far in the past month (and still going), and I have found that after figuring out a few of the tricks on how SRS does things differently, the conversions go rather quickly.
> Firstly, you may find that you do not need sub-reports anymore, since SRS can supports data regions with diferent data sets.
> Running totals is a bit tricky at the moment in SRS, while Crystal has a more mature wizard for doing the various Running values, but so far I have been able to reproduce all Running sums in SRS - I've has to use the Report's Code section to write a finction that does the summing up for me, and use iif clauses in the grid to determine whe the function is called.
> The big trick is order of execution for data regions...currently it appears the headers and footers of a group level get evaluated before the stuff inside does (an outside-in approach). This causes an issue if you are trying to sum up the First value in a group to get a grand total (currently SRS does not support Aggregates of Aggregates, i.e Sum(First( table.field )) ) The way I got around that problem is to copy and paste the data region immiediately below itself, and set the top most region to invisible and can shrink. This way the Code gets executed before the second data region gets rendered and the totals will be available. The report in design mode looks weird, but in runtime it looks great.
> This board is great for finding other tips and tricks, but in general I'd say the tool isn't as big an issue as one might think, the conversions go pretty smoothly.
> "MSProgrammer" wrote:
> > Thanks, Ravi. I'll go thru all the links.
> >
> > 1) Could you pls let me know when is MS releasing the migration tool? Any inputs on the utility of this tool for migrating Crystal Reports to MSRS.
> >
> > 2) Can we push an ADO recordset into MSRS (instead of MSRS pulling the data) to create a separation between the report and the underlying data source? Thanks.
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > Yes.
> > >
> > > Question (a): Check
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp?frame=true
> > > Question (b): Check
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_7kj8.asp?frame=true
> > > Question (c): Check
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_structure_objects_v1_3cok.asp?frame=true
> > > Question (d): Check
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_6fhv.asp?frame=true
> > > Question (e): Check
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_2584.asp?frame=true
> > >
> > > Also take a look at the sample reports
> > > (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/h
> > > tm/rss_samplereports_v1_9pmb.asp?frame=true) that ship with the product
> > > which demonstrate these features.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > "MSProgrammer" <MSProgrammer@.discussions.microsoft.com> wrote in message
> > > news:6A1AB37F-5B3C-49DC-A8C0-CA50723F8F52@.microsoft.com...
> > > > 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,
> > > >
> > >
> > >
> > >|||Sorry it has been a while since I got to your questions.
For #1, I'd have to say that it depends on what kinda formatting you are
talking about. I have completed the conversion of over 125 Crystal reports
and I felt that in most cases the appearance and modification of ta
appearance was comperable and superior, respectively. Alternating colors,
drill-down sections with + - controls - and no limit to how many levels of
drilldown (I believe Crystal only goes from main to one sub, with no subs
from subs). So you may find yourself having/wanting to reformat your reports
anyway to take advantage of the new options...there were several reports i
converted that got facelifts because their original look was based on a
workaround for something Crystal couldn't do at the time, or do any more.
In terms of modifying a reports format, I feel SRS is vastly superior. In
Crystal, I'd have reports stuffed full of fields and it took quite a while to
engineer the fonts and spacing to get the look just right; but it never
failed that a request would come in to add another field, and usually in the
middle - and the hours of re-engineering the locations and fonts of all the
fields commenced. SRS makes it far easier to change fonts, add line
graphics, add fields and re-proportion the other fields, and apply large
amounts of conditional formatting. I will caution you, however, that some of
the formatting properties are not all in the same place, or even nest to each
other. Like if you make a field a hyperlink to anywhere (another report,
other website), you have to change the font color to Blue yourself, and you
have to underline it manually as well. If you take the next step and make
the field conditionally a hyperlink, then you have to place an expression in
the Font Color, Action, and Font Decoration properties.
On your second question, MS has indicated that at some point in the future
they will be publishing SRS viewers to be enbedded in websites and
applications, but i still think it will be based on a Pull mechanism. I had
recently changed the datasource of a group of reports from one database
server to another, and the only change I had to make was to the rds file -
the reports never missed a beat.
"MSProgrammer" wrote:
> Thanks, Rob. Very valuable inputs. Good to know that the migration from CR to RS is smooth. I'm pretty convinced that MSRS comes with wonderful features. However,
> 1) I'm trying to figure out whether the highly customized formatting, layout etc options that we have in CR are possible in RS too bcoz most of my reports are rich in formatting etc.
> 2) Can we push an ADO recordset into MSRS (instead of MSRS pulling the data) to create a separation between the report and the underlying data source? This would help us to swap the data source without changing the reports. This is possible in CR and my existing reports are working on this mechanism.
> Ravi/Rob - I will appreciate your inputs on the above queries, particularly, the 2nd one.
> Thks
>
> "Rob 'Spike' Stevens" wrote:
> > I have manually converted between 20 and 30 Crystal Reports so far in the past month (and still going), and I have found that after figuring out a few of the tricks on how SRS does things differently, the conversions go rather quickly.
> >
> > Firstly, you may find that you do not need sub-reports anymore, since SRS can supports data regions with diferent data sets.
> >
> > Running totals is a bit tricky at the moment in SRS, while Crystal has a more mature wizard for doing the various Running values, but so far I have been able to reproduce all Running sums in SRS - I've has to use the Report's Code section to write a finction that does the summing up for me, and use iif clauses in the grid to determine whe the function is called.
> >
> > The big trick is order of execution for data regions...currently it appears the headers and footers of a group level get evaluated before the stuff inside does (an outside-in approach). This causes an issue if you are trying to sum up the First value in a group to get a grand total (currently SRS does not support Aggregates of Aggregates, i.e Sum(First( table.field )) ) The way I got around that problem is to copy and paste the data region immiediately below itself, and set the top most region to invisible and can shrink. This way the Code gets executed before the second data region gets rendered and the totals will be available. The report in design mode looks weird, but in runtime it looks great.
> >
> > This board is great for finding other tips and tricks, but in general I'd say the tool isn't as big an issue as one might think, the conversions go pretty smoothly.
> >
> > "MSProgrammer" wrote:
> >
> > > Thanks, Ravi. I'll go thru all the links.
> > >
> > > 1) Could you pls let me know when is MS releasing the migration tool? Any inputs on the utility of this tool for migrating Crystal Reports to MSRS.
> > >
> > > 2) Can we push an ADO recordset into MSRS (instead of MSRS pulling the data) to create a separation between the report and the underlying data source? Thanks.
> > >
> > > "Ravi Mumulla (Microsoft)" wrote:
> > >
> > > > Yes.
> > > >
> > > > Question (a): Check
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp?frame=true
> > > > Question (b): Check
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_7kj8.asp?frame=true
> > > > Question (c): Check
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_structure_objects_v1_3cok.asp?frame=true
> > > > Question (d): Check
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_6fhv.asp?frame=true
> > > > Question (e): Check
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_2584.asp?frame=true
> > > >
> > > > Also take a look at the sample reports
> > > > (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/h
> > > > tm/rss_samplereports_v1_9pmb.asp?frame=true) that ship with the product
> > > > which demonstrate these features.
> > > >
> > > > --
> > > > Ravi Mumulla (Microsoft)
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > > "MSProgrammer" <MSProgrammer@.discussions.microsoft.com> wrote in message
> > > > news:6A1AB37F-5B3C-49DC-A8C0-CA50723F8F52@.microsoft.com...
> > > > > 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,
> > > > >
> > > >
> > > >
> > > >|||Hi MSProgrammer,
Did you every find a satisfactory solution to your question (2)? We have the
same situation where our existing system pushes record sets to Crystal for
rendering and viewing in the web browser. We would like to use MSRS RDL to
define our report templates (like Crytsal RPT files) and then have our engine
"push" result sets thru the RDL for rendering and display.
Thanks in advance,
-Alex
"MSProgrammer" wrote:
> Thanks, Rob. Very valuable inputs. Good to know that the migration from CR to RS is smooth. I'm pretty convinced that MSRS comes with wonderful features. However,
> 1) I'm trying to figure out whether the highly customized formatting, layout etc options that we have in CR are possible in RS too bcoz most of my reports are rich in formatting etc.
> 2) Can we push an ADO recordset into MSRS (instead of MSRS pulling the data) to create a separation between the report and the underlying data source? This would help us to swap the data source without changing the reports. This is possible in CR and my existing reports are working on this mechanism.
> Ravi/Rob - I will appreciate your inputs on the above queries, particularly, the 2nd one.
> Thks
>
> "Rob 'Spike' Stevens" wrote:
> > I have manually converted between 20 and 30 Crystal Reports so far in the past month (and still going), and I have found that after figuring out a few of the tricks on how SRS does things differently, the conversions go rather quickly.
> >
> > Firstly, you may find that you do not need sub-reports anymore, since SRS can supports data regions with diferent data sets.
> >
> > Running totals is a bit tricky at the moment in SRS, while Crystal has a more mature wizard for doing the various Running values, but so far I have been able to reproduce all Running sums in SRS - I've has to use the Report's Code section to write a finction that does the summing up for me, and use iif clauses in the grid to determine whe the function is called.
> >
> > The big trick is order of execution for data regions...currently it appears the headers and footers of a group level get evaluated before the stuff inside does (an outside-in approach). This causes an issue if you are trying to sum up the First value in a group to get a grand total (currently SRS does not support Aggregates of Aggregates, i.e Sum(First( table.field )) ) The way I got around that problem is to copy and paste the data region immiediately below itself, and set the top most region to invisible and can shrink. This way the Code gets executed before the second data region gets rendered and the totals will be available. The report in design mode looks weird, but in runtime it looks great.
> >
> > This board is great for finding other tips and tricks, but in general I'd say the tool isn't as big an issue as one might think, the conversions go pretty smoothly.
> >
> > "MSProgrammer" wrote:
> >
> > > Thanks, Ravi. I'll go thru all the links.
> > >
> > > 1) Could you pls let me know when is MS releasing the migration tool? Any inputs on the utility of this tool for migrating Crystal Reports to MSRS.
> > >
> > > 2) Can we push an ADO recordset into MSRS (instead of MSRS pulling the data) to create a separation between the report and the underlying data source? Thanks.
> > >
> > > "Ravi Mumulla (Microsoft)" wrote:
> > >
> > > > Yes.
> > > >
> > > > Question (a): Check
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp?frame=true
> > > > Question (b): Check
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_7kj8.asp?frame=true
> > > > Question (c): Check
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_structure_objects_v1_3cok.asp?frame=true
> > > > Question (d): Check
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_6fhv.asp?frame=true
> > > > Question (e): Check
> > > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_2584.asp?frame=true
> > > >
> > > > Also take a look at the sample reports
> > > > (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/h
> > > > tm/rss_samplereports_v1_9pmb.asp?frame=true) that ship with the product
> > > > which demonstrate these features.
> > > >
> > > > --
> > > > Ravi Mumulla (Microsoft)
> > > > SQL Server Reporting Services
> > > >
> > > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > > "MSProgrammer" <MSProgrammer@.discussions.microsoft.com> wrote in message
> > > > news:6A1AB37F-5B3C-49DC-A8C0-CA50723F8F52@.microsoft.com...
> > > > > 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,
> > > > >
> > > >
> > > >
> > > >|||Today you have to do a data processing extension. Read up on that in RS
help. In the future (Widbey/Yukon) there will be both a winform and webform
control that should (I haven't used it so I say should) do as you want.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alex Sorenson" <Alex Sorenson@.discussions.microsoft.com> wrote in message
news:7E13CEE3-AF3D-4624-A716-EA03031ECA6D@.microsoft.com...
> Hi MSProgrammer,
> Did you every find a satisfactory solution to your question (2)? We have
the
> same situation where our existing system pushes record sets to Crystal for
> rendering and viewing in the web browser. We would like to use MSRS RDL to
> define our report templates (like Crytsal RPT files) and then have our
engine
> "push" result sets thru the RDL for rendering and display.
> Thanks in advance,
> -Alex
>
> "MSProgrammer" wrote:
> > Thanks, Rob. Very valuable inputs. Good to know that the migration from
CR to RS is smooth. I'm pretty convinced that MSRS comes with wonderful
features. However,
> >
> > 1) I'm trying to figure out whether the highly customized formatting,
layout etc options that we have in CR are possible in RS too bcoz most of my
reports are rich in formatting etc.
> >
> > 2) Can we push an ADO recordset into MSRS (instead of MSRS pulling the
data) to create a separation between the report and the underlying data
source? This would help us to swap the data source without changing the
reports. This is possible in CR and my existing reports are working on this
mechanism.
> >
> > Ravi/Rob - I will appreciate your inputs on the above queries,
particularly, the 2nd one.
> >
> > Thks
> >
> >
> >
> > "Rob 'Spike' Stevens" wrote:
> >
> > > I have manually converted between 20 and 30 Crystal Reports so far in
the past month (and still going), and I have found that after figuring out a
few of the tricks on how SRS does things differently, the conversions go
rather quickly.
> > >
> > > Firstly, you may find that you do not need sub-reports anymore, since
SRS can supports data regions with diferent data sets.
> > >
> > > Running totals is a bit tricky at the moment in SRS, while Crystal has
a more mature wizard for doing the various Running values, but so far I have
been able to reproduce all Running sums in SRS - I've has to use the
Report's Code section to write a finction that does the summing up for me,
and use iif clauses in the grid to determine whe the function is called.
> > >
> > > The big trick is order of execution for data regions...currently it
appears the headers and footers of a group level get evaluated before the
stuff inside does (an outside-in approach). This causes an issue if you are
trying to sum up the First value in a group to get a grand total (currently
SRS does not support Aggregates of Aggregates, i.e Sum(First(
table.field )) ) The way I got around that problem is to copy and paste the
data region immiediately below itself, and set the top most region to
invisible and can shrink. This way the Code gets executed before the second
data region gets rendered and the totals will be available. The report in
design mode looks weird, but in runtime it looks great.
> > >
> > > This board is great for finding other tips and tricks, but in general
I'd say the tool isn't as big an issue as one might think, the conversions
go pretty smoothly.
> > >
> > > "MSProgrammer" wrote:
> > >
> > > > Thanks, Ravi. I'll go thru all the links.
> > > >
> > > > 1) Could you pls let me know when is MS releasing the migration
tool? Any inputs on the utility of this tool for migrating Crystal Reports
to MSRS.
> > > >
> > > > 2) Can we push an ADO recordset into MSRS (instead of MSRS pulling
the data) to create a separation between the report and the underlying data
source? Thanks.
> > > >
> > > > "Ravi Mumulla (Microsoft)" wrote:
> > > >
> > > > > Yes.
> > > > >
> > > > > Question (a): Check
> > > > >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp?frame=true
> > > > > Question (b): Check
> > > > >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_7kj8.asp?frame=true
> > > > > Question (c): Check
> > > > >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_structure_objects_v1_3cok.asp?frame=true
> > > > > Question (d): Check
> > > > >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_6fhv.asp?frame=true
> > > > > Question (e): Check
> > > > >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_2584.asp?frame=true
> > > > >
> > > > > Also take a look at the sample reports
> > > > >
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/h
> > > > > tm/rss_samplereports_v1_9pmb.asp?frame=true) that ship with the
product
> > > > > which demonstrate these features.
> > > > >
> > > > > --
> > > > > Ravi Mumulla (Microsoft)
> > > > > SQL Server Reporting Services
> > > > >
> > > > > This posting is provided "AS IS" with no warranties, and confers
no rights.
> > > > > "MSProgrammer" <MSProgrammer@.discussions.microsoft.com> wrote in
message
> > > > > news:6A1AB37F-5B3C-49DC-A8C0-CA50723F8F52@.microsoft.com...
> > > > > > 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,
> > > > > >
> > > > >
> > > > >
> > > > >|||Thanks for your reply Bruce.
-Alex
"Bruce L-C [MVP]" wrote:
> Today you have to do a data processing extension. Read up on that in RS
> help. In the future (Widbey/Yukon) there will be both a winform and webform
> control that should (I haven't used it so I say should) do as you want.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Alex Sorenson" <Alex Sorenson@.discussions.microsoft.com> wrote in message
> news:7E13CEE3-AF3D-4624-A716-EA03031ECA6D@.microsoft.com...
> > Hi MSProgrammer,
> >
> > Did you every find a satisfactory solution to your question (2)? We have
> the
> > same situation where our existing system pushes record sets to Crystal for
> > rendering and viewing in the web browser. We would like to use MSRS RDL to
> > define our report templates (like Crytsal RPT files) and then have our
> engine
> > "push" result sets thru the RDL for rendering and display.
> >
> > Thanks in advance,
> > -Alex
> >
> >
> > "MSProgrammer" wrote:
> >
> > > Thanks, Rob. Very valuable inputs. Good to know that the migration from
> CR to RS is smooth. I'm pretty convinced that MSRS comes with wonderful
> features. However,
> > >
> > > 1) I'm trying to figure out whether the highly customized formatting,
> layout etc options that we have in CR are possible in RS too bcoz most of my
> reports are rich in formatting etc.
> > >
> > > 2) Can we push an ADO recordset into MSRS (instead of MSRS pulling the
> data) to create a separation between the report and the underlying data
> source? This would help us to swap the data source without changing the
> reports. This is possible in CR and my existing reports are working on this
> mechanism.
> > >
> > > Ravi/Rob - I will appreciate your inputs on the above queries,
> particularly, the 2nd one.
> > >
> > > Thks
> > >
> > >
> > >
> > > "Rob 'Spike' Stevens" wrote:
> > >
> > > > I have manually converted between 20 and 30 Crystal Reports so far in
> the past month (and still going), and I have found that after figuring out a
> few of the tricks on how SRS does things differently, the conversions go
> rather quickly.
> > > >
> > > > Firstly, you may find that you do not need sub-reports anymore, since
> SRS can supports data regions with diferent data sets.
> > > >
> > > > Running totals is a bit tricky at the moment in SRS, while Crystal has
> a more mature wizard for doing the various Running values, but so far I have
> been able to reproduce all Running sums in SRS - I've has to use the
> Report's Code section to write a finction that does the summing up for me,
> and use iif clauses in the grid to determine whe the function is called.
> > > >
> > > > The big trick is order of execution for data regions...currently it
> appears the headers and footers of a group level get evaluated before the
> stuff inside does (an outside-in approach). This causes an issue if you are
> trying to sum up the First value in a group to get a grand total (currently
> SRS does not support Aggregates of Aggregates, i.e Sum(First(
> table.field )) ) The way I got around that problem is to copy and paste the
> data region immiediately below itself, and set the top most region to
> invisible and can shrink. This way the Code gets executed before the second
> data region gets rendered and the totals will be available. The report in
> design mode looks weird, but in runtime it looks great.
> > > >
> > > > This board is great for finding other tips and tricks, but in general
> I'd say the tool isn't as big an issue as one might think, the conversions
> go pretty smoothly.
> > > >
> > > > "MSProgrammer" wrote:
> > > >
> > > > > Thanks, Ravi. I'll go thru all the links.
> > > > >
> > > > > 1) Could you pls let me know when is MS releasing the migration
> tool? Any inputs on the utility of this tool for migrating Crystal Reports
> to MSRS.
> > > > >
> > > > > 2) Can we push an ADO recordset into MSRS (instead of MSRS pulling
> the data) to create a separation between the report and the underlying data
> source? Thanks.
> > > > >
> > > > > "Ravi Mumulla (Microsoft)" wrote:
> > > > >
> > > > > > Yes.
> > > > > >
> > > > > > Question (a): Check
> > > > > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp?frame=true
> > > > > > Question (b): Check
> > > > > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RShowto/htm/hrs_designer_v1_7kj8.asp?frame=true
> > > > > > Question (c): Check
> > > > > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_structure_objects_v1_3cok.asp?frame=true
> > > > > > Question (d): Check
> > > > > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_6fhv.asp?frame=true
> > > > > > Question (e): Check
> > > > > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_2584.asp?frame=true
> > > > > >
> > > > > > Also take a look at the sample reports
> > > > > >
> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/h
> > > > > > tm/rss_samplereports_v1_9pmb.asp?frame=true) that ship with the
> product
> > > > > > which demonstrate these features.
> > > > > >
> > > > > > --
> > > > > > Ravi Mumulla (Microsoft)
> > > > > > SQL Server Reporting Services
> > > > > >
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no rights.
> > > > > > "MSProgrammer" <MSProgrammer@.discussions.microsoft.com> wrote in
> message
> > > > > > news:6A1AB37F-5B3C-49DC-A8C0-CA50723F8F52@.microsoft.com...
> > > > > > > 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,
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
>
>sql

Migrate / Read Access data file(s) in SQL Server

Dear Experts,
I have some Access .mde files from a custom application.
The runtime version of Access is 2002. I don't have
a developer's version of Access. I also don't have the
schema design of the app.
I'd like to import or migrate the data file into SQL Server
schemas (databases) somehow. Or, another database
like Oracle.
Is it possible to do this from SQL Server?
What is the buzzword that I can search on?
Is there a link you can forward?
Thanks a lot!
Migrating Access databases to SQL Server can be done different ways from
both sides. Also, depending on the version of SQL Server that you target you
can use different tools too.
Here are a few links that will give you a good start:
SQL Server Migration Assistant for Access (for migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
Moving Your Access 2002 Database to SQL Server 2000 (look at the Data
Transformation Services section for importing Access data to SQL Server):
http://msdn2.microsoft.com/en-us/library/aa902657(SQL.80).aspx
How to use the Upsizing wizard in Access 2002:
http://support.microsoft.com/default.aspx/kb/330468
Access 2002 Upsizing Tools white paper:
http://support.microsoft.com/default.aspx/kb/294407
In the past I have used many times the Data Transformation Services in SQL
Server 2000 to import data from Access databases and it has been working
very well. Recently I used the SQL Server Import and Export Wizard in SQL
Server 2005 to import a few tables from .mde files and no problems there
too.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
|||I tried the simplest method I could. In SQL 2000, using enterprise manager,
I imported the mde. In source, I chose the Access type. I then chose the
file (after changing the file filter from *.mdb to all files). After
accepting the SQL Server data source, I checked all of the tables in the mde.
The import wizard created my tables and imported the data.
Russel Loski, MCSD.Net
"dba_222@.yahoo.com" wrote:

> Dear Experts,
> I have some Access .mde files from a custom application.
> The runtime version of Access is 2002. I don't have
> a developer's version of Access. I also don't have the
> schema design of the app.
> I'd like to import or migrate the data file into SQL Server
> schemas (databases) somehow. Or, another database
> like Oracle.
> Is it possible to do this from SQL Server?
> What is the buzzword that I can search on?
> Is there a link you can forward?
> Thanks a lot!
>
|||<dba_222@.yahoo.com> wrote in message
news:1169516295.667810.162270@.51g2000cwl.googlegro ups.com...
> Dear Experts,
> I have some Access .mde files from a custom application.
> The runtime version of Access is 2002. I don't have
> a developer's version of Access. I also don't have the
> schema design of the app.
> I'd like to import or migrate the data file into SQL Server
> schemas (databases) somehow. Or, another database
> like Oracle.
> Is it possible to do this from SQL Server?
> What is the buzzword that I can search on?
> Is there a link you can forward?
> Thanks a lot!
>
|||you should use DTS or something similiar in order to import all of your
Access Databases into SQL Server
"la playa mas bella" <thepadrino_1@.hotmail.com> wrote in message
news:eSt2kaXgHHA.588@.TK2MSFTNGP06.phx.gbl...
> <dba_222@.yahoo.com> wrote in message
> news:1169516295.667810.162270@.51g2000cwl.googlegro ups.com...
>

Migrate / Read Access data file(s) in SQL Server

Dear Experts,
I have some Access .mde files from a custom application.
The runtime version of Access is 2002. I don't have
a developer's version of Access. I also don't have the
schema design of the app.
I'd like to import or migrate the data file into SQL Server
schemas (databases) somehow. Or, another database
like Oracle.
Is it possible to do this from SQL Server?
What is the buzzword that I can search on?
Is there a link you can forward?
Thanks a lot!Migrating Access databases to SQL Server can be done different ways from
both sides. Also, depending on the version of SQL Server that you target you
can use different tools too.
Here are a few links that will give you a good start:
SQL Server Migration Assistant for Access (for migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/soluti...ss/default.mspx
Moving Your Access 2002 Database to SQL Server 2000 (look at the Data
Transformation Services section for importing Access data to SQL Server):
http://msdn2.microsoft.com/en-us/library/aa902657(SQL.80).aspx
How to use the Upsizing wizard in Access 2002:
http://support.microsoft.com/default.aspx/kb/330468
Access 2002 Upsizing Tools white paper:
http://support.microsoft.com/default.aspx/kb/294407
In the past I have used many times the Data Transformation Services in SQL
Server 2000 to import data from Access databases and it has been working
very well. Recently I used the SQL Server Import and Export Wizard in SQL
Server 2005 to import a few tables from .mde files and no problems there
too.
Regards,
Plamen Ratchev
http://www.SQLStudio.com|||I tried the simplest method I could. In SQL 2000, using enterprise manager,
I imported the mde. In source, I chose the Access type. I then chose the
file (after changing the file filter from *.mdb to all files). After
accepting the SQL Server data source, I checked all of the tables in the mde
.
The import wizard created my tables and imported the data.
--
Russel Loski, MCSD.Net
"dba_222@.yahoo.com" wrote:

> Dear Experts,
> I have some Access .mde files from a custom application.
> The runtime version of Access is 2002. I don't have
> a developer's version of Access. I also don't have the
> schema design of the app.
> I'd like to import or migrate the data file into SQL Server
> schemas (databases) somehow. Or, another database
> like Oracle.
> Is it possible to do this from SQL Server?
> What is the buzzword that I can search on?
> Is there a link you can forward?
> Thanks a lot!
>|||<dba_222@.yahoo.com> wrote in message
news:1169516295.667810.162270@.51g2000cwl.googlegroups.com...
> Dear Experts,
> I have some Access .mde files from a custom application.
> The runtime version of Access is 2002. I don't have
> a developer's version of Access. I also don't have the
> schema design of the app.
> I'd like to import or migrate the data file into SQL Server
> schemas (databases) somehow. Or, another database
> like Oracle.
> Is it possible to do this from SQL Server?
> What is the buzzword that I can search on?
> Is there a link you can forward?
> Thanks a lot!
>|||you should use DTS or something similiar in order to import all of your
Access Databases into SQL Server
"la playa mas bella" <thepadrino_1@.hotmail.com> wrote in message
news:eSt2kaXgHHA.588@.TK2MSFTNGP06.phx.gbl...
> <dba_222@.yahoo.com> wrote in message
> news:1169516295.667810.162270@.51g2000cwl.googlegroups.com...
>

Migrate / Read Access data file(s) in SQL Server

Dear Experts,
I have some Access .mde files from a custom application.
The runtime version of Access is 2002. I don't have
a developer's version of Access. I also don't have the
schema design of the app.
I'd like to import or migrate the data file into SQL Server
schemas (databases) somehow. Or, another database
like Oracle.
Is it possible to do this from SQL Server?
What is the buzzword that I can search on?
Is there a link you can forward?
Thanks a lot!Migrating Access databases to SQL Server can be done different ways from
both sides. Also, depending on the version of SQL Server that you target you
can use different tools too.
Here are a few links that will give you a good start:
SQL Server Migration Assistant for Access (for migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
Moving Your Access 2002 Database to SQL Server 2000 (look at the Data
Transformation Services section for importing Access data to SQL Server):
http://msdn2.microsoft.com/en-us/library/aa902657(SQL.80).aspx
How to use the Upsizing wizard in Access 2002:
http://support.microsoft.com/default.aspx/kb/330468
Access 2002 Upsizing Tools white paper:
http://support.microsoft.com/default.aspx/kb/294407
In the past I have used many times the Data Transformation Services in SQL
Server 2000 to import data from Access databases and it has been working
very well. Recently I used the SQL Server Import and Export Wizard in SQL
Server 2005 to import a few tables from .mde files and no problems there
too.
Regards,
Plamen Ratchev
http://www.SQLStudio.com|||<dba_222@.yahoo.com> wrote in message
news:1169516295.667810.162270@.51g2000cwl.googlegroups.com...
> Dear Experts,
> I have some Access .mde files from a custom application.
> The runtime version of Access is 2002. I don't have
> a developer's version of Access. I also don't have the
> schema design of the app.
> I'd like to import or migrate the data file into SQL Server
> schemas (databases) somehow. Or, another database
> like Oracle.
> Is it possible to do this from SQL Server?
> What is the buzzword that I can search on?
> Is there a link you can forward?
> Thanks a lot!
>|||you should use DTS or something similiar in order to import all of your
Access Databases into SQL Server
"la playa mas bella" <thepadrino_1@.hotmail.com> wrote in message
news:eSt2kaXgHHA.588@.TK2MSFTNGP06.phx.gbl...
> <dba_222@.yahoo.com> wrote in message
> news:1169516295.667810.162270@.51g2000cwl.googlegroups.com...
> > Dear Experts,
> >
> > I have some Access .mde files from a custom application.
> >
> > The runtime version of Access is 2002. I don't have
> > a developer's version of Access. I also don't have the
> > schema design of the app.
> >
> > I'd like to import or migrate the data file into SQL Server
> > schemas (databases) somehow. Or, another database
> > like Oracle.
> >
> > Is it possible to do this from SQL Server?
> > What is the buzzword that I can search on?
> > Is there a link you can forward?
> >
> > Thanks a lot!
> >
>

Microsoft SQL Server Publisher Always Wins Conflict Resolver?

Hi experts,
I am using merge repl, in SQL Server 2000.
1) Is there a ready-made "Microsoft SQL Server Publisher Always Wins
Conflict Resolver"? There is one for subscriber, but not one for publisher.
Need that as I just want to "broadcast" the data, and don't want any
subsriber to accidentally corrupt the publisher data.
2) What are "Microsoft SQL Server Download Only Conflict Resolver" and
"Microsoft SQL Server Upload Only Conflict Resolver"?
Many thanks in advance.
The Publisher always wins is the default resolver if you don't do anything.
I'll have a look into (2) and get back to you.
Cheers, Paul Ibison
|||For your resolvers question, "SQL Server Upload Only Conflict Resolver":
Changes uploaded to the Publisher are accepted; changes are not downloaded
to the Subscriber. For downloads it is the inverse.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)