Re: Ad Hoc SQL Query / Report Builder

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You need to create a Report Data Model with VS2008/BI Studio2008 and then publich to SQL Server 2008 Reporting Services. THen start Report Builder, select the Report Data Model your reports will be built against. Off you go.

Actually, if no Report Data Model is available, Report Builder does not let you go further.

For more information on Report Data Model, go to SQL Server2008 Book On Line.

"iweb" <iweb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:359EBC49-E425-4965-9DC0-A64CDCF1019A@xxxxxxxxxxxxxxxx
Unable to trace the Report Data Model concept in 2008 to be used via Report
Builder. Can you please help us with specific details on it?

Akshay.

"Norman Yuan" wrote:

If the front-end GUI means for user, then Visual Studio is out: it is for
developer (well, you can develop what you want with VS, though).

SQL Server's Reporting Services comes with a "Click Once" desktop
application, called Report Builder, which is meant for non-developer user to
build simple report, well, the user need to know some DB concept, some DB
reporting knowledge...

In SQL Server 2008, the Report Builder has been improved, and Report Data
Model concept is introduced. You as developer, can build report data model
and make it available for Report Builder user. With report data model, user
can easily do the ad hoc query and create a report without knowing the
compexity of SQL Server database tables, views, SPs....

I think, if you are looking for MS tool, SSRS' Report Builder is what you
most likely end up with.

"iweb" <iweb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:61D43100-874D-40FD-8478-1F4C396A8444@xxxxxxxxxxxxxxxx
> Does Visual Studio or MS SQL Server or any native Microsoft Product > have
> the
> capability of Ad Hoc Query Building / Report Making in real time, on > the
> fly
> from the front end GUI?
>
> Like is possible with the software available at
> http://devtools.korzh.com/eq/dotnet/D
>
> Does any of Microsoft Software have this capability??
>
> Akshay.



.

Relevant Pages

  • Re: looking for a webpart or webcontrol to display 2005 KPI?
    ... SQL Server Report Builder also supports AS 2005 KPI's, ... I've think seen a demo of incorporating a KPI ...
    (microsoft.public.sqlserver.olap)
  • To Glynn Owen and Iman L Crawford
    ... I have a report builder whose output is geared mostly towards data rather than ... or both the temp tables and your regular database tables. ... report into either an excel file, an access database, an xml file, a flat fixed ...
    (borland.public.delphi.non-technical)
  • Re: Report Writer to Replace Fast-Report 3?
    ... > My big problem with Report Builder is that it appears you have to ... > event-level scripting capability, what they refer to as RAP. ... RAP is specific to end-user reporting (or to creating ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Report Writer to Replace Fast-Report 3?
    ... > themselves such huge damage. ... If I have to rewrite anyway, maybe Report ... >>> My big problem with Report Builder is that it appears ... >>> purchase the Enterprise edition in order to ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Reporting Services Report Model
    ... processes report models, but instead of rendering reports, I just want to get ... and send for query execution. ... the tool to design sql queries based on a report model. ... You mean that you want to create a tool like Report Builder, ...
    (microsoft.public.dotnet.general)