Re: Database logon error for crystal report... - Web Development Discussion Boards

That's the tricky part. Smile | :)

. It would make sense if you put your database on a file server. From there, the two applications will be able to access the database without security issues.

I have report that is made in pull method...

Now i want to use the same report in push method..

so that i dont have to redesing the report that i already have... \

Is there anyway i can do this..

i am using crystal report XI release 2 version to generate report in VS 2005 using vb.net code.

modified on Tuesday, June 1, 2010 9:07 AM

Now how can anyone answer this? Roll eyes | :rolleyes:

You have not specified what technology you are using, SSRS, Crystal, ActiveReports, etc., nor what the report is, how you are generating it, nothing.

I know the language. I've read a book. - _Madmatt

really soorry for that...

i am using crystal report X1 release 2 and vs 2005.

There are tools available, such as this[^] however you could also do it yourself, depending on requirements. http://aspalliance.com/1917_Automate_delivery_of_Crystal_Reports_With_a_Windows_Service[^]

I know the language. I've read a book. - _Madmatt

Hai friends...
i am using VS2005.My problem s with RDLC report. I can display datas using RDLC reports are working fine. But my need is, when I change the culture to Arabic,All the data should change to Arabic in rdlc report.its working except numbers. I need to display all the numbers in Arabic mode. how can we achieve this?????ur comment plz Smile | :)

I am saving crystal report as pdf in my machine using pull method....

it was working fine till i added refresh() as it was not refreshing the data..

i am gettin error as Database Logon failed and in inner exception i am getting CrystalDecisions.ReportAppServer.DataSetConversion....

Below is my code...pls help

Dim rptExcel As New ReportDocument
rptExcel.Load("MrRpt.rpt")

rptExcel.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile
rptExcel.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat
Dim objOptions11 As DiskFileDestinationOptions = New DiskFileDestinationOptions
objOptions11.DiskFileName = strExportFile
rptExcel.ExportOptions.DestinationOptions = objOptions11
rptExcel.Refresh()

rptExcel.Export()//Here it throws error

rptExcel.Dispose()

I think you are missing following code (for authenticating crystal report for accessing sql server data)
or there is some problem in authentication.

Dim oReport As New CrystalDecisions.CrystalReports.Engine.ReportDocument()
   oReport.Load(reportName)
   DoCRLogin(oReport)

   Public Sub DoCRLogin(ByRef oRpt As CrystalDecisions.CrystalReports.Engine.ReportDocument)
        Dim _applyLogin As New ApplyCRLogin

        ' use ApplyLogin object to apply login info to all tables in CR object
        _applyLogin._dbName = "Northwind"
        _applyLogin._passWord = "CrystalUser"
        _applyLogin._serverName = "(local)"
        _applyLogin._userID = "CrystalUser"
        _applyLogin.ApplyInfo(oRpt)


        ' clean up
        _applyLogin = Nothing
    End Sub

   Public Class ApplyCRLogin
    Public _dbName As String
    Public _serverName As String
    Public _userID As String
    Public _passWord As String
    Public Sub ApplyInfo(ByRef _oRpt As CrystalDecisions.CrystalReports.Engine.ReportDocument)
        Dim oCRDb As CrystalDecisions.CrystalReports.Engine.Database = _oRpt.Database
        Dim oCRTables As CrystalDecisions.CrystalReports.Engine.Tables = oCRDb.Tables
        Dim oCRTable As CrystalDecisions.CrystalReports.Engine.Table
        Dim oCRTableLogonInfo As CrystalDecisions.Shared.TableLogOnInfo
        Dim oCRConnectionInfo As New CrystalDecisions.Shared.ConnectionInfo()
        oCRConnectionInfo.DatabaseName = _dbName
        oCRConnectionInfo.ServerName = _serverName
        oCRConnectionInfo.UserID = _userID
        oCRConnectionInfo.Password = _passWord
        For Each oCRTable In oCRTables
            oCRTableLogonInfo = oCRTable.LogOnInfo
            oCRTableLogonInfo.ConnectionInfo = oCRConnectionInfo
            oCRTable.ApplyLogOnInfo(oCRTableLogonInfo)

        Next
    End Sub

