Generic report and dataset

Hello,
I am new to SRS. So this is a new-be question.
When creating a new report in visual studio. When creating a new dataset.
Do you always need to create a query string to retrieve the fields that can
be used on the form?
Is there some SQL picker query builder. Where you can build a query by
picking and choosing from all tables?
To help people out?
thanksOn Nov 2, 4:52 pm, "greg" <g...@.nospam.com> wrote:
> Hello,
> I am new to SRS. So this is a new-be question.
> When creating a new report in visual studio. When creating a new dataset.
> Do you always need to create a query string to retrieve the fields that can
> be used on the form?
> Is there some SQL picker query builder. Where you can build a query by
> picking and choosing from all tables?
> To help people out?
> thanks
In the Report Wizard, there is a Generic Query Builder; however, I'm
not sure if that will meet your needs completely. Also, there is a
technology called Linq that is being used in Visual Studio 2008 that
allows this type of functionality; however, I'm not sure if it will be
available in SSRS/Reporting Services 2008. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Generic report and dataset

Hello,
I am new to SRS. So this is a new-be question.
When creating a new report in visual studio. When creating a new dataset.
Do you always need to create a query string to retrieve the fields that can
be used on the form?
Is there some SQL picker query builder. Where you can build a query by
picking and choosing from all tables?
To help people out?
thanksOn Nov 2, 4:52 pm, "greg" <g...@.nospam.com> wrote:
> Hello,
> I am new to SRS. So this is a new-be question.
> When creating a new report in visual studio. When creating a new dataset.
> Do you always need to create a query string to retrieve the fields that can
> be used on the form?
> Is there some SQL picker query builder. Where you can build a query by
> picking and choosing from all tables?
> To help people out?
> thanks
In the Report Wizard, there is a Generic Query Builder; however, I'm
not sure if that will meet your needs completely. Also, there is a
technology called Linq that is being used in Visual Studio 2008 that
allows this type of functionality; however, I'm not sure if it will be
available in SSRS/Reporting Services 2008. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Generic Query Designer Disabled

Hi,

This is really a Visual Studio 2005 Report Designer problem but I didn't see a good place to post this question in the Visual Studion forum.

On some reports when looking at the Data tab the Generic Query Designer is disabled. Anybody know why? The report runs. Other reports have it enabled.

I am using Visual Studio 2005 sp1.

Thanks,

Darren

Just answered my own question.

It seems the Generic Query Designer is disabled when you are using an expression for a connection string.

generating user instances in sql server is disabled. use sp_configure user instances enabl

When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances."

I am currently using SQL server 2005 Express.

What do I need to do, to create an SQL database? Thanks in advance.

Execute this statement:

sp_configure'user instances enabled', 1;RECONFIGURE

You can execute it either from Management Studio for SQL Express (http://msdn.microsoft.com/vstudio/express/sql/download/) or from Visual Stuido (create new connection to SQL Express instance then New Query, then execute it!).

Good luck.

|||

Thanks for the advice. Being so new to this, a lot of that went over my head. So I have two questions...

1. How do I create a new connection the SQL Express instance?

2. How do I execute a query after creating it? (With F5?)

Thanks for your help CS4Ever

|||

Select theData | Add New Data Source menu command. This launches theData Source Configuration Wizard.

In theData Source Configuration Wizard, in theChoose a Data Source type step, selectDatabase and then clickNext,then complete the wizard.

Checkout this link:http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/DataBinder.htm

Good luck.

|||Ok I got it to work. Thanks!

Generated query

Hello,

i would like to know where can i see queries which are generated by the cube broswer in visual studio 2005 and where can i see what are the actions it does? Because it takes a very long moment between changes in the browser.

thanks

Start a trace on Analysis Services using the Profiler (assuming that you are using Analysis Services 2005). Then you will be able to see the MDX queries generated by the cube browser.|||thanks a lot

generate table scripts

Hi

I'm developing a website using SQL Server Express 2005 and VIsual Web Developer Express, and now want to start testing my website in a live environment. Until now I have been manually creating tables on my web database to match those on my local DB, but I have so many tables I don't want to manually recreate them all again. Is there a method in SQL Server Express 2005 that will allow me to generate insert scripts for all the tables?

Cheers

Andy

This should help

http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx

|||

Download the SQL Server Database Publishing Wizard:

http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

Jos

|||

Blimey! That was quick. Thanks for the prompt responses, guys!