im new to sql reporting services, im in need of a rdl (report definition language)generator
are there any resouirces out there on the net ?
if so , can u suggest some links for the same?
thanks in advance !
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 toolsomething which the customers can use
in case u wanna know the details they are AND MOST IMPORTANTLY IT SHOULD BE WINDOWS BASED NOT A WEB APPLICATION:-
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