|
|
You're in the
sql server reporting services
group:Creating RDL files at runtime
sql server reporting services:
the SQLServer Report Manager and it shows the report. that is perfect. Now what i did is, I opened the CustomerReport.rdl in Notedpad. Obviously it shows me the XML format of the report design. I copied all XML content of the report (Ctrl+A/paste) and copied into a new notepad window and saved the new file as test.rdl. Now when I open the test.rdl report from Report Manager, I see that Iam asked to enter the SQLServer authentication (sa/password). Only after I do the SQLServer authentication, Iam able to view the report in the Report Manager. Why does it ask me so. The thing is Iam playing with the rdl because I need to create reports on the fly (at runtime) in my project requirement. Please share your experiences if you've done something simialar. thanks,
Hi,
You can test it live on internet and change the parameter ProductFamily=Food in ProductFamily=Food. Here you will find 4 ways to start a MS Reporting Services Report as enduser: http://128.171.208.112/ReportServer?%2fFoodmart+Sales&ProductFamily=Food http://128.171.208.112/ReportServer?%2fFoodmart+Sales&rs%3aFormat=HTML4.0&ProductFamily=Food&rc%3aToolbar=True&rc%3aJavaScript=True&rc%3aLinkTarget=_top&rc%3aArea=Toolbar http://128.171.208.112/ReportServer?%2fFoodmart+Sales&ProductFamily=Food&rs%3aFormat=HTML4.0&rc%3aToolbar=True&rc%3aJavaScript=True&rc%3aLinkTarget=_top&rc%3aArea=Report Any other parameter can be used in an action from MS As 2000. For more info: www.reportportal.com / www.gmsbv.nl Regards, Marco www.gmsbv.nl - your partner for MS Analyses & Reporting Services in Europe ! [quoted text, click to view] "Jerome BERTHAUD" <jerome.berthaud@winsight.fr> wrote in message news:<uoKmx5IfEHA.3428@TK2MSFTNGP11.phx.gbl>...
> Hello, > > What kind of datasource are you using ? shared or private to the report ? > In Report Designer or Report Manager, connections to data sources are > managed by ReportDesigner or ReportingServices and credentials are stored > securily in Repository for ReportingServices. Credentials are not part of > RDL and you should not find then in Notepad. If you have a shared Datasource > you can configure it with ReportManager and reference it in your RDL, so you > will not have to authenticate again with Test.rdl > > HTH > > Jerome Berthaud (MCSD) > http://www.winsight.fr > > > "Anand Sagar" <anandsagar@gmail.com> wrote in message > news:3f76a771.0408070018.29eb85ae@posting.google.com... > > I created a CustomerReport.rdl from VS.NET. I previewed the report in > > the SQLServer Report Manager and it shows the report. that is perfect. > > > > Now what i did is, I opened the CustomerReport.rdl in Notedpad. > > Obviously it shows me the XML format of the report design. I copied > > all XML content of the report (Ctrl+A/paste) and copied into a new > > notepad window and saved the new file as test.rdl. > > > > > > Now when I open the test.rdl report from Report Manager, I see that > > Iam asked to enter the SQLServer authentication (sa/password). Only > > after I do the SQLServer authentication, Iam able to view the report > > in the Report Manager. Why does it ask me so. > > > > > > The thing is Iam playing with the rdl because I need to create reports > > on the fly (at runtime) in my project requirement. Please share your > > experiences if you've done something simialar. > > > > thanks,
One additional comment to Jerome's posting: If you use the managed SQL
provider ("SQL") in the data source, you can use IntegratedSecurity for testing purposes (and therefore no need for credentials): <ConnectionProperties> <DataProvider>SQL</DataProvider> <IntegratedSecurity>true</IntegratedSecurity> <ConnectString>data source=(local); .... </ConnectString> </ConnectionProperties> -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Jerome BERTHAUD" <jerome.berthaud@winsight.fr> wrote in message news:uoKmx5IfEHA.3428@TK2MSFTNGP11.phx.gbl... > Hello, > > What kind of datasource are you using ? shared or private to the report ? > In Report Designer or Report Manager, connections to data sources are > managed by ReportDesigner or ReportingServices and credentials are stored > securily in Repository for ReportingServices. Credentials are not part of > RDL and you should not find then in Notepad. If you have a shared Datasource > you can configure it with ReportManager and reference it in your RDL, so you > will not have to authenticate again with Test.rdl > > HTH > > Jerome Berthaud (MCSD) > http://www.winsight.fr > > > "Anand Sagar" <anandsagar@gmail.com> wrote in message > news:3f76a771.0408070018.29eb85ae@posting.google.com... > > I created a CustomerReport.rdl from VS.NET. I previewed the report in > > the SQLServer Report Manager and it shows the report. that is perfect. > > > > Now what i did is, I opened the CustomerReport.rdl in Notedpad. > > Obviously it shows me the XML format of the report design. I copied > > all XML content of the report (Ctrl+A/paste) and copied into a new > > notepad window and saved the new file as test.rdl. > > > > > > Now when I open the test.rdl report from Report Manager, I see that > > Iam asked to enter the SQLServer authentication (sa/password). Only > > after I do the SQLServer authentication, Iam able to view the report > > in the Report Manager. Why does it ask me so. > > > > > > The thing is Iam playing with the rdl because I need to create reports > > on the fly (at runtime) in my project requirement. Please share your > > experiences if you've done something simialar. > > > > thanks, > > Anand Sagar > >
Hello,
What kind of datasource are you using ? shared or private to the report ? In Report Designer or Report Manager, connections to data sources are managed by ReportDesigner or ReportingServices and credentials are stored securily in Repository for ReportingServices. Credentials are not part of RDL and you should not find then in Notepad. If you have a shared Datasource you can configure it with ReportManager and reference it in your RDL, so you will not have to authenticate again with Test.rdl HTH Jerome Berthaud (MCSD) http://www.winsight.fr [quoted text, click to view] "Anand Sagar" <anandsagar@gmail.com> wrote in message news:3f76a771.0408070018.29eb85ae@posting.google.com... > I created a CustomerReport.rdl from VS.NET. I previewed the report in > the SQLServer Report Manager and it shows the report. that is perfect. > > Now what i did is, I opened the CustomerReport.rdl in Notedpad. > Obviously it shows me the XML format of the report design. I copied > all XML content of the report (Ctrl+A/paste) and copied into a new > notepad window and saved the new file as test.rdl. > > > Now when I open the test.rdl report from Report Manager, I see that > Iam asked to enter the SQLServer authentication (sa/password). Only > after I do the SQLServer authentication, Iam able to view the report > in the Report Manager. Why does it ask me so. > > > The thing is Iam playing with the rdl because I need to create reports > on the fly (at runtime) in my project requirement. Please share your > experiences if you've done something simialar. > > thanks, > Anand Sagar
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |