Showing posts with label migration. Show all posts
Showing posts with label migration. Show all posts

Thursday, March 22, 2012

alert messages in SSRS

hi,

I am working on migration from crystal reports to SSRS. my crystal report has some alerting formulas, which displays pop-ups at runtime based on some conditions.How do i implement those alerting formulas in SSRS.

Thanks in advance.

I think you can call msgboxes from code, beyond that there isn't anything.

Why are you migrating from Crystal to RS?

Sunday, March 11, 2012

Aggregation Migration

Definitions of aggregations objects in AS2K5 are organized in AggregationsDesign groups so as to be able to assign a unique definition to several partitions within a Measure Group.

When Migration Wizard migrate aggregations, if two AS2K aggr sets from two different partitions of the same cube have exactly the same definition but are ordered in a different way, the Migration Wizard process will create two different AggregationsDesign with different name, duplicating xmla descriptions.

So It's better to order all the same aggr.definitions by the same criteria in every partition of a cube before migrating it.

It can be done by using the Partition Aggregation Utility.

Thanks.

I would not worry about arranging aggregations in AS2K.

AS2K5 gives you a lot of power and flexibility as it comes to editing objects.

I would migrate the cube in whatever state it is. Later I would clean up the AS2K5 database using scripted view of the database.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights