GP Fault When Using SSRS Print Icon RSClientPrint

Apr 8, 2008

I am getting a general protection fault when pressing the print icon in Reporting Services website.

Hi I found this article:


http://database.ittoolbox.com/groups/technical-functional/sql-server-l/reporting-services-2005-print-icon-causes-machine-to-reboot-1592477

but I can't figure ou how to "remove" the RSClientPrint Class add-on in IE 6.

P.S.
Why does something as simple as printing need to be an ActiveX control? There are all kinds of issues revolving around pushing this out using SMS for users without local admin permission.

View 4 Replies


ADVERTISEMENT

Print SSRS Report?

Mar 27, 2008

is there any way to schedule to print reports every morning from ssrs?

View 1 Replies View Related

Print Headers Issues In SSRS 2005

Jul 19, 2007

I have a report, with 220 records, each row heigth varies. I have set the option to repeat header on every page on. However, when I print the report, the header prints on some pages, and some it does not. For eg, on the 5 page reprot, it prints the header on pg 1, 2 and 3. Then on pg 4 it does not, then again page 5 it prints the header.

Any advise.

View 1 Replies View Related

Reporting Services :: Print All Record In SSRS

Sep 13, 2015

We have a SSRS with SP 2010, We need to add one more Print All button which print all the records.

Without impacting the by default Print button which print record page by page

View 3 Replies View Related

Reporting Services :: IE 11 And SSRS Print Button

Mar 19, 2014

1. We have been using Sql Server 2008 R2 and its reporting services engine.

In the application we used Report Viewer (version 9).

When the report is taken for the first time, couple of messages pops up.

a. Unable to Load print control
b. Install Sql Server Reporting Services 2008 R2.

These messages are fine, but we noticed that the second message is not consistent. When the application is deployed in staging server which is as same as the production server except for the power (CPU, RAM), the second message is "Install Sql Server 2008". Why is this happening?

2. To support IE 11, we upgraded the Report viewer to version 11. Now the messages are different.

a. Printing is not available. Verify that ActiveX is enabled or try using IE from the desktop
b. Install Sql Server Reporting Services 2008 R2. (Here again when deployed in staging server it says "Install Sql Server 2008").

View 6 Replies View Related

How To Print External Documents With SSRS Report.

Jul 15, 2007

Hello,

We have a requirement that on some reports, like details on a specific inventory item, we need to print with the report and external attachment like a word document, and auto cad drawing, or a picture.

Some of the ideas we are thinking of are:

adding the links to the external documents in a report parameter and then, when the report is about to be printed, get the values and send the documents to the print queue just after we send the report to the print queue.
Creating a custom control on the report to somehow stream the file to the print queue when the report is printed.
Render the report to a pdf and programmatically send the pdf and other attachments to the report queue.

Does anyone have any thoughts on this or, even better, some code that meets the requirements.

Thank you,

Paul



View 2 Replies View Related

Reporting Services :: Print On Continuous Paper On SSRS

Aug 21, 2015

Paper is 21cm x 9cmPrinter is Epson LX-300..When I set this paper size, SSRS turns orientation to landscape and prints as if clockwise right rotated!I tried creating custom paper on print server options without success. I also tried setting the same paper size in Report Builder and Print Server but failed again.

View 3 Replies View Related

Reporting Services :: SSRS 2008 - Print Preview In IE 11

Nov 16, 2015

I'm using SQL Server 2008 SP3 with Reporting Services 2008 SP3.

By opening my web application in IE9 and running report, i can print and show then print preview by clicking the "Print preview" button in printing dialog.

By opening my web application in IE11 and running report, i can print the report but if I click on the print preview on the print dialog nothing appears... Why?

View 3 Replies View Related

Reporting Services :: SSRS Print Report On Both Sides On Same Document

Nov 24, 2015

In a new ssrs 2008 report that uses sql server 2012, I am suppose to create a report that prints on both sides of the same paper. The first side of the report will display custom data with a mailing address for the customer.

The second side (back side of the paper) will contain generic information. The second side of the paper will contain areas for the users within my large company to fill out and return to the user via inter-office mail.

Thus my question is can this happen in an SSRS 2008 report to print in a PDF and/or Word document on both sides of the paper? If this is possible would you tell me if the paper needs to be exported to PDF, Word, or if this can on both format(s)? If so, any reference how to accomplish this goal?

If this is not possible in SSRS 2008, is printing on both sides of the paper possible in ssrs 2008 r2 or ssrs 2012?

What version of ssrs report would work, and if the print (export) needs to  be a PDF, Word, or either format? 

View 5 Replies View Related

SSRS(2005) Print Review && Page Number Reset ?s

Sep 17, 2007

Hi,

I'm having 2 issues on my first "real" SSRS report.
1. How to do a print preview via the preview tab. For print rendering, I have no print preview button on the preview toolbar. Is this normal? MS documention said that there is a Print Preview button. (BOL May 2007 - Designing & Creating reports -> working with report designer -> debugging and Publishing reports (Print Preview)) This report will always be rendered via the printer and it is a "pain" to have to always print it to see changes. The print layout option comes up all black with nothing viewable.

2. How do I reset page numbers back to 1 for report groups? I see no option for this. My report group requires a new page and I want page numbering to start at 1 when the grouping changes.

Note: I'm running VS2005 via Vista (with VS2005 Vista fix installed). SQL2005 SP2 also installed.

Any advice on this will be appreciated. I've spent too much time already where this should be obvious.

View 2 Replies View Related

Using The Print Button On SSRS Report Manager Causes Computer To Reboot:

May 4, 2007

This is a really strange problem. There are some reports that work fine when I click the print button provided by the Report Manager but trying to print the report by clicking on print button located by the export causes my computer to reboot. Is there a resolution?



The report can be successfully printed if exported to pdf.



View 3 Replies View Related

Reporting Services :: SSRS Print Layout Support RTL Rendering

Apr 28, 2015

Is there a support of printing report with matrix that is set to RTL (LayoutDirection) which displays in ReportViewr control with property RightToLeft set to RightToLeft.Yes in DisplayMode = PrintLayout.

The report looks fine in the report viewr in DisplayMode = Normal, but when goes to PrintLayout, it seems that the left data on page is rendered first.

Example: This is the display of the report viewer, I would like to print the columns by the same order it displays here:

And this is the result when clicking Print Preview: the first page displays the data of the last columns and if i go to the last page (page 9) i will see the data of the first column as displays in the previous gif, I don't have a clue why?

Is there a property that can be set to force the print layout to render RTL. Anyway, it seem to me as a bug since the Report Viewer displays the data correctly and renders the data RTL as expected.

View 3 Replies View Related

Reporting Services :: Extra Command Button To Print SSRS Report

Aug 8, 2015

I have created  web based  ssrs report with Report viewer  and I am trying to add Command button to print result of report reside in ReportViewer and I have worked with  code to generate. Is there any other way to work around without writing function or java script  on Extra print button to print  ssrs report.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

[code]....

View 4 Replies View Related

Reporting Services :: SSRS - Zoom And Print Control Not Visible In IE11 / Firefox And Chrome

Jan 22, 2015

It seems the features are disabled when using any of the above because of compatibility issues with scripting/ActiveX not being properly supported by the FireFox and Chrome.

I believe the control determines the browser you are using is not IE and will not render the controls to prevent unexpected behavior because if the lack of ActiveX support. This can be seen when you compare the HTML of a page using IE8 and that of either IE11, FF, Chrome you'll see that the HTML for a zoom drop down control will show up in the IE8 browser and not in the others.

As for IE11 it presents itself as a Mozilla browser. eg: "User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko" so when the control see's this it wont generate any of the controls believing the browser can't support it, even though IE11 should certainly be capable of doing so. I wanted to know if this is correct and if this is a bug?