Find following link useful for more help...
http://aspalliance.com/532_Understanding_the_Login_Failed_Error_in_Crystal_Reports.all[^]

http://aspalliance.com/490_Troubleshooting_Database_Login_Errors_using_Crystal_Reports_with_NET.all[^]

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Still i get the same error....

I want to include some dynamic content from another site, but I want to restrict the user from clicking any of the links on that site so they can't navigate away from my page. Most of the things I have tried in terms of capturing mouse events to prevent navigation are ignored when the mouse is over the IFrame.

Thanks in advance.

yes, definitely you can make iframe read only..

//Paste the code inside the entity onload event box  
  
var IFRAME_Test;   
var IFRAME_Test_Disable_Message = "IFRAME Disabled...";  
  
function OnCrmPageLoad() {     
  //Reference the IFRAME  
  IFRAME_Test = document.all.IFRAME_Test;  
  //Bind to its ready state event (wait until the iframe is fully loaded)  
  IFRAME_Test.attachEvent( "onreadystatechange" , OnTestIframeReady );   
}  
  
function OnTestIframeReady() {  
  if( IFRAME_Test.readyState != "complete" )  
      return;  
  //Override the onmousedown event     
  IFRAME_Test.contentWindow.document.onmousedown = OnTestIframeMouseDown;   
}  
  
function OnTestIframeMouseDown() {  
  alert( IFRAME_Test_Disable_Message );  
  /* or use */  
  //the window is put beyond the user's desktop and is immediately closed  
  var stubWin = window.open(‘about:blank’,’’,’  toolbars=0,width=100,height=100,top=10000,left=10000’);  
  stubWin.close();  
  return false;   
}  
  
//Entry point   
OnCrmPageLoad();

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Thanks, I've seen variants of that code segment on the web and they just seem to be ignored.
I think I am not putting the start code in the right place and it is not being executed. I have also tried putting the OnCrmPageLoad() function call in the onload event for the iframe. Alot of these examples refer to Microsoft CRM and I don't think I am using that. I am just trying to do this with HTML and Javascript.

Here is what I have now.

<HTML>
<HEAD>


<script language="javascript" type="text/javascript">
//Paste the code inside the entity onload event box 

var IFRAME_Test; 
var IFRAME_Test_Disable_Message = "IFRAME Disabled..."; 

function OnCrmPageLoad() { 
//Reference the IFRAME 
IFRAME_Test = document.all.IFRAME_Test; 
//Bind to its ready state event (wait until the iframe is fully loaded) 
IFRAME_Test.attachEvent( "onreadystatechange" , OnTestIframeReady ); 
} 

function OnTestIframeReady() { 
if( IFRAME_Test.readyState != "complete" ) 
return; 
//Override the onmousedown event 
IFRAME_Test.contentWindow.document.onmousedown = OnTestIframeMouseDown; 
} 

function OnTestIframeMouseDown() { 
alert( IFRAME_Test_Disable_Message ); 
/* or use */ 
//the window is put beyond the user's desktop and is immediately closed 
var stubWin = window.open(‘about:blank’,’’,’ toolbars=0,width=100,height=100,top=10000,left=10000’); 
stubWin.close(); 
return false; 
} 

//Entry point 
OnCrmPageLoad(); 

</script>

</HEAD>
&t;body>

<iframe id="IFRAME_Test" frameborder="1" width="800" style="z-index:1; height:400;" src="http://weathernow.denverpost.com/"></iframe>


</body>
</HTML>

Thanks for the help.

We are updating our company website, and I would very much like to abandon all of the conditions and rejiggering that was necessary to make our site work with IE6 and earlier.

I have come up with a design that relies solely on CSS2 and is compatable with IE7 in native mode, IE8 in both native and compatability modes and FireFox 3.5. Our site is available only to our independent field reps; we cannot dictate which browser they use but our recommendation carries weight. A scan of our logs shows that we still, somehow, have reps using IE6 and it probably would be a good thing to "push" into something newer (and more secure) anyway.

IE7 has been out for 3.5 years and IE8 for more than one year. Most non-IE browsers support most or all of the CSS2 standard nowadays. At this point, is it reasonable to expect visitors to have a CSS2 compatable browser, or should we continue to support IE6 and earlier?

