For an SCD surrogate generator, I want to read a package variable that I've populated with the MAX () surrogate to begin my surrogate seed at. Does anyone have a piece of code sample to do this?
In your script component assign the variable in the properties of the component either to the readonly list or readWrite List. You can then access the variable in the script component withVariables.myVariable
Where myVariable is the name of your variable.
Hi,
I do not really know if I am interpreting your question in the right way..
You are not searching for a tool like the "Business Intelligence Development Studio" which is included in the Client Installation of SQL 2005 and is the tool for developing projects for SSIS, SSAS and SSRS...
If you want to develope your own report generator you could use this link and code http://msdn2.microsoft.com/en-us/library/ms170239.aspx as a start point.
cheers,
Markus
This one I think it best: http://msdn2.microsoft.com/en-us/library/ms170667.aspx
Here are a few others:
http://www.codeproject.com/csharp/rdlproject.asp
http://blogs.msdn.com/swisowaty/archive/2006/06/07/620838.aspx
|||thanks ??€?§Q? for your response... i had managed to come across those links and build the rdl generator
follow up:
what we actually need was a custom report designer that would give the corresponding rdl file of the user specified format
so the rdl generator was just a small part ..
so any ideas/clues /suggestions are very welcome , pls help !
|||thanks markus for that link , but i had already come up with that one...and no we are not supposed to use the report builder in the ssrs package .|||
kuruvilla wrote:
a custom report designer that would give the corresponding rdl file of the user specified format
What do you mean by this?
|||Hi,
instead of programming a new softwareon your own you probably should give rsinteract [www.rsinteract.com] a try...
cheers
Markus
|||well what i meant was the same utilities which u have with the reporrt builder , is what is needed but maybe not as diverse and feature rich as we have in the report builder tool
o follows a Wizard pattern to generate Report
o Tree-view listing of Reports, Reports can be grouped and sub-grouped
o Wizard navigates treads the following path, Select a table->Brings up Related Tables->Field Selection->Manipulate Field (Can select a field, for query generation, but opt to not print it)->Multiple Sorts->Filtering of Data
The above procedure acts as a Query Generator and generates a Query to be executed to retrieve data
o Report Designer, a canvas area to decide the layout of the Report. Actual Report generation is assisted by a third-party tool.
o Fields on Report Designer can be formatted using a context menu
o Formula option provides complete flexibility in defining a formula field More details required
o No Sub-Reports
o Data entry forms are linked to fields on the Reports, user can click on a field and a Form is opened with relevant data
o Report is divided in different section Report Header, Page Header, Section Header etc.
o Tree-view of the Controls Structure, placed on the canvas can be seen. The structure is editable through this feature
o Drawing tools are provided to be used on the canvas
o Image of different formats can be placed on the canvas
o Text boxes and Font can be formatted
o Page Setup, Paper Size for the Report can be defined
o Status bar provides information while dragging fields and on mouse-over for the formula fields
o Report can be exported to various formats Excel, HTML, DBF, CSV, PDF
o Report can be send via an Email. It can be send as a PDF attachment, as an attachment in Custom format with a Custom reader. (Custom format not required now)
o Reports can be compressed and send via an Email
o Snapped Grid Context-sensitive help
|||THANKS MARCKUS..well thats just about what i needed i guess, but not as a web app, but i need it to be embedded in the windows applicationHi,
I do not really know if I am interpreting your question in the right way..
You are not searching for a tool like the "Business Intelligence Development Studio" which is included in the Client Installation of SQL 2005 and is the tool for developing projects for SSIS, SSAS and SSRS...
If you want to develope your own report generator you could use this link and code http://msdn2.microsoft.com/en-us/library/ms170239.aspx as a start point.
cheers,
Markus
This one I think it best: http://msdn2.microsoft.com/en-us/library/ms170667.aspx
Here are a few others:
http://www.codeproject.com/csharp/rdlproject.asp
http://blogs.msdn.com/swisowaty/archive/2006/06/07/620838.aspx
|||thanks ??€?§Q? for your response... i had managed to come across those links and build the rdl generator
follow up:
what we actually need was a custom report designer that would give the corresponding rdl file of the user specified format
so the rdl generator was just a small part ..
so any ideas/clues /suggestions are very welcome , pls help !
|||thanks markus for that link , but i had already come up with that one...and no we are not supposed to use the report builder in the ssrs package .|||
a custom report designer that would give the corresponding rdl file of the user specified format
What do you mean by this?
|||Hi,
instead of programming a new softwareon your own you probably should give rsinteract [www.rsinteract.com] a try...
cheers
Markus
|||well what i meant was the same utilities which u have with the reporrt builder , is what is needed but maybe not as diverse and feature rich as we have in the report builder tool
o follows a Wizard pattern to generate Report
o Tree-view listing of Reports, Reports can be grouped and sub-grouped
o Wizard navigates treads the following path, Select a table->Brings up Related Tables->Field Selection->Manipulate Field (Can select a field, for query generation, but opt to not print it)->Multiple Sorts->Filtering of Data
The above procedure acts as a Query Generator and generates a Query to be executed to retrieve data
o Report Designer, a canvas area to decide the layout of the Report. Actual Report generation is assisted by a third-party tool.
o Fields on Report Designer can be formatted using a context menu
o Formula option provides complete flexibility in defining a formula field More details required
o No Sub-Reports
o Data entry forms are linked to fields on the Reports, user can click on a field and a Form is opened with relevant data
o Report is divided in different section Report Header, Page Header, Section Header etc.
o Tree-view of the Controls Structure, placed on the canvas can be seen. The structure is editable through this feature
o Drawing tools are provided to be used on the canvas
o Image of different formats can be placed on the canvas
o Text boxes and Font can be formatted
o Page Setup, Paper Size for the Report can be defined
o Status bar provides information while dragging fields and on mouse-over for the formula fields
o Report can be exported to various formats Excel, HTML, DBF, CSV, PDF
o Report can be send via an Email. It can be send as a PDF attachment, as an attachment in Custom format with a Custom reader. (Custom format not required now)
o Reports can be compressed and send via an Email
o Snapped Grid Context-sensitive help
|||THANKS MARCKUS..well thats just about what i needed i guess, but not as a web app, but i need it to be embedded in the windows application