Migrating from Crystal to SSRS questions

Hi all,
Our company is considering converting all our reports from Crystal to SSRS.
We have done a fair bit of research. I have a number of questions that I
can't find answers to. If anyone with experience using the software could
help me out with some answers, I'd be most grateful.
1. Can you save data with a report? or do you have to connect to data every
time you run a report?
2. I've heard when scrolling a matrix report that the row heading overlaps
values when scrolling and looks very messy. Is this true and is there a way
to stop it happening as a lot of our reports are Matrix based?
3. Is there an equivalent to Crystal's Group Explorer, for just viewing a
certain group?
4. With regards date formatting we have heard it defaults to US date. Is it
possible to permanently overide this or do you have to do it manually for
each report?
Many thanks
JHJH,
I'm having some difficulty getting this feature to work accross the
entire row header. But, what I've found out so far is RS2005 does
offer the feature, but it's not very intuitive to use. The only way
I've found it to work (somewhat) is
1. Add a group to your Matrix/Table.
2. Edit the group by right-clicking the group text-box.
3. Check the box at the bottom of the General tab for "Group header
should remain visible while scrolling".
I haven't figured out yet how to select the entire row (which in my
case contains about 15 measures) and set the row to freeze like in
excel. I even tried to add subsequent groups as separate
measures...can't figure that one out either.
Corey
JH wrote:
> Hi all,
> Our company is considering converting all our reports from Crystal to SSRS.
> We have done a fair bit of research. I have a number of questions that I
> can't find answers to. If anyone with experience using the software could
> help me out with some answers, I'd be most grateful.
> 1. Can you save data with a report? or do you have to connect to data every
> time you run a report?
> 2. I've heard when scrolling a matrix report that the row heading overlaps
> values when scrolling and looks very messy. Is this true and is there a way
> to stop it happening as a lot of our reports are Matrix based?
> 3. Is there an equivalent to Crystal's Group Explorer, for just viewing a
> certain group?
> 4. With regards date formatting we have heard it defaults to US date. Is it
> possible to permanently overide this or do you have to do it manually for
> each report?
> Many thanks
> JH

Migrating from Crystal Reports Charts using TopN and "Other" to Reporting Services

I am currently migrating several Crystal Reports that have charts. The chart series is set to use the TopN values in a count, and combine the rest of the series into one series titled "Other". I see how to filter the chart using TopN, however I need to still show the rest of the data grouped as "Other". I think the solution I need is to create a group expression that uses some sort of IIF function to create the "Other" group, but I haven't found a function that I can use to get the results I need. Any ideas?

Scott

I found the answer to my question in another forum.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1055659&SiteID=1

I used option 1.

Migrating from Crystal Reports Charts using TopN and "Other" to Reporting Services

I am currently migrating several Crystal Reports that have charts. The chart series is set to use the TopN values in a count, and combine the rest of the series into one series titled "Other". I see how to filter the chart using TopN, however I need to still show the rest of the data grouped as "Other". I think the solution I need is to create a group expression that uses some sort of IIF function to create the "Other" group, but I haven't found a function that I can use to get the results I need. Any ideas?

Scott

I found the answer to my question in another forum.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1055659&SiteID=1

I used option 1.

Migrating From CR 9 to VS Reporting Services