Well, In this scenario it is reasonable to expect visitors to have a CSS2 compatible browser.
CSS3 is also out and most browsers now has supported CSS3.

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Hi,

There is an initiative to upgrade browser on desktop from IE 6 to IE 8. As part of this initiative, all web based applications need to be remediated/tested in order to ensure that they work correctly in IE8. Please let me know on how we can identify the impacted web applications due to this initiative.
Please share if there is any standard approach or tools to address such requirement.
Kindly redirect me to any tool which will solve this purpose.

Thanks in advance.

Regards,
Riz

I found following link very useful for

"Making Your Web site Compatible Across Multiple Versions of Internet Explorer"

http://www.code-magazine.com/Article.aspx?quickid=0811032[^]

HTH

Jinal Desai - LIVE
Experience is mother of sage....

hi.

i have created a page having menu and multiview. this i used to create a tabs and on clicking on tab raises an onMenuItemClick event. this event i have placed it in vb script. when i run this page it works perfectly...and clicking on tabs shows me the content of that tab.

but when i connect this page with masterpage and instead of writing script in the webpage...i wrote it in .vb codefile and tried to run the page...but surprisingly on clicking on tab takes me to home pages which is my default.aspx. when i put breakpoints on menuclick event in .vb codefile and then tried to debug the page it doesnt raise any event on tab click because it doesnt reaches the breakpoint.

dont know what wrong with the code.

here are is the .aspx page not linked to masterpage

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WebForm7.aspx.vb" Inherits="PATHOLOGY.WebForm7" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title></title>
     <link href="tabstyle.css" rel="stylesheet" type="text/css" />
    <script runat="server">
    Sub NavigationMenu_MenuItemClick(ByVal sender As Object, _
        ByVal e As MenuEventArgs)
        'STDmultiview.ActiveViewIndex = Int32.Parse(e.Item.Value)
        If e.Item.Value = "0" Then
            STDmultiview.ActiveViewIndex = "0"
        Else
            STDmultiview.ActiveViewIndex = "1"
        End If
    End Sub
</script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
'same as latter section div

here is the master page linked page:

<%@ Page Language="vb" AutoEventWireup="false"  MasterPageFile="~/Pathology.Master" CodeBehind="TestStandards.aspx.vb"
    Inherits="PATHOLOGY.TestStandards" %>
<asp:Content ContentPlaceHolderID="PathologyHeadCPH" runat="server">
    <link href="tabstyle.css" rel="stylesheet" type="text/css" />
    
</asp:Content>

