Putting Report Services inside DotNetNuke 3.1+

Hi All,
we are building a portal that will include RS inside DNN3.1+. I see we
can just include the address in the IFRAM control but we then need
something to control parameters etc...we read the article below to find
this out...
What we are looking for is to have good control over things like
parameter selection and placement of paramters on the page...we have
cascading dependent prompts and we want the related prompts on the same
line etc...we are told we cannot do this in just the standard web
interface....
So we are looking around for people who have done DNN 3.1+ and RS..
We also posted to DNN forums and have had one hopeful answer so
far..but we thought we would ask around!!
Thanks in Advance
Peter Nolan
http://msdn.microsoft.com/sql/default.aspx?pull=/msdnmag/issues/04/08/sqlserverreportingservices/default.aspxHave you looked at the modules at www.snowcovered.com ? I also found this
one..
http://dnndev.icpconline.com/DotNetNuke/Default.aspx?tabid=54
"Peter Nolan" wrote:
> Hi All,
> we are building a portal that will include RS inside DNN3.1+. I see we
> can just include the address in the IFRAM control but we then need
> something to control parameters etc...we read the article below to find
> this out...
> What we are looking for is to have good control over things like
> parameter selection and placement of paramters on the page...we have
> cascading dependent prompts and we want the related prompts on the same
> line etc...we are told we cannot do this in just the standard web
> interface....
> So we are looking around for people who have done DNN 3.1+ and RS..
> We also posted to DNN forums and have had one hopeful answer so
> far..but we thought we would ask around!!
> Thanks in Advance
> Peter Nolan
> http://msdn.microsoft.com/sql/default.aspx?pull=/msdnmag/issues/04/08/sqlserverreportingservices/default.aspx
>|||Hi Shoeman,
I searched snowcovered for 'report services' but didn't find
anything....should I?
Also, thanks for the pointer to the other site...I've registered and
I'll download it asap...looks like it might be something like what I
am looking for....
Though I am told that it is possible to integrate better charts from
Dundas even in the 2000 release....and it does not look like this site
does that yet....but we are learning... :-)
Thanks again
Peter
www.peternolan.com|||Hi,
look at the WebHarpoon module:
http://www.nukesmith.com/
Walter Haas
Peter Nolan wrote:
> Hi All,
> we are building a portal that will include RS inside DNN3.1+. I see we
> can just include the address in the IFRAM control but we then need
> something to control parameters etc...we read the article below to find
> this out...
> What we are looking for is to have good control over things like
> parameter selection and placement of paramters on the page...we have
> cascading dependent prompts and we want the related prompts on the same
> line etc...we are told we cannot do this in just the standard web
> interface....
> So we are looking around for people who have done DNN 3.1+ and RS..
> We also posted to DNN forums and have had one hopeful answer so
> far..but we thought we would ask around!!
> Thanks in Advance
> Peter Nolan
> http://msdn.microsoft.com/sql/default.aspx?pull=/msdnmag/issues/04/08/sqlserverreportingservices/default.aspx|||Hi Walter,
thanks for the pointer to webharpoon...I did see it earlier but I am
not sure how it might help me so much with report services....from my
reading of the functionality it will help me get content from report
services but it looks like it will just pull back RS reports rather
like an iframe.....of course, being a newbie in this area I might be
misunderstanding....
Is it able to do more with RS than just bring back the report content
similar to an iframe?
Thanks
Peter

Publication contains references to foreign keys outside the publication.

At the moment I have a publication with some tables(not all tables in the
db). But the tables inside the publications contains references to foreign
keys to tables outside of the publication. How do I create new subscription
disregarding the Foreign keys constraint to tables outside of the
publication in the same database? How do I simply create the new
subscription disregarding the Foreign Keys references? What's the best way
to switch off foreign keys while creating the subscription and then turn it
back on after subscription created?
Joe,
in the table article properties, there is an option to "Include Declared
Referential Integrity". By default this is off. If it is selected, then
there will be another script created when the initial snapshot is created
during initialization. This script will contain the foreign keys only if all
the related tables are in the same publication. So either way, the FKs
shouldn't be created in your case. If you want to add foreign keys
afterwards you have a few options, eg you could add a postscript, or you
could use sp_addscriptexec.
Regards,
Paul Ibison