Hi,
I'm not that familiar with VS RS and I have to convert reports from Crystal
Report 9 to VS RS.
Is it possible ? If not, is there any equivalent of the "unbound fields"
from CR9 in VS RS ?
Thanks in Advance.
wadjaHello Wadja,
I apologize for contacting you on an unsolicited basis, but I read a
few of your postings on Google's Crystal Developers users group and
hoped that you'd be willing to help me.
I'm a journalist with Application Development Trends magazine (ADT,
http://www.adtmag.com), and I'm working on a story on reporting tools
from a developer's perspective. As you no doubt know, Crystal has
long been pretty much the only game in town in this respect, as the
former Crystal Decisions seeded the market with this tool (it's shipped
with Visual Studio for more than a decade, for example, and it ships
with a host of other applications and tools, too).
Now, however, developers have a choice of which reporting tool to use
when they need to incorporate reporting functionality into their apps.
Microsoft announced its SQL Server 2000 Reporting Services last year,
and there's even an open source alternative called BIRT (that's short
for BI Reporting Tool). I'd like to take a look at the positives and
negatives of each of these solutions -- Crystal still seems hard to
beat for straight-up reporting, but both Reporting Services and BIRT
promise better (that is, cheaper) report lifecycle management
capabilities, which could make them better choices for many BI-related
reporting applications.
Would you mind having a go at a few of the questions I've appended
below? I'd love to hear your thoughts on this issue. If your employer
prohibits you from speaking on the record to journalists, I don't
have a mind abstracting its identity (e.g., "a major pharmaceutical
company based in the Northeast," or "a large financial services
firm based in the American South"). So don't let that stop you.
Thanks very much for your time. I appreciate it, and I apologize, once
again, for contacting you on an unsolicited basis.
Best,
Steve
1. Is your organization invested in Crystal, or have you transitioned
over to Reporting Services? If the former, for what purposes or in
support of which applications do you use Crystal? (I'm trying to get
a sense for whether you use Crystal mostly as a default reporting tool
for app dev purposes, whether it's tied to the use of any specific
application, or whether you're using it mostly as a reporting
front-end for data warehousing and BI.)
2. Did your organization opt for Crystal as a matter of choice -
e.g., you evaluated CR in addition to a host of other tools - or did
it go with Crystal largely because it was bundled with your default
development environment, or core applications that you use?
3. In comparison with Reporting Services and other reporting solutions,
what features about Crystal do you most like? What features about it
would you most like to change? How well do you feel Crystal
addresses/addressed your core use requirements?
4. Re: Reporting Services, are you currently using it? If not, have you
looked into using it? What features, if any, do you most like? What
features, if any, are deal-breakers for you? How do you feel that
Reporting Services compares with Crystal and other established
reporting solutions?
5. Do you have any interest in an open source reporting tool based on
the Eclipse development framework? If so, have you looked at the BIRT
project?|||Hello Steve,
As I said before, I'm new with reporting tools and with my company.
Therefore I can hardly make objective answers to you.
All I can tell is that they (developers before I step in) used Crystal
Report (CR) to test it. Now, we currently use Reporting Services(RS). The
reasons that made us change :
- We don't have to invoice our clients for using CR, it is included in
Microsoft Licences (we have a partnership with this company).
- Several developers complained about the technical support given with CR.
They hardly find professional help they needed.
- I was said designing on RS was much more easier than on CR.
For the moment, we are not interested in other report tools, as RS meets our
satisfaction.
I hope I gave any relevant information for you.
Best,
wadja
"daedalus" <stephen.swoyer@.gmail.com> a écrit dans le message de news:
1117634907.794866.228080@.f14g2000cwb.googlegroups.com...
> Hello Wadja,
> I apologize for contacting you on an unsolicited basis, but I read a
> few of your postings on Google's Crystal Developers users group and
> hoped that you'd be willing to help me.
> I'm a journalist with Application Development Trends magazine (ADT,
> http://www.adtmag.com), and I'm working on a story on reporting tools
> from a developer's perspective. As you no doubt know, Crystal has
> long been pretty much the only game in town in this respect, as the
> former Crystal Decisions seeded the market with this tool (it's shipped
> with Visual Studio for more than a decade, for example, and it ships
> with a host of other applications and tools, too).
> Now, however, developers have a choice of which reporting tool to use
> when they need to incorporate reporting functionality into their apps.
> Microsoft announced its SQL Server 2000 Reporting Services last year,
> and there's even an open source alternative called BIRT (that's short
> for BI Reporting Tool). I'd like to take a look at the positives and
> negatives of each of these solutions -- Crystal still seems hard to
> beat for straight-up reporting, but both Reporting Services and BIRT
> promise better (that is, cheaper) report lifecycle management
> capabilities, which could make them better choices for many BI-related
> reporting applications.
> Would you mind having a go at a few of the questions I've appended
> below? I'd love to hear your thoughts on this issue. If your employer
> prohibits you from speaking on the record to journalists, I don't
> have a mind abstracting its identity (e.g., "a major pharmaceutical
> company based in the Northeast," or "a large financial services
> firm based in the American South"). So don't let that stop you.
> Thanks very much for your time. I appreciate it, and I apologize, once
> again, for contacting you on an unsolicited basis.
> Best,
> Steve
> 1. Is your organization invested in Crystal, or have you transitioned
> over to Reporting Services? If the former, for what purposes or in
> support of which applications do you use Crystal? (I'm trying to get
> a sense for whether you use Crystal mostly as a default reporting tool
> for app dev purposes, whether it's tied to the use of any specific
> application, or whether you're using it mostly as a reporting
> front-end for data warehousing and BI.)
> 2. Did your organization opt for Crystal as a matter of choice -
> e.g., you evaluated CR in addition to a host of other tools - or did
> it go with Crystal largely because it was bundled with your default
> development environment, or core applications that you use?
> 3. In comparison with Reporting Services and other reporting solutions,
> what features about Crystal do you most like? What features about it
> would you most like to change? How well do you feel Crystal
> addresses/addressed your core use requirements?
> 4. Re: Reporting Services, are you currently using it? If not, have you
> looked into using it? What features, if any, do you most like? What
> features, if any, are deal-breakers for you? How do you feel that
> Reporting Services compares with Crystal and other established
> reporting solutions?
> 5. Do you have any interest in an open source reporting tool based on
> the Eclipse development framework? If so, have you looked at the BIRT
> project?
>sql

Migrating from Access to SQL Server

I recently migrated some user tables from Access to SQL Server while leaving
the forms, reports, and queries in Access with Linked tables to the SQL
instance. Some of the users queries/forms are not working correctly? It
seems that Access Queries return a single empty row when no matches are foun
d
while SQL Server returns an empty result set. In Access, the users use a
query to search for a customer number, if no matching number is found the
customer form is displayed with one record containing no values and the user
s
can then input new customer information. When the query/form is pointed to
SQL Server, when no matching customer is found a blank page is displayed. I
s
there a way to force SQL Server to return an empty row if none are found?Hi,
probably the attached script would help to you (I'm not sure how to
implement it within Access enviroment):
create table t (col1 int null, col2 varchar(10) null)
--without variables
select col1,col2 from t
union all
select null, null
--with variables
declare @.r as int
select * from t
set @.r=@.@.rowcount
if @.r>0
return
else
select null as col1, null as col2
drop table t
Denis
"DT" wrote:

> I recently migrated some user tables from Access to SQL Server while leavi
ng
> the forms, reports, and queries in Access with Linked tables to the SQL
> instance. Some of the users queries/forms are not working correctly? It
> seems that Access Queries return a single empty row when no matches are fo
und
> while SQL Server returns an empty result set. In Access, the users use a
> query to search for a customer number, if no matching number is found the
> customer form is displayed with one record containing no values and the us
ers
> can then input new customer information. When the query/form is pointed t
o
> SQL Server, when no matching customer is found a blank page is displayed.
Is
> there a way to force SQL Server to return an empty row if none are found?
>|||Although your solution does cause the form to be displayed (progress!) I can
not enter data on the form? Am I missing something?
"Denis" wrote:
> Hi,
> probably the attached script would help to you (I'm not sure how to
> implement it within Access enviroment):
> create table t (col1 int null, col2 varchar(10) null)
> --without variables
> select col1,col2 from t
> union all
> select null, null
> --with variables
> declare @.r as int
> select * from t
> set @.r=@.@.rowcount
> if @.r>0
> return
> else
> select null as col1, null as col2
>
> drop table t
> Denis
> "DT" wrote:
>|||There is no such thing as an "empty" row in SQL Server. The functionality
you are wanting would probably be a property of the recordset or data grid.
"DT" <DT@.discussions.microsoft.com> wrote in message
news:0D425E66-49D7-4C46-97E2-7813DB70A6D0@.microsoft.com...
>I recently migrated some user tables from Access to SQL Server while
>leaving
> the forms, reports, and queries in Access with Linked tables to the SQL
> instance. Some of the users queries/forms are not working correctly? It
> seems that Access Queries return a single empty row when no matches are
> found
> while SQL Server returns an empty result set. In Access, the users use a
> query to search for a customer number, if no matching number is found the
> customer form is displayed with one record containing no values and the
> users
> can then input new customer information. When the query/form is pointed
> to
> SQL Server, when no matching customer is found a blank page is displayed.
> Is
> there a way to force SQL Server to return an empty row if none are found?
>

Migrating From Access 2000 To SQl Server 2000

Hi,

I have developed an application using VB 6 (SP 5), MS Access 2000 and
Crystal Reports 9. I migrated from from access to SQl Server 2000.
This wasn't a problem as i could import all the tables to SQL Server.
Also, i could make VB6 talk to SQl Server.

The problem arsies when i run my application. The sql syntax for
access seems to be different than that for SQL Server. A simple
example being: In access boolean datatype is true/false ,whereas in
SQL Server the boolean equivalent is bit (numerical 1 or 0). These
kind of issues are causing problems and most queries don't run.

Would i need to go and change all the queries in accordance with SQl
Server syntax ,which would be very time consuming or is there any
function which will convert the access datatype into its equivalent
SQl Server datatype??

Any input/thoughts/suggestions would be appreciated.

Thanks
JatinThere is a big problem with ODBC JET Linked tables when it comes to boolean
fields in Access that get turned into BIT fields in SQL Server.

Basically, JET thinks of boolean TRUE as (-1) where SQL thinks of it as (1).
The ODBC driver switches the values for you in Access, so that when you look at
the table it shows (-1)...but if you look at the table in SQL Server it says
(1).

The bottom line is that the ODBC driver does NOT understand what TRUE or FALSE
means, so the short answer is YES, you have to change all of those refrences to
(-1) or (0) respectively.

The standard, quick answer to this problem is to use a find/replace tool (in
NOTEPAD) to change all

= TRUE

to

= -1

and = FALSE

to

= 0

WARNING: This is only true for JET-based ODBC queries. If you create a view on
SQL Server, you'll have to use = 1 for TRUE!!!!

For that reason, I normally use =0 for FALSE, and <>0 for TRUE!!! That way, it
always works.

Another option is to change the BIT datatype on SQL Server to INT
(integer)...that way a (-1) WILL BE STORED by the ODBC driver, and it'll be
consistent.

Hope this helps!

Migrating Crystal Reports from 8x to 11x

Hi All,

I have an application in Crystal Report 8x version which needs to be migrated to 11x. Also assume that the Database is also changing. Maybe from one server to another server or one RDBMS to other RDBMS.

My questions are as follows.

1. How to migrate from version 8.x to 11.x, what are all the steps?
2. How to do database changes in the Crystal Reports?
3. Is there any client version for Crystal Reports? If so, how to view that and what are all the changes in the client version that needs to be done.
4. How do we access the crystal reports externally where we don't install the software? Is there any external components that will be used? If so, what is that?

Kindly clarify me the above questions ASAP.See if you find answer here
www.Businessobjects.com|||Hi,

Can you be more specific about how your reports are currently deployed? I'm moving Crystal 8 reports deployed in ASP using the Web Component Server to ASP using RAS (Report Application Server). The steps are as follows:

Open the version 8 report in 10 and save as a 10 report

Rewrite the ASP to call the report using RAS

Currently I'm running 8 and 10 on the same server and am migrating one report at a time, because the newer versions of Crystal will run side-by-side with previous versions.......of course you want to test that carefully before deploying both versions on a production server!

Changing the database "shouldn't" be a big deal, depending again on what you end up with. I go to set location inside the report designer and handle it there. If you change RDBMS' and your table/field names change, you may as well plan on rewriting the reports.

Hope that helps!

Linda

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

Migrating all reports to a new server

I'm Managing Reporting Services in a mid-size company, and we are just
beginning to develop reports for different departments...We just set
up a new server and redeployed all of our reports (there were just a
few so far)...
My question is..What happens when we have hundreds of reports and need
to migrate our entire reporting services system to a new server?
Subsequently, In a worst-case situation, how would we recover reports?
I appreciate your help!
-ScottStill looking for a response...This is an important need. Thanks in
advance!

Migrate SSRS 2005 Reports

Hi,

I need to move few folders from our DEV SSRS 2005 environment to another
server. Folders will be moved to new parent folders.
Is there any tool that I can use fot this purpose?
I used RSScripter from SQLdbatips.com. Although the tool works great but it
can't script multiple folder reports. I have to script one by one and it is
a big problem.

Thanks
AlexIt cannot? I have version 2.0.0.6 and I can select multiple folders.

Migrate or Script Subscriptions and Schedules

I've used RSScripter.exe to move reports and permissions to a new server.
The scripter does not seem to be bringing over subscriptions or shared
schedules.
Is there a good way to migrate subscriptions for existing reports from one
server to the other?It seems the log shows the following error: EXECUTE permission denied on
object 'xp_sqlagent_is_starting'
I've tried running this on the box, under the context of local
administrator, even the domain account running the ReportServer service and
it's still not working.
"Scott" wrote:
> I've used RSScripter.exe to move reports and permissions to a new server.
> The scripter does not seem to be bringing over subscriptions or shared
> schedules.
> Is there a good way to migrate subscriptions for existing reports from one
> server to the other?

Migrate from Crystal Reports to SQL Server Reports

I have a requirement to convert reports from Crystal Reports to SQL
Server Reports. Is there any tool to do this? or Do I need to redesign
every report in SQL Server Reports?
MadhivananI have the same problem and spent a few days looking for converters and
other help. Unfortunately, there aren't any. The Crystal format is
proprietary, and I didn't find a converter.
--
Floyd
"Madhivanan" <madhivanan2001@.gmail.com> wrote in message
news:1125989239.108925.278830@.g43g2000cwa.googlegroups.com...
>I have a requirement to convert reports from Crystal Reports to SQL
> Server Reports. Is there any tool to do this? or Do I need to redesign
> every report in SQL Server Reports?
> Madhivanan
>|||From Crystal [Licence.pdf]
4.6.5 (Excerpt)
"End User agrees not to alter, disassemnble, decompile, translate, adapt or
reverse-engineer the Runtime Software or the report file (.RPT) format"
"End user agrees not to use the runtime software to create for distribution
a product that converts the report file (.RPT) format to an alternative
report file format ... or product that is not the property of Crystal
Decisions"
"Floyd Burger" wrote:
> I have the same problem and spent a few days looking for converters and
> other help. Unfortunately, there aren't any. The Crystal format is
> proprietary, and I didn't find a converter.
> --
> Floyd
> "Madhivanan" <madhivanan2001@.gmail.com> wrote in message
> news:1125989239.108925.278830@.g43g2000cwa.googlegroups.com...
> >I have a requirement to convert reports from Crystal Reports to SQL
> > Server Reports. Is there any tool to do this? or Do I need to redesign
> > every report in SQL Server Reports?
> >
> > Madhivanan
> >
>
>|||Thanks. It seems that redesign is the only way
Madhivanan

Microsoft SQL Server Management Studio problem

The 'Reports' button on the Summary screen is disabled. How can I get it enabled so that I can view the database dashboard?

I have installed SQL Server 2005 Developer Edition with Reporting services

ThanksThe Reports button is context sensitive. In the object browser, click/highlight your database, then the reports button should be enabled. A wrote in message news:61cb2041-e52f-4503-b439-60aa3ba7eefc@.discussions.microsoft.com...
> The 'Reports' button on the Summary screen is disabled. How can I get it
> enabled so that I can view the database dashboard? >
> I have installed SQL Server 2005 Developer Edition with Reporting
> services >
> Thanks
>|||That is right. It is context specific. It is enabled when a DB is selected and similarly, the report button is enabled when server is selected to see server dashbord.