Sql Report protection: display

Showing posts with label display. Show all posts

Wednesday, March 28, 2012

Report with Multiple DB Tables

Dear All,
I want to get the data from two tables (no relationship exist) and want to display the data in a single report.
From one table i just want to show one record but from the other table i want to show multiple records.
Is it possible ? If yes please suggest me how ?Do you mean thet in first table you have only one record, and in the second multiple records?

Report Viewer web part in Sharepoint 2.0 site

Hello:
I'm running the SSRS 2005 web parts in a Sharepoint 2.0 site. I want
to display a report when a page loads using just the page viewer web
part.
In the properties of the web part, I have http://portal:81/Reports/Pages/Report.aspx?
in the Report Manager URL field and itempath=%2fRepVendorPortal%2fTop
+Sellers in the Report Path field.
When I hit apply, the web part displays "A required argument is
missing from the URL that opens this page: ItemPath".
What am I doing wrong here?
Any assistance is appreciated.
Thanks in advance.
-JoeNever mind. I had the report server URL incorrect (it should have
been just http://portal:81/reports) and the report path should have
just been /repvendorportal/Top Sellers. The + was causing a problem
too.
Thanks.
-Joe
On Nov 8, 1:14 pm, Joe <j...@.josephmarkovich.com> wrote:
> Hello:
> I'm running the SSRS 2005 web parts in a Sharepoint 2.0 site. I want
> to display a report when a page loads using just the page viewer web
> part.
> In the properties of the web part, I havehttp://portal:81/Reports/Pages/Report.aspx?
> in the Report Manager URL field and itempath=%2fRepVendorPortal%2fTop
> +Sellers in the Report Path field.
> When I hit apply, the web part displays "A required argument is
> missing from the URL that opens this page: ItemPath".
> What am I doing wrong here?
> Any assistance is appreciated.
> Thanks in advance.
> -Joe

Monday, March 26, 2012

Report Viewer Question

I am using rs on a SQL 2000 DB and have an application built using VWDE 2005
to display reports. I installed the ReportViewer control and set the
appropriate URL and report path. When I open the page, I first get a popup
to enter the password (is there a way to avoid this?) and then I get what
looks like a report manager window on the screen. I have to navigate to my
reports, select the one I want and then click on the "Full Screen" icon to
see the report.
How can I get a page to simply present the report when opened?
WayneIs the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going to
use the new controls to display reports you need to have RS 2005 installed
(which can use a SQL Server 2000 DB, that is what I am doing).
If you want it hardcode during design then using the for Report Path (click
on the upper right of the control to fill in the report tasks) put in
something like this: /MyFolder/MyReport not sure if case sensitive but it
could be. For your server this is what I have: http://Myserver/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>I am using rs on a SQL 2000 DB and have an application built using VWDE
>2005 to display reports. I installed the ReportViewer control and set the
>appropriate URL and report path. When I open the page, I first get a popup
>to enter the password (is there a way to avoid this?) and then I get what
>looks like a report manager window on the screen. I have to navigate to my
>reports, select the one I want and then click on the "Full Screen" icon to
>see the report.
> How can I get a page to simply present the report when opened?
> Wayne
>|||The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I don't
own the server.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going to
> use the new controls to display reports you need to have RS 2005 installed
> (which can use a SQL Server 2000 DB, that is what I am doing).
> If you want it hardcode during design then using the for Report Path
> (click on the upper right of the control to fill in the report tasks) put
> in something like this: /MyFolder/MyReport not sure if case sensitive
> but it could be. For your server this is what I have:
> http://Myserver/ReportServer
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set the
>>appropriate URL and report path. When I open the page, I first get a popup
>>to enter the password (is there a way to avoid this?) and then I get what
>>looks like a report manager window on the screen. I have to navigate to my
>>reports, select the one I want and then click on the "Full Screen" icon to
>>see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>|||I am pretty sure that the server needs to be RS2005. Looking at the info on
the controls it specifies RS 2005 for the server report. If you service
upgrades to RS 2005, they can continue to host RS 2000 reports. RS 2005 is
supposed to be backward compatible.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:OGU9aOd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
> The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I don't
> own the server.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going
>> to use the new controls to display reports you need to have RS 2005
>> installed (which can use a SQL Server 2000 DB, that is what I am doing).
>> If you want it hardcode during design then using the for Report Path
>> (click on the upper right of the control to fill in the report tasks) put
>> in something like this: /MyFolder/MyReport not sure if case sensitive
>> but it could be. For your server this is what I have:
>> http://Myserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set the
>>appropriate URL and report path. When I open the page, I first get a
>>popup to enter the password (is there a way to avoid this?) and then I
>>get what looks like a report manager window on the screen. I have to
>>navigate to my reports, select the one I want and then click on the "Full
>>Screen" icon to see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>>
>|||Thanks for the information - I'll check with my service provider.
Wayne
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23GcxKud%23FHA.160@.TK2MSFTNGP12.phx.gbl...
>I am pretty sure that the server needs to be RS2005. Looking at the info on
>the controls it specifies RS 2005 for the server report. If you service
>upgrades to RS 2005, they can continue to host RS 2000 reports. RS 2005 is
>supposed to be backward compatible.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:OGU9aOd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
>> The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I
>> don't own the server.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going
>> to use the new controls to display reports you need to have RS 2005
>> installed (which can use a SQL Server 2000 DB, that is what I am doing).
>> If you want it hardcode during design then using the for Report Path
>> (click on the upper right of the control to fill in the report tasks)
>> put in something like this: /MyFolder/MyReport not sure if case
>> sensitive but it could be. For your server this is what I have:
>> http://Myserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set
>>the appropriate URL and report path. When I open the page, I first get a
>>popup to enter the password (is there a way to avoid this?) and then I
>>get what looks like a report manager window on the screen. I have to
>>navigate to my reports, select the one I want and then click on the
>>"Full Screen" icon to see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>>
>>
>

Report Viewer Problem In ASP.NET 2.0

Hi i have a problem using Report Viewer With SQL Reporting Services 2005.

The problem is report toolbar is display but NO DATA is displayed and the report commes out as EMPTY :(. Even the parameters are passed successfully because i can see them in the text-boxes on the report parameters tool bar. But Report is Empty :(.

I have the following code.

ReportViewer1.ServerReport.ReportServerUrl = new Uri(@."http://localhost/ReportServer"); ;

string reportPath = @."/MMM_MSRS/WebFormEvents";

ReportViewer1.ServerReport.ReportPath = reportPath

string cmp_id = "3803";

string vcli_id = "23649";

string cnct_id = "1";

Microsoft.Reporting.WebForms.ReportParameter[] Param = new Microsoft.Reporting.WebForms.ReportParameter[3];

Param[0] = new Microsoft.Reporting.WebForms.ReportParameter("cmp_id", cmp_id);

Param[1] = new Microsoft.Reporting.WebForms.ReportParameter("vcli_id", vcli_id);

Param[2] = new Microsoft.Reporting.WebForms.ReportParameter("cnct_id", cnct_id);

ReportViewer1.ServerReport.SetParameters(Param);

ReportViewer1.ServerReport.Refresh();

ReportViewer1.DataBind();

i think there might be problem in u r recordset.

you check u r resultset under the data tab of report designer. just pass the same parameters what you are passing in the report designer of the data tab(not on preview). check whether you are getting the results.

Report Viewer on Internet Site

Hi, I am developing a website that will use the VS Report Viewer control to display some business reports.....The website will be on the internet, but the report viewer will need to access an internal report server that the internet users don't have access to? Is this possible, or the correct way to do this? Any ideas / suggestions would be appreciated!

Cheers
Chris

If you use anonymous access then the user who is accessing the report from the internet does not have to authenticate any type of username to the server.

However, you probably don't want just ANYONE to see your reports, so you may want to develop a secure front-end with Visual Studio to authenticate the user in that fashion. Sort of like a portal on a website. If you go this route, be sure to use a stored procedure and possibly encryption for your password I/O.

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

I am trying to display Microsoft Reporting Service Reports from windows application.

I have application window with Report viewer control.

I have assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports

Error is "

"The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed with HTTP status 404: Not Found.

Please help me..Do I need to set any credential for my reportviewer control? then how?

this.reportViewer1.ServerReport.DisplayName = "SampleReport";

this.reportViewer1.ServerReport.ReportPath = "/SampleReportFolder/SampleReport";

this.reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://laptop/reportserver", System.UriKind.Absolute);

thanks in advance.

KamalKamal,

What version of Report Server are you connecting to? The ReportViewer control is not compatible with SQL Server 2000 Reporting Services. You need the April CTP of Report Server. Your code looks OK otherwise.

Rajeev|||

I do have the same problem. My installation is:

- VS.NET 2003
- Sql Server 2000 Dev
- Reporting Services for Sql Server 2000 + SP1
- VS.NET 2005 Beta 2
- Sql Server 2005 CTP April 2005

I would like to use VS.NET 2005 Beta 2 under "Go live license" but need the Sql Server 2000 Reporting Services as my customer will not upgrade a existing Sql Server 2000 installation.

Is it possible to use this combination?

Thanks,
Dirk

|||

Please make sure your setting in your webconfig

[Thanks to Akilal_MSFT]

- fix the ReportService.asmx error with replacing the <assemblies> section in the <system.web> section of the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config file:

Make sure the web.config files for reportserver and reportmanager have full access:
Change the following line in both web.config files:
<trust level="Full" originUrl="" />
Location: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
and: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

|||

Hai,
I create a window application and i wish to use the report viewer to view the reports that published to the server. Here is my code in VB.NEt

ReportViewer1.ServerReport.DisplayName = "SampleReport"

ReportViewer1.ServerReport.ReportPath = "/SampleReport/Report1"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/reportserver")

Is there any problem to my code? why the report viewer didnt show anything and no error occured when i run the application?

the real path to show the report using report manager is as below:
http://localhost/ReportServer/Pages/ReportViewer.aspx?/SampleReport/Report1&rs:Command=Render
Am i need to change the reportpath same as above?

Another question is : Can i print the reports using my application? means i press a button print in my application and then the report can be print without using the report viewer.

Kindly wait for your reply.
Please email to me too if possible : elainelikim@.gmail.com

|||Did you find the solution to the above problem? I am having a similar issue. I add a reportviewer control in my webapp. I am using the ServerReprot and did specify report path etc. When I view the form, I can see the parameter page for the report fine but when I click on View report button, it basically does not do anything.
Thanks|||

Your issue is because it is SQL 2k RS you are hitting.

I have the same issue and have not found the resolution yet.

Except I have read things suggesting the VS05 ReportViewer does not work with SQL 2000 RS. I suppose it seems right to me; I have resorted to a Web Browser control in WinForms as a temp fix to the issue.

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

I am trying to display Microsoft Reporting Service Reports from windows application.

I have application window with Report viewer control.

I have assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports

Error is "

"The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed with HTTP status 404: Not Found.

Please help me..Do I need to set any credential for my reportviewer control? then how?

this.reportViewer1.ServerReport.DisplayName = "SampleReport";

this.reportViewer1.ServerReport.ReportPath = "/SampleReportFolder/SampleReport";

this.reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://laptop/reportserver", System.UriKind.Absolute);

thanks in advance.

KamalKamal,

Rajeev
|||

I do have the same problem. My installation is:

- VS.NET 2003
- Sql Server 2000 Dev
- Reporting Services for Sql Server 2000 + SP1
- VS.NET 2005 Beta 2
- Sql Server 2005 CTP April 2005

I would like to use VS.NET 2005 Beta 2 under "Go live license" but need the Sql Server 2000 Reporting Services as my customer will not upgrade a existing Sql Server 2000 installation.

Is it possible to use this combination?

Thanks,
Dirk

|||

Please make sure your setting in your webconfig

[Thanks to Akilal_MSFT]

|||

Hai,
I create a window application and i wish to use the report viewer to view the reports that published to the server. Here is my code in VB.NEt

ReportViewer1.ServerReport.DisplayName = "SampleReport"

ReportViewer1.ServerReport.ReportPath = "/SampleReport/Report1"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/reportserver")

Is there any problem to my code? why the report viewer didnt show anything and no error occured when i run the application?

Another question is : Can i print the reports using my application? means i press a button print in my application and then the report can be print without using the report viewer.

Kindly wait for your reply.
Please email to me too if possible : elainelikim@.gmail.com

Your issue is because it is SQL 2k RS you are hitting.

I have the same issue and have not found the resolution yet.

Report Viewer Image Control

Hi all,

I can't figure out how to display a dynamic image using the Image control. I've a database table that holds image information, including an address to the image on the server. ex:\\ServerName\x$\ImageDir\Header.jpg

I've tried to set the Source to External and the Value to Fields!vcPictureLocation.Value (field for the address above) in the Properties panel, but the images appear as broken symbols. Does anyone know how to accomplish this?

As always any help is greatly appreciated. Thanks!

msnyder,

The way i have done it..

Drag the image control to your report.. when the wizard pops up.

Select database as the option ,, Specify ur fields in the database and the mime type associated with in... and

Once that is done.. select the image and set its source to external and then it should work...

while ur saving the link to the database make sure its set as http://servername/Applicationname/anyfolders/filename

hope it helps

Regards

KAren

|||

KAren, thx for the reply. I was able to get the image working locally using your method. However, when I deploy the report onto the server the images are still not displaying. I viewed the source of the report viewer and it says IMG src="http://pics.10026.com/?src=" for all of the images.

As a test, I dragged an image object onto the report, set it equal to a web source, put in the same URL as what's being pulled from the database. Worked fine locally when I previewed the report, but it would not display once deployed.

I followed your steps exactly and also changed the link thats being stored in the database to your format. Any ideas? Thanks a lot!

|||

ok.. where are ur images located?

|||

Very sorry for the delay...

I actually made a new directory called 'Pictures" located in my website project directory. I am storing the images there. The URL I'm storing in the database looks like this...

http://SERVER/safetyforms/Pictures/0d8a3ee0-ee01-48d4-baba-b408a573e1b3.jpg

The image displays in the report viewer when I click the preview tab, but won't display when I publish it. Shows IMG src="http://pics.10026.com/?src=" in the cource code.

|||

are u reports stored in a report server or are they local reports

|||

they are on a report server.

i actually found the solution. there were 2 important details, the first was the steps you outlined about how to set up the image in the report viewer. that solved problem #1. problem #2 was that anonymous access needed to be enabled. the option to enable it was in iis in the project properties.

thanks for the help!

|||

I have the same problem!

but i do not solve the problem!

can you detail the solution to me?

|||

Nanim,

FollowKarenros instructions for setting up the image in the report viewer. Make sure the pictures are being stored in a subdirectory of your main project (ex. root/Pictures) Then, go into IIS and set the permissions for the Pictures folder to anoymous. The option should be in the project properties.

The one mistake I made was setting the entire project to anoymous. We just want the pictures directory to be anoymous.

Friday, March 23, 2012

Report Viewer display problem

Hi,
I use reportviewer.dll in my aspx page, and everything works fine on my
development pc where sqlserver, reporting service and visual studio
installed. But when i try to access this page from another pc, iframe which
holds reportviewer gives me "The page cannot be displayed. The page you are
looking for is currently unavailable.....". Other stuff like ascx,
menus,gif are working well. Any suggestions?
Thanks.Ever find a solution to this?
"saglamtimur" wrote:
> Hi,
> I use reportviewer.dll in my aspx page, and everything works fine on my
> development pc where sqlserver, reporting service and visual studio
> installed. But when i try to access this page from another pc, iframe which
> holds reportviewer gives me "The page cannot be displayed. The page you are
> looking for is currently unavailable.....". Other stuff like ascx,
> menus,gif are working well. Any suggestions?
> Thanks.
>
>

report viewer control wont display report !

Hi friends
am trying to display reports from my report server in report view controls. following is my code in a button click

reportviewer1.ServerReport.ReportServerUrl = {http://localhost/reportserver};
reportviewer1.ServerReport.ReportPath = "\customer Details"
reportviewer1.RefreshReport();

its not giving my any error not displays any report!!
but if i set same info in design mode to report viewer control it works nicely!
whats missing here ?
Thanks for your help.finally figured out .following is what needs to be done

reportviewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportviewer1.ServerReport.ReportServerUrl = new System.Uri(@."http://localhost/reportserver");
reportviewer1.ServerReport.ReportPath = "\customer Details"
reportviewer1.RefreshReport();

Report Viewer Control to display reports

I have reports designed and deployed at the report server running Sql 2005
SSRS. I want to display those report in a vb.net Windows application using a
report viewer control and I have searched the internet for the past 2 weeks
and I still can not find anything or samples on how to do this. I wonder if
it is doable. Thanks.Paul,
You should find the report viewer reference at
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms(vs.80).aspx .
However, if you want just to show a predefined report for the end users,
Visual Studio offers the basic settings for the control, such as Report
server and report name. It is not a big magic :)
I got this sample, hope it will help for you.
http://www.devx.com/dotnet/Article/30424
Regards,
Janos
"Paul" <paul_mak@.shaw.ca> wrote in message
news:O2CwgFviHHA.5052@.TK2MSFTNGP05.phx.gbl...
>I have reports designed and deployed at the report server running Sql 2005
>SSRS. I want to display those report in a vb.net Windows application using
>a report viewer control and I have searched the internet for the past 2
>weeks and I still can not find anything or samples on how to do this. I
>wonder if it is doable. Thanks.
>|||Some great samples at http://www.gotreportviewer.com
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Paul" <paul_mak@.shaw.ca> wrote in message
news:O2CwgFviHHA.5052@.TK2MSFTNGP05.phx.gbl...
>I have reports designed and deployed at the report server running Sql 2005
>SSRS. I want to display those report in a vb.net Windows application using
>a report viewer control and I have searched the internet for the past 2
>weeks and I still can not find anything or samples on how to do this. I
>wonder if it is doable. Thanks.
>

Report Viewer Cannot Connect to Report Server VWD

Using VWD I am trying to use the report viewer to display a report that i have on my sql 2005 report server.

I AM Able get to the report server page by going to the site's ipaddress\reports

the report i want to display is in a folder

so when adding the report to the reportviewer control in VWD i put

ipaddress\reports for the server url

then I put foldername\reportname for the report path

the report never shows up in design mode and when i try to view the page in a browser

I keep getting

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

The request failed with HTTP status 404: Not Found.

Well for one you have your slash backwards.

It should behttp://myserver/reportserver

Not '\'

|||How I wish my problem was that simple, but i just mistyped it here. I really do have the correct / in my data.|||

Just an idea, but try using the hostname of the server instead of the IP address. If you can type in a browser,

http://myserver/ReportServer

and get a response, your control will work.

|||I don't have a host name set up for this site, hence why i am using the ip.

Have you used report server with VWD and report viewer?

Any other ideas...|||If you typehttp://ipaddress/reportserver into a web browser, do you get anything?|||

yes first it prompts me for user name and password right now i enter the local server username and password

after i do that i get the folders on the site like below do i need to pass the username and password to the report server some how?

Thanks for your help!

 Thursday, September 28, 2006 11:10 AM <dir>Data Sources Thursday, September 28, 2006 11:10 AM <dir>Models Tuesday, October 03, 2006 7:37 AM <dir>Report Project1 Thursday, September 28, 2006 8:19 AM <dir>SMCReports

Microsoft SQL Server Reporting Services Version 9.00.2047.00

|||

So the url you're using is:

http://192.168.0.238:81/reportserver?%2fSMCReports%2fReportName

Right?

|||This may or may not help:http://www.dezel.com/articles/ReportingServicesRendering.html|||

I got it it was a combination of things for one i was not using a / in the report path
i just had smcreports/reportname instead of /smcreports/reportname.
I also did not have the proper permissions set up in report manager

I changed them according to this post

thanks for the help!!!

http://groups.google.com/group/microsoft.public.crm/browse_thread/thread/3b65374f40d44b12/a556ebab49a7b562?lnk=st&q=The+permissions+granted+to+user+%27NT+AUTHORITY%5CNETWORK+SERVICE%27+are+insufficient+for+performing+this+operation.+(rsAccessDenied)+&rnum=2&hl=en#a556ebab49a7b562

NOTE: At this point you should be able to use Internet Explorer and browse
the reports and reportserver virtual folders. Test this by going to
http://SBSserverName/reports andhttp://SBSserverName/reportserver. You
should be able to do this without receiving an error. If you receive an
error please stop here and send us the error you get.

4. Publish reports by opening a command prompt and going to:
c:\program files\microsoft crm\reports
Then run the following: publishreports.exe "company name"
"Domain\ReportingGroup {GUID}"

5. Give reports correct permissions
a. From the default website where SRS is installed browse the
reports directory (http://SBSserverName/reports)
b. Click Properties then click Your_Org_Name_mscrm folder
c. click the Security tab
d. The following groups should be added:

BUILTIN\Administrators with a role ofContent Manager
DOMAINNAME\ReportingGroup
{ec70ac7b-a091-4d00-b038-75fd6ea0e84c} with a role of Browser for Microsoft
CRM
NT AUTHORITY\NETWORK SERVICE with a role of Publisher for
Microsoft CRM

NOTE: If any of the above groups are missing you will need to
add them.

6. You may also have to do the steps on page 15-6 in the Microsoft CRM 3.0
Implementation Guide
http://www.microsoft.com/downloads/details.aspx?FamilyID=1FF067F8-4F7...
AE9C-68ADA7D4F16A&displaylang=en

Tuesday, March 20, 2012

Report table does not display all rows from dataset

I have a dataset that when run returns 270 rows. The table using the dataset in the report only prints the first row. I have the table grouped by a status type, but this is for when I can get multi-select paramenters installed and working. For now I just need the report to print all the returned rows. Help!!

Thanks!

Terry

Try to remove the grouping and see if you get the 270 rows in your report.

Jarret

Monday, February 20, 2012

Report rendering in webform

Hi,
Currently I display report in my webform (website) using
Reportviewer.ReportURL method which fetch report from Report Manger through
Http:// port. which takes too much to rendering report.
Is there any method through which I can render report in my webpage through
reprot API or something like that so that it doesn't fetch report through
http port and rendering time should be fast.
Thanks in Advance.Kam,
I am curious as to how you determined that using HTTP-GET causes the slow
performance? Did you look at how long it takes for the database query to be
processed, report to be generated and rendered?
Requesting your reports via HTTP-GET is the fastest way to generate them.
Think of the Report Server (not Report Manager) as a web application. Your
request/response total latency consists of submitting the report request to
the Report Server, querying the database, generating the report, rendering
the report, sending the report payload to the Report Viewer (browser), and
displaying the report in the browser. From this latencies, you should focus
on minimizing the time it takes to query the database and generate the
report.
Here is a tip: use the RS Execution Log to find out how much the Report
Server spends querying, generating and rendering your report.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> Hi,
> Currently I display report in my webform (website) using
> Reportviewer.ReportURL method which fetch report from Report Manger
through
> Http:// port. which takes too much to rendering report.
> Is there any method through which I can render report in my webpage
through
> reprot API or something like that so that it doesn't fetch report through
> http port and rendering time should be fast.
> Thanks in Advance.|||How to check R S Exectuion Log ?
"Teo Lachev" wrote:
> Kam,
> I am curious as to how you determined that using HTTP-GET causes the slow
> performance? Did you look at how long it takes for the database query to be
> processed, report to be generated and rendered?
> Requesting your reports via HTTP-GET is the fastest way to generate them.
> Think of the Report Server (not Report Manager) as a web application. Your
> request/response total latency consists of submitting the report request to
> the Report Server, querying the database, generating the report, rendering
> the report, sending the report payload to the Report Viewer (browser), and
> displaying the report in the browser. From this latencies, you should focus
> on minimizing the time it takes to query the database and generate the
> report.
> Here is a tip: use the RS Execution Log to find out how much the Report
> Server spends querying, generating and rendering your report.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Kam" <Kam@.discussions.microsoft.com> wrote in message
> news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> > Hi,
> > Currently I display report in my webform (website) using
> > Reportviewer.ReportURL method which fetch report from Report Manger
> through
> > Http:// port. which takes too much to rendering report.
> > Is there any method through which I can render report in my webpage
> through
> > reprot API or something like that so that it doesn't fetch report through
> > http port and rendering time should be fast.
> >
> > Thanks in Advance.
>
>|||Here is a code to render a report in a stream sent to an aspnet page.
//Create a Reporting Service Object (you have to add a reference to it in
VS.NET)
localhost.ReportingService s = new localhost.ReportingService ();
//specify the credentials
s.Credentials = new System.Net.NetworkCredential("myuser",
"mypassword","");
try
{
// Render arguments
byte[] result = null;
string reportPath = "/Test/Rlinktest";
string format = "HTML4.0";
string historyID = null;
string devInfo = "";
string showHideToggle = null;
string encoding;
string mimeType;
localhost.Warning[] warnings = null;
localhost.ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
localhost.SessionHeader sh = new localhost.SessionHeader();
s.SessionHeaderValue = sh;
//call the render method of webservice
result = s.Render(reportPath, format, historyID, devInfo, null, null,
showHideToggle, out encoding, out mimeType, out
reportHistoryParameters, out warnings,
out streamIDs);
Response.ClearContent();
Response.ContentType="text/html";
Response.BinaryWrite(result);
Response.Flush();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
Cédric
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> Hi,
> Currently I display report in my webform (website) using
> Reportviewer.ReportURL method which fetch report from Report Manger
> through
> Http:// port. which takes too much to rendering report.
> Is there any method through which I can render report in my webpage
> through
> reprot API or something like that so that it doesn't fetch report through
> http port and rendering time should be fast.
> Thanks in Advance.|||Kam,
The RS Execution Log is stored in the ExecutionLog table in the RS
ReportServer database. For analyzing its data easier, you need to install
the Execution Log DTS package. Check the Rs documentation for the following
topics:
- Report Server Execution Log
- Querying and Reporting on Report Execution Log Data
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:6BF3E420-9468-43C5-8E48-925B6C806D69@.microsoft.com...
> How to check R S Exectuion Log ?
> "Teo Lachev" wrote:
> > Kam,
> >
> > I am curious as to how you determined that using HTTP-GET causes the
slow
> > performance? Did you look at how long it takes for the database query to
be
> > processed, report to be generated and rendered?
> >
> > Requesting your reports via HTTP-GET is the fastest way to generate
them.
> > Think of the Report Server (not Report Manager) as a web application.
Your
> > request/response total latency consists of submitting the report request
to
> > the Report Server, querying the database, generating the report,
rendering
> > the report, sending the report payload to the Report Viewer (browser),
and
> > displaying the report in the browser. From this latencies, you should
focus
> > on minimizing the time it takes to query the database and generate the
> > report.
> >
> > Here is a tip: use the RS Execution Log to find out how much the Report
> > Server spends querying, generating and rendering your report.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > http://www.prologika.com
> >
> >
> > "Kam" <Kam@.discussions.microsoft.com> wrote in message
> > news:1D7BD329-07EA-45BD-B365-C76390685461@.microsoft.com...
> > > Hi,
> > > Currently I display report in my webform (website) using
> > > Reportviewer.ReportURL method which fetch report from Report Manger
> > through
> > > Http:// port. which takes too much to rendering report.
> > > Is there any method through which I can render report in my webpage
> > through
> > > reprot API or something like that so that it doesn't fetch report
through
> > > http port and rendering time should be fast.
> > >
> > > Thanks in Advance.
> >
> >
> >

Report Rendering (II)

Hi,

I have been using the following code, (thanks to Shyam), to display address fields. This works great when using preview in BIDS, but the address shows on one continious line when the report is redered in Reporting Services.

=First(Fields!Name.Value) & IIf(First(Fields!Address1.Value) <> "", Chr(10) & Chr(13) & First(Fields!Address1.Value), "") &
IIf(First(Fields!Address2.Value) <> "", Chr(10) & Chr(13) & First(Fields!Address2.Value), "") &
IIf(First(Fields!Address3.Value) <> "", Chr(10) & Chr(13) & First(Fields!Address3.Value), "") &
IIf(First(Fields!Town.Value) <> "", Chr(10) & Chr(13) & First(Fields!Town.Value), "") &
IIf(First(Fields!County.Value) <> "", Chr(10) & Chr(13) & First(Fields!County.Value), "") &
IIf(First(Fields!Post_Code.Value) <> "", Chr(10) & Chr(13) & First(Fields!Post_Code.Value),

Any one any ideas?

Thanks

Did you try vbCRLF instead of chr(10) & 13?

http://blogs.infinite-x.net/category/dynamics-crm/reporting/

cheers,

Andrew

Report Record Count in Header Section

Do anyone know how to do a count on the number of records in a data set and
display the information in the header section of the report? I can easily
perform this operation in the data section using the Count() method against
the data set, but RS does not allow datasets/fields to be referenced in the
header section. By required design, this record count textbox is above a
page count textbox (which must also be in the header since it's a global
variable), so I can't cheat by moving the field to the data section - it must
live in the header. Any help would be appreciated.
The only alternatives that I can think of are:
-Somehow reference a textbox that is using the Count() method in the data
section, and display the same text in the header section. (I have no idea
how I would do this.)
-Determine the record count and page count in SQL to move both fields to the
data section. I didn't want to do this because if the report layout changes,
the page count might not be correct.You can achieve this by using scope. Get the count of records for the table
level as follows:
In the header section add an expression as follows:
=Count(<field>, "<table name>")
Regards,
SaraS|||Unfortunately, you can't use Count() or CountRows() in headers or footers.
"saras" wrote:
> You can achieve this by using scope. Get the count of records for the table
> level as follows:
> In the header section add an expression as follows:
> =Count(<field>, "<table name>")
> Regards,
> SaraS
>|||Have you tried to use Report!Items.whatever.Value?
These fields are used in headers and footers. If you manage to get this data
in data section you can copy it to header section by
Report!Items.fieldname.Value.
"Bryan" wrote:
> Do anyone know how to do a count on the number of records in a data set and
> display the information in the header section of the report? I can easily
> perform this operation in the data section using the Count() method against
> the data set, but RS does not allow datasets/fields to be referenced in the
> header section. By required design, this record count textbox is above a
> page count textbox (which must also be in the header since it's a global
> variable), so I can't cheat by moving the field to the data section - it must
> live in the header. Any help would be appreciated.
> The only alternatives that I can think of are:
> -Somehow reference a textbox that is using the Count() method in the data
> section, and display the same text in the header section. (I have no idea
> how I would do this.)
> -Determine the record count and page count in SQL to move both fields to the
> data section. I didn't want to do this because if the report layout changes,
> the page count might not be correct.
>

Wednesday, March 28, 2012

Report with Multiple DB Tables

Report Viewer web part in Sharepoint 2.0 site

Monday, March 26, 2012

Report Viewer Question

Report Viewer Problem In ASP.NET 2.0

Report Viewer on Internet Site

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

Report Viewer Image Control

Friday, March 23, 2012

Report Viewer display problem

report viewer control wont display report !

Report Viewer Control to display reports

Report Viewer Cannot Connect to Report Server VWD

Tuesday, March 20, 2012

Report table does not display all rows from dataset

Monday, February 20, 2012

Report rendering in webform

Report Rendering (II)

Report Record Count in Header Section

Sql Report protection

Blog Archive

About Me