Browser Support for ReportViewer "The ReportViewer Web server control is used to embed report functionality in an ASP.NET Web application. The type of browser used to view the application determines the kind of functionality that you can provide in a report. Use the table provided in this topic to find out which of the supported browsers are subject to report functionality restrictions."

The page mentions that the following wont be supported by other browsers The following features are not supported in third-party browsers:

Document mapSearching within the reportZoomFixed table headersThe progress indicator for report processing (a green spinning wheel) is not available for server reports, or for locally processed reports that are configured for asynchronous processing.

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Visible="true" Height="100%" ShowZoomControl="True" ShowPrintButton="True"
Width="100%" ProcessingMode="Remote" ShowCredentialPrompts="False" ShowParameterPrompts="False"
DocumentMapCollapsed="False" ShowBackButton="True" ShowRefreshButton="False" InteractivityPostBackMode="AlwaysSynchronous"
ShowExportControls="False" BackColor="#c4dcfb" AsyncRendering="false" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt"SplitterBackColor="#C4DCFB" ShowDocumentMapButton="True" DocumentMapWidth="20%">
</rsweb:ReportViewer>

View 5 Replies View Related

RSClientPrint Problem

Mar 27, 2006

I'm trying to get client side printing to work in asp.net with reporting services 2005. I've got an aspx page to do printing as described here but when I try to render a report I get the following:

1. Print dialog box appears as expected

2. Press print

3. Dialog box appears saying "Print in progress"

4. After a few seconds another dialog box appears saying there was an error printing the report. Error code is 80004005.

I get the same error if I try to preview instad of print.

The (relevent) code is:

<object id="RSClientPrint" classid="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3" codebase="Bin/RSClientPrint.cab#Version=2005,90,1399,0"></object>

<script language="javascript" type="text/javascript">
function printIt() {
RSClientPrint.Print('http://localhost/ReportServer$SQL2005',
'/LMI Reports/GoodsIn&OrderID=1000'),
'Goodsin');
}
</script>

<body onload="printIt()">

Does anybody know what this error is and how I can get the control to work? Its not clear to me what the version on the object statement should be. This example uses the version string from the control but I've also tried 1.0 with the same result. Its also not clear if I should be using RSClientPrint.Authenticate or not. I've tried both true and false with the same result.

Many thanks

Ian

View 4 Replies View Related

Problems Using RSClientPrint

Sep 29, 2006



We are using VB.NET 2005 to develop a WinForms application that uses SQL Server 2005 Reporting Services to produce reports.
We want to print a large report programmatically without preview. RSClientPrint looked like a good solution but it produces an error when we try to use it.


Details...
I added Interop.RSClientPrintLib.dll Version 1.0.0.0 to my application and used the code sample I found at:
http://msdn2.microsoft.com/en-us/library/ms159195.aspx

The call to print looks like:
RSClientPrint.Print("http://ourServer/reportserver", strReportPathParameters, "Report_name")

This call generates an error message:
"An error occured during printing. (0x80004002)"

and throws an exception:
"Specified cast is not valid"



Any ideas appreciated.

View 5 Replies View Related

RSClientPrint Download

May 19, 2006

I have an asp.net application which is launched from our B2B site. The primary purpose of the application is to allow our external clients access to reports, along with the ability to export and print. The RS2005 report viewer component was used within the application to render the reports. The problem is when the our client users click on the print button on the report viewer's tool bar, many of them are receiving a window asking them if they want to install "SQL Server". In reality, the ActiveX viewer, RSClientPrint, is what is trying to install. Our technical support staff is being flooded with calls due to this pop up. The users are very confused and concerned about installing "SQL Server." In addition, some users do not have the ability to install the ActiveX viewer, so they are not going to be able to print. We've experienced this in the past with ActiveX for Crystal. Finally, some users receive no message or feedback when they click on the print button for several minutes. We've determined the ActiveX is being installed during this time. We've had users wait as long as 7 minutes for the Print Dialog to come up.