<asp:Content ContentPlaceHolderID="PathologyCPH" runat="server">

    <form id="form1" action="TestStandards.aspx">
    <div>
        <asp:Table ID="maintab" runat="server">
            <asp:TableRow>
                <asp:TableCell>
                    <asp:Table ID="content" runat="server">
                        <asp:TableRow>
                            <asp:TableCell>
                              Test Name:

                            
                            </asp:TableCell>
                            <asp:TableCell>
                                <asp:DropDownList ID="testnameddl" runat="server">
                                </asp:DropDownList>
                            </asp:TableCell>
                        </asp:TableRow>
                        <asp:TableRow>
                            <asp:TableCell>
                               Technique Name:
                            </asp:TableCell>
                            <asp:TableCell>
                                <asp:DropDownList ID="techniqddl" runat="server">
                                </asp:DropDownList>
                            </asp:TableCell>
                        </asp:TableRow>
                    </asp:Table>
                </asp:TableCell>
            </asp:TableRow>
        </asp:Table>
    </div>
    <div>
        <asp:Menu ID="teststdmenu" OnMenuItemClick="NavigationMenu_MenuItemClick" BorderWidth="0" Width="150px" runat="server" Orientation="Horizontal"
            StaticMenuItemStyle-CssClass="tab" StaticSelectedStyle-CssClass="selectedTab"
            CssClass="tabs"  Height="16px">
            <Items>
                <asp:MenuItem Text="Pre-Test & Post-Test" Value="0"></asp:MenuItem>
                <asp:MenuItem Text="Procedure & Protocols " Value="1"></asp:MenuItem>
            </Items>
        </asp:Menu>
        <div class="tabContents">
            <asp:Table runat="server" ID="teststdcontenttable">
                <asp:TableRow CssClass="ViewStyle">
                    <asp:TableCell>
                        <asp:MultiView ID="STDmultiview" runat="server">
                            <asp:View ID="pptestview" runat="server" EnableViewState="true">
                                <asp:Table Width="600" Height="400" CellPadding="0" CellSpacing="0" ID="pretesttable"
                                    runat="server">
                                    <asp:TableRow VerticalAlign="top">
                                        <asp:TableCell Width="600px"><br />
                                           <br />
                                            TAB VIEW 1 
                                        </asp:TableCell>
                                    </asp:TableRow>
                                    <asp:TableRow>
                                        <asp:TableCell>
                                            <asp:Button ID="pptestbackbtn" runat="server" Text="BACK" /><asp:Button ID="pptestsearchbtn"
                                                runat="server" Text="SEARCH" /></asp:TableCell>
                                    </asp:TableRow>
                                </asp:Table>
                            </asp:View>
                            <asp:View ID="prprview" runat="server">
                                <asp:Table Width="600" Height="400" CellPadding="0" CellSpacing="0" ID="protocoltable"
                                    runat="server">
                                    <asp:TableRow VerticalAlign="top">
                                        <asp:TableCell Width="600px"><br />
                            <br />
                                    TAB VIEW 2 </asp:TableCell>
                                    </asp:TableRow>
                                    <asp:TableRow>
                                        <asp:TableCell>
                                            <asp:Button ID="prprbackbtn" runat="server" Text="BACK" /><asp:Button ID="prprsearchbtn"
                                                runat="server" Text="SEARCH" /></asp:TableCell>
                                    </asp:TableRow>
                                </asp:Table>
                            </asp:View>
                        </asp:MultiView>
                    </asp:TableCell>
                </asp:TableRow>
            </asp:Table>
        </div>
    </div>
    </form>
</asp:Content>

modified on Friday, May 28, 2010 5:40 AM

The new plugin for WordPress that enables users to use Windows Azure Storage Service to host media for a WordPress powered blog. The plugin, developed by Microsoft, is now available as an open source project from the WordPress repository.

http://blogs.msdn.com/b/windowsazure/archive/2010/05/25/new-plugin-enables-wordpress-to-use-windows-azure-storage-services.aspx[^]

WOW!!!

Now, that add new feature in wordpress hat.

Jinal Desai - LIVE
Experience is mother of sage....

Learn Windows Azure at your own pace, in your own time and without travel headaches. Windows Azure one week pass is provided so you can put Windows Azure and SQL Azure through their paces. NO credit card required.

http://blogs.technet.com/b/webtech/archive/2010/05/27/windows-azure-virtual-boot-camp-v-june-1st-june-7th-2010.aspx[^]

I have an HTML document, containing a JavaScript routine that builds body text for an email that is sent via an ASP page using CDOSYS.

This site has been running for ages but an email has been forwarded to me that actually contains clear text HTML within the output, see below:

PRODUCT PART-NO. NO. UNIT PRICE LINE COST

Condensers 16-1099 2 GBP 69.00 GBP 138.00
Condensers 16-1311 6 GBP 46.00 GBP 276.00
Condensers< td width=15%>16-1336 2 GBP 75.00 GBP 150.00
Compressors 14-7425 1 GBP 325.00 GBP 325.00

I have very occasionally seen this from other sites that generate emails from code. How is this possible? Do I need to tighten something up somewhere?

Mike

My first thought is the problem is with the email client not rendering the html. What client were they using? Does it support html email? Did they have the option turned off?

I know the language. I've read a book. - _Madmatt

Generated email received by user with Office Outlook 2007, so HTML should be fine. Email then forwarded to me and I'm using Office Outlook 2003, again fine.

Is the body supposed to be text or is the body supposed to be HTML? I can't tell from your question if the problem is the HTML in the e-mail isn't parsing correctly or is the JavaScript not stripping out the tags properly.

The body is HTML and is generated by Javascript, so I believe the HTML in the email is not parsing correctly
Mike