Showing posts with label design. Show all posts
Showing posts with label design. Show all posts

Wednesday, March 21, 2012

Patterns for table design

I am looking for something similar to patterns for table design, but I have been unable to find anything on that, or good rule of thumb performance guides for table design.

Most of the situations we face look like perfect candidates for patterns, and some good rules of thumb -- problems like scalable OLAP requirements PLUS real time reporting.

I am looking for several differnet approaches and a good summary of the trade-offs for each one.

Thanks!

You're in luck...the newest book in the Martin Fowler Signature Series is on Database Refactoring

http://martinfowler.com/books.html#refactoringDatabases

I haven't read it yet but looking at the website (that has a catalog of the patterns), it seems to be pretty thorough. It goes hand in hand with Martin's Patterns of Enterprise Application Architecture and the other book in the series on Enterprise Integration Patterns.

Tuesday, March 20, 2012

Path of Tasks

Hi,

no results during my search of the web, maybe one of yours can help.

Is there a possibility (during design time is OK) to find out, which TaskHost is before and after a CustomTask (by wiring in ssis-designer) and which type of wire it is (Error, Finish, Success).

Maybe the order of executables is providing this information, when there are no props or methods (and i found none), but then you don't know anything about the type.

Any ideas?

Thanks

Found it out by myself.

TaskHost.Parent.PrecedenceConstraints gives a list of connections between the Executables.

|||

Hi,

but there is no possibility to check via Validate().

Is there a possibility to tell a task in designer, that it has been connected or unconnected. And from this point to have access to the PrecedenceConstraints-Property / TaskHost

Thanks

Thorsten

Friday, March 9, 2012

Password protect report design

Can I password protect a released CR so that the report cannot be opened in design mode?
I am using CR10 advanced developerMe too looking to resolve this issue. This is what I know so far as far as making it read only part is concerned. For protecting I remember seeing a note through Business Objects that there is no way to protect these reports. They are editable as long as if end user has Crystal Report software of his own.

Making a report or object read-only
You can make a report or object read-only so it can't be formatted. When you set this option, choices in the Format Editor become inactive. The formatting options that are usually available on the toolbars or shortcut menus are also suppressed for the report or object.

Note: This feature is for your convenience in protecting report formatting; it is not intended to be used as report security.

To make a report read-only
On the File menu, select Report Options.
Select Read-only.
To make an object read-only
Right-click the object you want to make read-only.
On the shortcut menu, click Format Editor.
The Format Editor dialog box appears.

On the Common tab, select Read-only.
Note: You can also do this by clicking the Lock Format button on the Formatting toolbar.|||Yea thanks dilemma for that, I have got that far but want to protect all my hard work on formula's etc because if I create a report and want to issue on a try before you buy, then I need some lockdown. I have also posted on CR forum but I won't hold my breath !!|||I had come across this situation and finally decided to distribute reports but charge clients if they want support of our own reports. Support cost covers my development cost.

It's interesting , even I am interested to know the answer.

Thanks|||I have had a reply from a CR forum, very concise..answer is: -
NO

I think CR should do this feature in next release.|||Absolutely I agree with you.