Showing posts with label implements. Show all posts
Showing posts with label implements. Show all posts

Sunday, March 11, 2012

Custom Query Designer

Hi,
I'm having some trouble with implementing my own Query Designer.
I have built a control that implements the IQueryDesigner Interface
and register it in the RSReportDesigner.config file.
However Visual Studio never calls it. When I click on the Generic Query
Designer Button to switch between the Generic Designer an my Custom Designer,
The Designer window simply Reads
"The Query could not be loaded."
"Verify your connection string and query string."
I have tried attaching the debugger and I can break on the other Data
Extension classes I have implemented. So it appears that Studio is erring
before it gets to loading my Control. Everything else works fine if I run it
through the generic query designer.
I have also tried uninstalling and reinstalling Reporting Services thinking
the Designer may be broken, but this hasn't helped.
Unless someone has a better Idea, I'm going to resort to reinstalling visual
studio.
Any Ideas?
Thanks
Adrian B.Testing the Query Designer Code on another machine has not helped. So
re-installing Visual Studio will pointless.
I am currently at a loss for where to go with this.
Does anyone have any ideas at all?
Adrian B.

Saturday, February 25, 2012

Custom Data Ext. Query Editor trouble

I created a custom data extension for reporting services in C#.
The CDE implements a dataset with one datatable now but I can't get it to
display in the query editor in the data tab of the report designer.
Any ideas on what needs to be done to expose it and additional data tables
to the query editor for some easy point and click query building?
thanksHave you added to required entries into the RSReportDesigner.config and
RSReportServer.config?
"paul" wrote:
> I created a custom data extension for reporting services in C#.
> The CDE implements a dataset with one datatable now but I can't get it to
> display in the query editor in the data tab of the report designer.
> Any ideas on what needs to be done to expose it and additional data tables
> to the query editor for some easy point and click query building?
> thanks|||Thanks for the reply.
I did add the necessary entries to the rsreportdesigner.config file.
For viewing the report in VS2005 though, both in the data and preview panes,
I'm not sure why I'd need to add any entries to the rsreportserver.config
file?
"SvdSinner" wrote:
> Have you added to required entries into the RSReportDesigner.config and
> RSReportServer.config?
> "paul" wrote:
> > I created a custom data extension for reporting services in C#.
> >
> > The CDE implements a dataset with one datatable now but I can't get it to
> > display in the query editor in the data tab of the report designer.
> >
> > Any ideas on what needs to be done to expose it and additional data tables
> > to the query editor for some easy point and click query building?
> >
> > thanks