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

Generating and directing new rows in PostExecute.

I want to construct a dataset based on all rows passed in from a source and, upon running through all of them, push each dataset record to an output.

Unfortunately, upon calling the AddRow method, I get an "object reference not set to an instance of an object" error. Am I not allowed to create new rows in PostExecute?

Bill,

Can you post your code, indicate which line the error occurs on, and tell us how you have configured the outputs of the component.

-Jamie

|||It errors on reference to a row buffer.

With dsMaterialBuffer
.AddRow()
'Code for row values
End With

I've added the following to check if it's actually defined within PostExecute;
If dsMaterialBuffer Is Nothing Then MsgBox("dsMaterialBuffer is nothing.") 'My row buffer

dsMaterialBuffer, which is the row buffer I'm using, evaluates to "Nothing" and that is where my object reference errors are coming from.

Is it possible that the row buffers are being thrown out once PostExecute hits?

The outputs, by the way, are non-synchronous with standard columns.|||

What is the name of the output as defined in the inputs and outputs tab of the script component editor?

-Jamie

|||dsMaterial|||

Hmm, strange. if you want, drop me an email via here: http://blogs.conchango.com/jamiethomson/contact.aspx and I'll reply so you can send me the package. I can take a look and see if anything jumps out.

If you can build the package so that I am able to run it as well (i.e. not reliant on external data sources, just use a script source component instead) then that'd help.

-Jamie

Generating and directing new rows in PostExecute.

I want to construct a dataset based on all rows passed in from a source and, upon running through all of them, push each dataset record to an output.

Unfortunately, upon calling the AddRow method, I get an "object reference not set to an instance of an object" error. Am I not allowed to create new rows in PostExecute?

Bill,

Can you post your code, indicate which line the error occurs on, and tell us how you have configured the outputs of the component.

-Jamie

|||It errors on reference to a row buffer.

With dsMaterialBuffer
.AddRow()
'Code for row values
End With

I've added the following to check if it's actually defined within PostExecute;
If dsMaterialBuffer Is Nothing Then MsgBox("dsMaterialBuffer is nothing.") 'My row buffer

dsMaterialBuffer, which is the row buffer I'm using, evaluates to "Nothing" and that is where my object reference errors are coming from.

Is it possible that the row buffers are being thrown out once PostExecute hits?

The outputs, by the way, are non-synchronous with standard columns.|||

What is the name of the output as defined in the inputs and outputs tab of the script component editor?

-Jamie

|||dsMaterial|||

Hmm, strange. if you want, drop me an email via here: http://blogs.conchango.com/jamiethomson/contact.aspx and I'll reply so you can send me the package. I can take a look and see if anything jumps out.

If you can build the package so that I am able to run it as well (i.e. not reliant on external data sources, just use a script source component instead) then that'd help.

-Jamie