Building my own Query Designer

I have created a Custom Data Extention to query SharePoint List data directly
from within Reporting Services. I would like to replace the Generic Query
designer with my own code to make selecting columns or adding selection
critera an easier and more friendly process and can see that Microsoft have
built query designers for SAP etc.. so it would appear possible'
I have been unable to find any documentation on developing Query designers
but I am hoping that someone can help me?
Thanks
JasonHello Jason,
You need to create a Visual Studio 2005 Add-on to add your own Query
designer.
There are some sample projects in the Vistual Studio 2005 SDK.
http://www.microsoft.com/downloads/details.aspx?familyid=51a5c65b-c020-4e08-
8ac0-3eb9c06996f4&displaylang=en
And you may refer this web site:
http://msdn2.microsoft.com/en-us/vstudio/aa700819.aspx
Also, this article may be helpful for you to understand the Visual Studio
Add-in
http://www.codeproject.com/csharp/LineCounterAddin.asp
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hmmm..I didn't know it was a VS2005 Addin... I've built a few addins for
VS2005 before...I'll take a look.. :)
Thanks!!! :)
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> You need to create a Visual Studio 2005 Add-on to add your own Query
> designer.
> There are some sample projects in the Vistual Studio 2005 SDK.
> http://www.microsoft.com/downloads/details.aspx?familyid=51a5c65b-c020-4e08-
> 8ac0-3eb9c06996f4&displaylang=en
> And you may refer this web site:
> http://msdn2.microsoft.com/en-us/vstudio/aa700819.aspx
> Also, this article may be helpful for you to understand the Visual Studio
> Add-in
> http://www.codeproject.com/csharp/LineCounterAddin.asp
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei Lu,
I'm actually at the .Net Roadshow in Boston this week so I have not had a
chance to get into the code.
While I know how to build VS2005 addins, is there a defined interface for
building Query designers? I se how to launch the designer in the
RSReportDesigner.config but I'm wondering if there is any documentation on
the interface I would need to implement just like I had to when building the
Sharepoint Data Extension.
I can see designers like:
Microsoft.ReportingServices.QueryDesigners
Microsoft.ReportingServices.QueryDesigners.Essbase
Microsoft.ReportingServices.QueryDesigners.SapBw
Now I'd like to "implement" my own...Any help on the interface I need to
build to make it work would be gratefully appreciated..
Thanks
Jason
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Jason,
Well, that will be some difficult if you want the Visual Studio load your
custom designer and embedded it into the project.
My suggestion is that you only use the addin to make you could generate the
query to query the datasource and add it to the querytext in the xml.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||If you got this working I would like to test it for you...
"Jason" wrote:
> Wei Lu,
> I'm actually at the .Net Roadshow in Boston this week so I have not had a
> chance to get into the code.
> While I know how to build VS2005 addins, is there a defined interface for
> building Query designers? I se how to launch the designer in the
> RSReportDesigner.config but I'm wondering if there is any documentation on
> the interface I would need to implement just like I had to when building the
> Sharepoint Data Extension.
> I can see designers like:
> Microsoft.ReportingServices.QueryDesigners
> Microsoft.ReportingServices.QueryDesigners.Essbase
> Microsoft.ReportingServices.QueryDesigners.SapBw
> Now I'd like to "implement" my own...Any help on the interface I need to
> build to make it work would be gratefully appreciated..
> Thanks
> Jason
>
> "Wei Lu [MSFT]" wrote:
> > Hi ,
> >
> > How is everything going? Please feel free to let me know if you need any
> > assistance.
> >
> > Sincerely,
> >
> > Wei Lu
> > Microsoft Online Community Support
> >
> > ==================================================> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> >
> > ==================================================> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >

Building a Generic Report Viewer

I am just learning SSRS. I am coming from a Crystal Reports background. In
the app that I am upgrading to SSRS, I had a generic report viewer that I
fed the name of the report. The viewer than opened the report pulled out
the data source and set it and passed through any selection criteria from
the app and then ran the report in the viewer.
Is this possible with SSRS?
Will the report viewer sit in the client side app and I set the processing
mode to remote? I am doing a remote app connecting through a VPN to a SQL
Server 2005 database.
Thanks
BillGWhat you want is the report viewer control (winform or webform) that ships
with VS 2005. There is no viewer control that ships with RS. You have to get
the control via VS 2005 (or VS 2008). It does exactly as you describe.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"BillG" <billgower@.charter.net> wrote in message
news:DC9683FB-6354-44AD-89C9-B1A577541939@.microsoft.com...
>I am just learning SSRS. I am coming from a Crystal Reports background.
>In the app that I am upgrading to SSRS, I had a generic report viewer that
>I fed the name of the report. The viewer than opened the report pulled out
>the data source and set it and passed through any selection criteria from
>the app and then ran the report in the viewer.
> Is this possible with SSRS?
> Will the report viewer sit in the client side app and I set the processing
> mode to remote? I am doing a remote app connecting through a VPN to a SQL
> Server 2005 database.
>
> Thanks
> BillG
>