1. We would like to place a message along with the link on the page where the report is rendered. Is there a way for us to provide a link to a self extracting file containing RSClientPrint?

2. Also is there any way to get around the issue where the client user does not have the ability to install the ActiveX? I've seen references on the forum to using SMS, but this is not possible since the users are external?

3. Is there any setting we can turn on so the users don't think the application has gone "out to lunch" while the ActiveX viewer is installed?

Thanks

View 7 Replies View Related

RSClientPrint In FireFox

Jun 26, 2007

Hi,

We are using the RSClientPrint component to print reports from our web application. When we use it from IE all works fine. But on using the FireFox the print method fails. I am using following code to print




Code Snippet

var oRSClientPrint = window.document.getElementById("RSClientPrint");
alert(oRSClientPrint);
if (typeof oRSClientPrint.Print == "undefined")
{
alert("Unable to load client print control.");
return;
}

In FireFox above code fails by raising error message "Unable to load client print control.". As per me FireFox is not able to use the Print method of object, Can you help me on how we can make it to work with FireFox.

Thanks and Regards,
Nav

View 1 Replies View Related

Reporting Services :: SSRS / How To Print A Report Without Bringing Up The Rendered Report

Jun 29, 2015

I'm wondering how to print a SSRS report without bringing up a report viewer. Is there way to print(PDF format) the SSRS report in the web application( .net )  directly from the "print" button without bringing up a report viewer?

View 2 Replies View Related

Problem When I Am Using RSClientPrint Active X

Jun 26, 2006

Hi ,

I m using rsclientscript in my application..i m using the following code in <script>

function Print()
{
RSClientPrint.MarginLeft = 12.7;
RSClientPrint.MarginTop = 12.7;
RSClientPrint.MarginRight = 12.7;
RSClientPrint.MarginBottom = 12.7;
RSClientPrint.Culture = 1033;
RSClientPrint.UICulture = 9;
RSClientPrint.Print('http://localhost/Reports/Pages/Report.aspx?ItemPath', '=%2fTestMonday%2fSrCorpLogo&CorporationId=2', 'Employee_Sales_Summary')
}
</script>

I m calling this script when user clicks the button in the webpage..

I m getting the dialog box properly..In that if i click preview button i m getting the following error

"An error occured trying to render the report. (0x80004005)"

Please help me out ..Very Urgent Issue..

Thanks in Advance..

Bhoopathi..

View 4 Replies View Related

RSClientPrint Parameter Issues

Mar 13, 2007

Hi All
We're having a technical issue integrating the print reports into the portal. I'm hoping maybe some of your guys can help. We're using the RSClientPrint component to print the reports. The problem appears to be a conflict between the & in the URL and the & in the parameter value's cube reference. Below is an HTML code snippet. The 1st button works fine for us, it prints everything and has no & in the parameter's cube references. The second button references specific User and Employee values and therefore has & in the cube reference and generates an error. We tried encoding the & as &amp; but it did not help. Thanks.

<html>
<body>


<OBJECT ID="RSClientPrint" CLASSID="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3"></OBJECT>

<script type="text/javascript">
function Print(ReportServer, ReportParameters, ReportTitle ) {
RSClientPrint.MarginLeft = .5 * 25.4;
RSClientPrint.MarginTop = .5 * 25.4;
RSClientPrint.MarginRight = .5 * 25.4;
RSClientPrint.MarginBottom = .5 * 25.4;
RSClientPrint.Culture = 1033;
RSClientPrint.UICulture = 1033;
RSClientPrint.PageWidth = 11 * 25.4;
RSClientPrint.PageHeight = 8.5 * 25.4;
RSClientPrint.Authenticate = false;
RSClientPrint.Print(ReportServer, ReportParameters, ReportTitle);
}

</script>


<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].[All]&UserUser=[User].[User].[All]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].[All]', 'SA.Report.6');"/>

