|
|
You're in the
sql server reporting services
group:how users access reports?
sql server reporting services:
p[robably it helps you
http://www.rdlcomponents.com/download/ASPdemo.aspx Jerry [quoted text, click to view] "zitus" wrote:
> > I want to give access to my reports inside my asp.net application. ( a small > portal application ) > > As users logon to portal, I will give credentials myself inside asp.net > application for reports. > > I do not want users to access to ( http://server/reportserver ) > > If I restrict IP ACCESS to site ( http://server/reportserver ), I can not > use the REPORTSERVER.DLL > [microsoft sql server\mssql\reporting > services\samples\applications\reportviewer\vb\bin\reportviewer.dll] > > I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp > (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not show > multiple pages report.. > > Any idea? > > BR > Ziya > >
That demo contains full source code that solve his request, and you dont have
to buy anything from that website to accomplish this task: "I want to give access to my reports inside my asp.net application. ( a small portal application ) As users logon to portal, I will give credentials myself inside asp.net application for reports I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not show multiple pages report .." Thanks JErry [quoted text, click to view] "Frank Matthiesen" wrote:
> Jerry wrote: > > p[robably it helps you > > > > http://www.rdlcomponents.com/download/ASPdemo.aspx > > > > Jerry, > > it would be better if you provide other users with really help and not with > commercial-links to your software. > Stop this spam please. > > regards > > Frank > -- > www.xax.de > >
This is spam "www.xax.de"
Is no place in your entire website that helps his request. Regards, Jerry [quoted text, click to view] "Jerry" wrote:
> That demo contains full source code that solve his request, and you dont have > to buy anything from that website to accomplish this task: > > "I want to give access to my reports inside my asp.net application. ( a small > portal application ) > As users logon to portal, I will give credentials myself inside asp.net > application for reports > I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp > (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not show > multiple pages report > ." > > Thanks > JErry > > "Frank Matthiesen" wrote: > > > Jerry wrote: > > > p[robably it helps you > > > > > > http://www.rdlcomponents.com/download/ASPdemo.aspx > > > > > > > Jerry, > > > > it would be better if you provide other users with really help and not with > > commercial-links to your software. > > Stop this spam please. > > > > regards > > > > Frank > > -- > > www.xax.de > > > >
I want to give access to my reports inside my asp.net application. ( a small portal application ) As users logon to portal, I will give credentials myself inside asp.net application for reports. I do not want users to access to ( http://server/reportserver ) If I restrict IP ACCESS to site ( http://server/reportserver ), I can not use the REPORTSERVER.DLL [microsoft sql server\mssql\reporting services\samples\applications\reportviewer\vb\bin\reportviewer.dll] I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not show multiple pages report.. Any idea? BR Ziya
[quoted text, click to view]
Jerry, it would be better if you provide other users with really help and not with commercial-links to your software. Stop this spam please. regards Frank -- www.xax.de
I have no problem creating the RDL document
[quoted text, click to view] "Jerry" <Jerry@discussions.microsoft.com> wrote in message news:9E9F77AB-F938-4607-991E-7ECAC966DB87@microsoft.com... > p[robably it helps you > > http://www.rdlcomponents.com/download/ASPdemo.aspx > > Jerry > > "zitus" wrote: > >> >> I want to give access to my reports inside my asp.net application. ( a >> small >> portal application ) >> >> As users logon to portal, I will give credentials myself inside asp.net >> application for reports. >> >> I do not want users to access to ( http://server/reportserver ) >> >> If I restrict IP ACCESS to site ( http://server/reportserver ), I can >> not >> use the REPORTSERVER.DLL >> [microsoft sql server\mssql\reporting >> services\samples\applications\reportviewer\vb\bin\reportviewer.dll] >> >> I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp >> (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not show >> multiple pages report.. >> >> Any idea? >> >> BR >> Ziya >> >> >>
I do not have problem creating RDL file
[quoted text, click to view] "Jerry" <Jerry@discussions.microsoft.com> wrote in message news:9E9F77AB-F938-4607-991E-7ECAC966DB87@microsoft.com... > p[robably it helps you > > http://www.rdlcomponents.com/download/ASPdemo.aspx > > Jerry > > "zitus" wrote: > >> >> I want to give access to my reports inside my asp.net application. ( a >> small >> portal application ) >> >> As users logon to portal, I will give credentials myself inside asp.net >> application for reports. >> >> I do not want users to access to ( http://server/reportserver ) >> >> If I restrict IP ACCESS to site ( http://server/reportserver ), I can >> not >> use the REPORTSERVER.DLL >> [microsoft sql server\mssql\reporting >> services\samples\applications\reportviewer\vb\bin\reportviewer.dll] >> >> I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp >> (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not show >> multiple pages report.. >> >> Any idea? >> >> BR >> Ziya >> >> >>
I do not have problem creating RDL file
[quoted text, click to view] "Jerry" <Jerry@discussions.microsoft.com> wrote in message news:9E9F77AB-F938-4607-991E-7ECAC966DB87@microsoft.com... > p[robably it helps you > > http://www.rdlcomponents.com/download/ASPdemo.aspx > > Jerry > > "zitus" wrote: > >> >> I want to give access to my reports inside my asp.net application. ( a >> small >> portal application ) >> >> As users logon to portal, I will give credentials myself inside asp.net >> application for reports. >> >> I do not want users to access to ( http://server/reportserver ) >> >> If I restrict IP ACCESS to site ( http://server/reportserver ), I can >> not >> use the REPORTSERVER.DLL >> [microsoft sql server\mssql\reporting >> services\samples\applications\reportviewer\vb\bin\reportviewer.dll] >> >> I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp >> (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not show >> multiple pages report.. >> >> Any idea? >> >> BR >> Ziya >> >> >>
OK, boys and girls, enough now.
Spam is annoying, so Frank I understand where you're coming from, but rdlcomponents is a valuable site with free source code, so cut Jerry some slack. Maybe more direction to the code would have been helpful, but the onus is on the person asking for help to do the donkey work, as we are not actually paid to help! [quoted text, click to view] Frank Matthiesen wrote:
> Jerry wrote: > > That demo contains full source code that solve his request, and you > > dont have to buy anything from that website to accomplish this task: > > OK..and why don't you provide us with the needed code-snippets? > If you won't or got no time for that it might be better than post > something like: > Download my software....look in source at the following line/place. > That would be mor helpfull! > > best regards > > Frank
[1.- Report Acces and Portal]
If you run the demo with out download it, you can noticed all the reports are been accessed by the ASP demo (portal), for example: http://www.rdlcomponents.com/ASPExamples/ReportPreview.aspx?name=OUWPIHHNMQCSFKICUTQEJVCCFPIXIU And not using http://server/reportserver The full source code of ReportPreview.aspx is there. [2.- Credentials] Inside the source codeof the file WebServices.cs, we have a class that wraps the RS WS and use applications credentials, very important when you have to restrict and control the access to the reports: public class RSWebServices : ReportingService { public RSWebServices() { this.Url = ConfigurationSettings.AppSettings["RSUrl"]; this.Credentials = new NetworkCredential( ConfigurationSettings.AppSettings["RSUser"], ConfigurationSettings.AppSettings["RSPassword"]); } } [3.- Multiple pages report] This demo only display one report per page. At this point you dont have to buy nothing. Everybody happy now? Thanks Jerry [quoted text, click to view] "zitus" wrote:
> Sorry but this does not solve my problem. > I do not have problem in creating a RDL file > "Jerry" <Jerry@discussions.microsoft.com> wrote in message > news:9E9F77AB-F938-4607-991E-7ECAC966DB87@microsoft.com... > > p[robably it helps you > > > > http://www.rdlcomponents.com/download/ASPdemo.aspx > > > > Jerry > > > > "zitus" wrote: > > > > > > > > I want to give access to my reports inside my asp.net application. ( a > small > > > portal application ) > > > > > > As users logon to portal, I will give credentials myself inside asp.net > > > application for reports. > > > > > > I do not want users to access to ( http://server/reportserver ) > > > > > > If I restrict IP ACCESS to site ( http://server/reportserver ), I can > not > > > use the REPORTSERVER.DLL > > > [microsoft sql server\mssql\reporting > > > services\samples\applications\reportviewer\vb\bin\reportviewer.dll] > > > > > > I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp > > > (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not > show > > > multiple pages report.. > > > > > > Any idea? > > > > > > BR > > > Ziya > > > > > > > > > > >
[quoted text, click to view]
Jerry wrote: > This is spam "www.xax.de" > > Is no place in your entire website that helps his request. Hmm....right! But it's separated from the posting by "-- " You could disable the footer if you are using a good newsreader. regards Frank
[quoted text, click to view]
Jerry wrote: > That demo contains full source code that solve his request, and you > dont have to buy anything from that website to accomplish this task: OK..and why don't you provide us with the needed code-snippets? If you won't or got no time for that it might be better than post something like: Download my software....look in source at the following line/place. That would be mor helpfull! best regards Frank
Sorry but this does not solve my problem.
I do not have problem in creating a RDL file [quoted text, click to view] "Jerry" <Jerry@discussions.microsoft.com> wrote in message news:9E9F77AB-F938-4607-991E-7ECAC966DB87@microsoft.com... > p[robably it helps you > > http://www.rdlcomponents.com/download/ASPdemo.aspx > > Jerry > > "zitus" wrote: > > > > > I want to give access to my reports inside my asp.net application. ( a small > > portal application ) > > > > As users logon to portal, I will give credentials myself inside asp.net > > application for reports. > > > > I do not want users to access to ( http://server/reportserver ) > > > > If I restrict IP ACCESS to site ( http://server/reportserver ), I can not > > use the REPORTSERVER.DLL > > [microsoft sql server\mssql\reporting > > services\samples\applications\reportviewer\vb\bin\reportviewer.dll] > > > > I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp > > (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not show > > multiple pages report.. > > > > Any idea? > > > > BR > > Ziya > > > > > >
[quoted text, click to view]
Jerry wrote: > > [3.- Multiple pages report] > This demo only display one report per page. > > At this point you dont have to buy nothing. > > Everybody happy now? ....little bit I thought that there is no way to create multiple-page / drillthrough-reports via SOAP-API? If you know a way to do that, i would be pleasure if you could share your knowledge. regards frank
You report's access in your portal and credentials problems, were addresed in
the last Jerry's post (aboved this lines). Its nothing about the RDL document. [quoted text, click to view] "zitus" wrote:
> I have no problem creating the RDL document > > "Jerry" <Jerry@discussions.microsoft.com> wrote in message > news:9E9F77AB-F938-4607-991E-7ECAC966DB87@microsoft.com... > > p[robably it helps you > > > > http://www.rdlcomponents.com/download/ASPdemo.aspx > > > > Jerry > > > > "zitus" wrote: > > > >> > >> I want to give access to my reports inside my asp.net application. ( a > >> small > >> portal application ) > >> > >> As users logon to portal, I will give credentials myself inside asp.net > >> application for reports. > >> > >> I do not want users to access to ( http://server/reportserver ) > >> > >> If I restrict IP ACCESS to site ( http://server/reportserver ), I can > >> not > >> use the REPORTSERVER.DLL > >> [microsoft sql server\mssql\reporting > >> services\samples\applications\reportviewer\vb\bin\reportviewer.dll] > >> > >> I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp > >> (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not show > >> multiple pages report.. > >> > >> Any idea? > >> > >> BR > >> Ziya > >> > >> > >> > >
Hello,
It seems that you have to modify the code from the following link so that it may support pages http://www.codeproject.com/useritems/SQLRSViewer.asp You may want to handle temReport string so that it can show 1 page information instead of all pages. Thanks & Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA Microsoft Online Partner 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. -------------------- | From: "zitus" <e> | References: <OLgC#4hLFHA.4084@TK2MSFTNGP10.phx.gbl> <9E9F77AB-F938-4607-991E-7ECAC966DB87@microsoft.com> | Subject: Re: how users access reports? | Date: Mon, 21 Mar 2005 19:37:26 +0200 | Lines: 41 | X-Priority: 3 | X-MSMail-Priority: Normal | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 | X-RFC2646: Format=Flowed; Original | Message-ID: <OZzl5F#LFHA.3512@TK2MSFTNGP15.phx.gbl> | Newsgroups: microsoft.public.sqlserver.reportingsvcs | NNTP-Posting-Host: dsl81-214-22475.adsl.ttnet.net.tr 81.214.87.203 | Path: TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl | Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.reportingsvcs:46045 | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs | | I do not have problem creating RDL file | [quoted text, click to view] | "Jerry" <Jerry@discussions.microsoft.com> wrote in message | > p[robably it helps you| news:9E9F77AB-F938-4607-991E-7ECAC966DB87@microsoft.com... | > | > http://www.rdlcomponents.com/download/ASPdemo.aspx | > | > Jerry | > [quoted text, click to view] | > "zitus" wrote: | >| >> | >> I want to give access to my reports inside my asp.net application. ( a | >> small | >> portal application ) | >> | >> As users logon to portal, I will give credentials myself inside asp.net | >> application for reports. | >> | >> I do not want users to access to ( http://server/reportserver ) | >> | >> If I restrict IP ACCESS to site ( http://server/reportserver ), I can | >> not | >> use the REPORTSERVER.DLL | >> [microsoft sql server\mssql\reporting | >> services\samples\applications\reportviewer\vb\bin\reportviewer.dll] | >> | >> I tried to use http://www.codeproject.com/useritems/SQLRSViewer.asp | >> (SQL Reporting Services Viewer Page Using SOAP API) ; but it can not show | >> multiple pages report.. | >> | >> Any idea? | >> | >> BR | >> Ziya | >> | >> | >> | | |
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 |