<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].&[1]&UserUser=[User].[User].&[1]&[1]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].&[3356953]', 'SA.Report.6');"/>

</body>
</html>



Regards,

Nanda kumar R

View 3 Replies View Related

Web Host MS Sql Performance - My Fault?

Feb 14, 2007

Hi,
I'm using SqlServer 2000 at a web host, and share this db with about 200 others (it's an inexpensive web host so I guess there is not very much traffic on most of them, but I can only see their db IDs so I don't know what organisations they are or the urls they have).
Usually, my web site runs fine, but lately it's really really slow (as in non-functioning in reality). I'm in the middle of coding my seach functionality, so I fear that I'm causing this myself. ;-)
However, there are only ten posts in my test db, so it should be a piece of cake for SqlServer. The other .aspx pages runs rather slow too now, but when I start a programming session they have worked fine (this has happened three times now so I don't know what to conclude). When the server slows down, it can stay down for hours. I've also tried to access my site from other computers but get the same result, so I guess it has nothing to do with caching (I also tried emptying my browser's - IE7 - cache). I have several asp web sites with Access dbs at the same web host, and they all work fine. In addition, I have no problem viewing and editing my db at the web host via SqlServer Management Studio Express.
What do you think of this problem? Should I go for a more expensive web host? Should I give them the "It's not you, it's me" speech? ;-) Or is it really me?
Below's my search code, and as you can see, there are some integers there to make sure the loops don't run ad infinitum. I don't really think the problem actually lies with my search code, as everything worked well a week ago, but I don't know...
BTW, if you think my code can run much faster without getting too tricky, please let me know.
Please help!
Pettrer
If Page.IsPostBack Then
Dim soktext As String = Trim(SokTextBox.Text) + " "
Dim tillagg As String = ""
Dim varv As Integer = 1
Dim loopvarv As Integer = 0
soktext = Replace(soktext, vbCrLf, " ") 'vbCrLf = mellanslag i VB-terminologi
Do While InStr(soktext, " ") And varv < 100
soktext = Replace(soktext, " ", " ")
loopvarv += 1
Loop
While Trim(soktext).Length > 0 And varv <= 20 'Loop för att identifiera ord och lägga till dem i sqlsatsen, ett i taget
Dim icke As String = " "

Dim ordet As String = soktext.Substring(0, soktext.IndexOf(" ")) 'Det godkända ordet läggs till i tmp-strängen
soktext = soktext.Remove(0, soktext.IndexOf(" ") + 1) 'Tar bort det som just använts (eller varit för kort)
If ordet.Length > 1 Then 'Blanksteg och ensamma bokstäver förhindras att komma med i sql-satsen
If ordet.StartsWith("-") Then 'Det är ett minusord
icke = " NOT " 'I sqlsatsen blir det alltså AND NOT (...)
ordet = ordet.Remove(0, 1) 'Tar bort minusttecknet från söksträngen
End If
tillagg += " AND " & icke & " (artistnamn LIKE '%" & ordet & "%' OR " & _
"beskrivning LIKE '%" & ordet & "%' OR " & _
"kulturhemvist LIKE '%" & ordet & "%' OR " & _
"kontaktnamn LIKE '%" & ordet & "%') "
End If
varv += 1
End While
Dim kat As String = ""
If KategoriDropDownList.SelectedValue <> 0 Then
kat = " AND (kategori1 = " & KategoriDropDownList.SelectedValue & _
" OR kategori2 = " & KategoriDropDownList.SelectedValue & _
" OR kategori3 = " & KategoriDropDownList.SelectedValue & _
" OR kategori4 = " & KategoriDropDownList.SelectedValue & ") "
End If
Dim lan As String = ""
If LanDropDownList.SelectedValue <> "alla" Then
lan = " AND lan = '" & LanDropDownList.SelectedValue & "' "
End If
ResultatDataSource.SelectCommand = "SELECT DISTINCT TOP 200 folknuID, kategori1, kategori2, kategori3, kategori4, initial, artistnamn, lan, kontakthemsida, kategori1, (COALESCE(audio1,'') + COALESCE(audio2,'') + COALESCE(audio3,'')) As audio, (COALESCE(video1,'') + COALESCE(video2,'') + COALESCE(video3,'')) As video, (COALESCE(pressbild1,'') + COALESCE(pressbild2,'') + COALESCE(pressbild3,'')) As pressbild " & _
"FROM Mytable " & _
"WHERE shown = 1 AND shownadm = 1 " & _
tillagg & _
kat & _
lan & _
"ORDER BY initial"
ResultatLabel.Text = "SelectCmd: " & ResultatDataSource.SelectCommand
ResultatGridView.DataBind()
End If '*** på sökkoden

View 7 Replies View Related

Performance Vs Fault Tolerance

Jul 10, 2001

We are setting up a new SMS (SP3) primary server with local SQL 7.0 (SP3) and are mandated to use the following configuration for hard drives:


C:&D: are on mirrored 18GB drives (2 channel RAID controller)

C: OS (8GB) partition
D: pagefile & temp (10GB)

E:&F: are on RAID 5 (3x36GB) 72GB useable (2 channel RAID controller)

E: temp data for field techs (10GB)
F: SMS & SQL (62GB)

We would like to have the SQL logs on a different physical drive than the data (for improved performance), so we are planning on putting it on drive D:

We realize this will affect redundancy, but should this be a big concern?

Has anyone used this type of configuration?

Pros, cons?

Any help would be appreciated.

Thanks
Brent

View 2 Replies View Related

What Is A Fault Bucket Error?

May 21, 2006

When I open my Computer Management Console and look at Event Viewer/Application, I see an error:

Fault bucket 277816039.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 42 75 63 6b 65 74 3a 20 Bucket:
0008: 32 37 37 38 31 36 30 33 27781603
0010: 39 0d 0a 9..


What is this error and how can I fix it?

Also, When I click on the link to get more information all I get is a page that says there is no information on this error. This happens with ALL my errors! I have never seen any usefull information from this link.

I am running on a Windows 2004 Standard Server with SQL Server 2005.

Charles

View 5 Replies View Related

Rsclientprint Is Locking Up Systems Causing Reboot HELP

May 14, 2007

I am using SQL 2005 with reporting services, I have very basic reports, most users can print fine with the print icon in the toolbar, some users get the Blue screen and have to reboot. They have the rsclientprint.dll loaded in the browser, we have deleted it and reloaded, what do I do ?

View 1 Replies View Related

MMC Caused A General Protection Fault

Mar 23, 2000

I just installed SQL7.0 on a windows 98 machine. When I go to register a new database, I get the following message.
MMC caused a general protection fault

I have rebooted the machine, removed & reinstalled the application.

Help - what else

View 1 Replies View Related

Best Practices For Drive Fault Tolerance

Jun 16, 2008

Hello All,

We have to setup a SQL 2000 box (it's what the app requires) and I would like to know what is considered the best practice for setting up the drive fault tolerance.

We are looking at allocating about 500GB for both system and data drives.

Thank you in advance for your input.

Sincerly,

Larry

View 1 Replies View Related

Fault With Configure The Select Stament

Mar 13, 2007

Goodday all

I,m having a problem with something that worked well just recently. maybe I changed a setting by mistake.

I have a Database grid view on my page. When I configure my data sourse and get to "configure the select statment " on the wizard and press advanced to open the wizard with two check boxes " generate INSERT, UPDATE etc and the other check box "Use optimistic concurrency " this input box of the wizard is greyed out (non responsive)

Does anyone know how to rectify this?

Regards

Rob

View 1 Replies View Related

Recover After A Raid-5 Disc Fault

Jun 17, 2006

Hi,

My raid-5 server failed because one disc, some folders and files are lost, but I have recoverd whit some software for the propuse.

I have reinstaled the SQL server and attached the database, but when I try to open the tables I recieve a error message saying : internal consisty error... somethihg like this.

How can a restore the databases?

View 3 Replies View Related

Blonde To Write Query Or Design Fault

Nov 18, 2005

Dear All,

I’m wondering if it’s the design that needs to be changed or I simply can’t put this together.

I have 3 tables.

1. people (peopId, peopFName, peopSName etc.)
2. codes (codeId, codeName)
3. codedPeople(codePeopleId, peopId, codeId)

Codes represent different skills of people, example the sort of job functions they’ve held in their employment. Like:

t-CEO,
t-CFO
t-Founder
etc.

people, clearly holds data about people.

CodedPeople holds data about which people are coded. So person1 can be coded as t-CEO as well t-Founder, and person2 coded as t-CFO

What I need is a query that returns all distinct people records and takes a number of codeNames as input. So if I throw in t-CEO OR t-Founder I get person1, again if I define t-CEO AND t-Founder I get person1.

However when I add t-CEO OR t-CFO I get person1 and person2 but when the query takes t-CEO AND t-CFO I get no result.

I can’t seem to come up with anything that would give me a good starting point. Is there a design fault here? All opinions are much appreciated, thanks in advance!

View 3 Replies View Related

Print Barcodes With The Active X Print Control

Mar 2, 2007

We are having problems printing Reports (when printing by clicking on the AcitiveX print control), where the font for the fields are set to "C39HrP24DhTt" (barcode).

While viewing the report it displays as Barcodes but while printing, the Barcode does not get printed, but the string gets printed.

Environment: SSRS 2005

Using the ReportViewer Control in a .Net 2.0 Web App to render the reports.

BarCodes print fine in the following situations:

1. When the Report is exported to Excel and when printed from there

2. When you click on the print button on Internet Explorer

3. When saving as html (from view source) and opening that html document and printing.

BarCodes do NOT get printed in the following situation:

1. When printing by clicking on the "Print" (Active X Control) icon. Even the "Print Preview" does not show the Barcode.

View 2 Replies View Related

Report Toolbar Inactive - Suspect RsClientPrint ActiveX Problem

Mar 15, 2007

Hi,

I€™m hoping someone might be able to help me.

I have a Development Machine running Windows XP Professional SP2, with SQL Server 2005 including Reporting Services. I am developing an ASP.NET application using VS 2005, and am including Server Side Reports from SQL Server. Everything is working well, except when viewing the Reports.

The Reports when viewed from Reporting Services€™ Report Manager or from within the ASP.NET application only display the first page of the report, displaying the total number of pages as 0. As well, most of the functions on the report toolbar appear to be disabled. This occurs for any report viewed, even sample reports such as the Adventure Works Samples.

The problem only occurs when viewed from within Internet Explorer on the Development Machine. To overcome the problem, I have upgraded SQLServer to SP2, and removed and reinstalled Internet Explorer, but it made no difference. It appears to be related to the rsClientPrint ActiveX addon which should have been installed when the print icon was first selected. It appears not to have installed properly, but up to that point everything worked OK. Selecting the Print icon (or any other icon) since nothing happens. I€™m guessing here, but I suspect that the rsClientPrint addon needs to be reinstalled, but I don€™t know how to go about it. It is not listed within IE addon (where it is on other machines connecting to the Development Machine), nor is it listed within the €œC:WindowsDownloaded Program Files€?. But it is not being downloaded when the Print Icon is selected. I have checked all the Security settings for the environment to ensure that ActiveX programs are downloaded, and everything appears to be in order.

Would anyone be familiar with this problem or have any suggestions on how to go about resolving it? Any help would be appreciated as it is causing significant problems. Strange though, the reports appear fine when viewed from within the Server Manager.

View 1 Replies View Related

Is There A Notification Icon?

Jul 17, 2006

Is there any way to configure a notification icon in the start tray in Express 2005 (like we had in SQL Server 2000) with a little green (or red) arrow (or dot) to indicate whether the server's up (or down)?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved