|
Hai to all,
I am using crystalreports Version7 in my VS2003(which supports crystalreports version9 ),But lower version can be used in the upper version.
Here i am getting problem when i am using report's Design part from the crystal report and the rest(like dataset and sqlquery for the report)are in .net/vbnet itself.
Here when i am debugging this,it si giving an error like "Logon Failed",I have checked the DBConnection also.
In my view there is no problem with the crystal report's Version. I am using SqlServer as backend.
Why it is giving error,For some reports it is working.
Can anybody give me the reason???
Thanks in advance
Regards,
kissy
kissy
|
|
|
|
|
Welcome to developing with Crystal Reports, the worst reporting application ever!
nothing
|
|
|
|
|
provide your database info
//set the database loggon information.
//**Note that the third parameter is the DSN name
// and not the Database or System name
reportDocument.SetDatabaseLogon("pchitriv", "Windows2000",
"TestDB_DSN", "testDB", false);
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
I need the help for printing the web page without clicking any button
|
|
|
|
|
you need an event to call the print function.
Thomas
|
|
|
|
|
|
You can call the Print() Function by declaring it, in the onLoad attribute of the Body Tag .
Regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|
|
Hi,
need help with the following code, the intention is for my server-side web app to open a doc held on the server's drive using a clients external native program (ie. notepad for a .text doc).
my code so far:
(previous page redirects to here after setting the file path as the session 'FullFilePath')
FileStream theFile = File.Open(Session["FullFilePath"].ToString(), FileMode.Open);
Response.AppendHeader("content-disposition", "attachment;filename="+Session["FullFilePath"].ToString());
Response.Write(Session["FullFilePath"].ToString());
long filesize = theFile.Length;
byte[] getContent = new byte[filesize];
Response.BinaryWrite(getContent);
Response.Flush();
Response.Close();
theFile.Close();
theFile.Dispose();
compiled my site which was all fine
but then get server error in my app when i browse to it after its set live.
'Specified argument was out of the range of valid values.
Paramater name: offset'?
but I can't see that anythings wrong?
any thoughts at all?
|
|
|
|
|
What line does the code on. The other response.write of the filename might also be giving you a problem...
|
|
|
|
|
it seems to be on the filestream line, which made me think that the file path was bad, but then i response.write displays the path as ok, though the system may think otherwise
|
|
|
|
|
ok, with lots of playing I've narrowed it down to the
'Response.BinaryWrite(getContent);'
It took me a while to get that bit to what I thought was right, and taking it out lets the page work, but it just tries to open a new IE window with the redirected page in it rather than the file that I'm trying to open, I'm a little stumped as this is al new to me.
|
|
|
|
|
HI all,
I need a help for printing the content of the page displayed in the webpage
using vb.net
Can anybody help
I will be very very pleased if i get answer
|
|
|
|
|
Printing on the client? You can just get them to hit the print button in the browser...
Also, you can set css styles with a media of 'print' that will control how your page is displaying the print preview.
|
|
|
|
|
I hope the following article may help u out
Ever wanted to print a DataGrid alone from an ASP.NET Web page? Put an <asp:DataGrid> tag inside the tag does the trick. Here are the steps involved:
1. Enclose the <asp:datagrid></asp:datagrid> tag inside the <div></div> tag.
2. Write a JavaScript function which takes care of printing the content from <div> tag.
Here's an example:
<script language=javascript>
function CallPrint(strid)
{
var prtContent = document.getElementById(strid);
var WinPrint = window.open('','','letf=0,top=0,width=1,height=1,toolbar=0,scrollbars=0,status=0');
WinPrint.document.write(prtContent.innerHTML);
WinPrint.document.close();
WinPrint.focus();
WinPrint.print();
WinPrint.close();
prtContent.innerHTML=strOldOne;
}
</script>
<div id="divPrint">
<asp:datagrid>
.....
.....
.....
</asp:datagrid>
</div>
<asp:button ID="btnPrint" onClick="javascript:CallPrint('divPrint');" Runat=Server />
Everything Is Possible!
|
|
|
|
|
I have a webform whereby i use a dropdown list to select fields like title,province etc. but the problem is that when i select a value from the dropdown and click save button,the field in the database becomes blank.
my code is as follows:
BUSINESS LAYER
Public Function GetTitle() As Data.DataSet
Dim strSQL As String
Dim obj As Datalayer.Database = New Datalayer.Database
'strSQL = "Select * from UserProfile with (nolock) where UserName='" & strUserName & "' and Status = 'A'"
strSQL = "Select TitleID, Title from Title1 with (nolock) "
GetTitle = obj.GetDataSet(strSQL)
obj.Close()
Exit Function
End Function
PRESENTATION LAYER
Private Sub LoadTitle()
Dim ds As New Data.DataSet
Dim objdata As Businesslayer.Contractors = New Businesslayer.Contractors
ds = objdata.GetTitle
cbotitle.DataSource = ds
cbotitle.DataBind()
cbotitle.Items.Add(New ListItem("Select...", ""))
cbotitle.Items.Item(cbotitle.Items.Count - 1).Selected = True
End Sub
BUTTON SAVE
Dim obj As Businesslayer.Contractors = New Businesslayer.Contractors
Dim ds As Data.DataSet
ds = obj.Getcontractor(txtfirstname.Text)
obj.AddContractor(txtID.Text, cbotitle.SelectedItem.Value, cbogender.SelectedItem.Value, txtfirstname.Text, txtlastname.Text, _
txtIDNumber.Text, txttel.Text, txtcell.Text, txtfax.Text, txtemail.Text, _
cbodepartment.SelectedItem.Value, txtlocation.Text, txtcity.Text, txtpostal.Text, txtoccupation.Text, cbomtype.SelectedItem.Value, _
cboprovince.SelectedItem.Value, txtpassport.Text)
UserMsgBox("Successfully add")
Karabo Mekgwe
|
|
|
|
|
the field in the database becomes blank.?
you mean. the selected value doesn't store in database.
some tips.
1. Set the breakpost in Button Save. Check the selected value of combobox.
2. Check whether you got any value (eg: paraProvince) in Businesslayer.Contractors.AddContractor() function. [Make ensure that all values of parameters has been passed from Presentation Layer to BusinessLayer.]
3. Check the SQL Statement.. [Make ensure that all values of parameters has been passed from BusinessLayer to DataLayer.]
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Thank you. 
|
|
|
|
|
HI all,
I need a help for printing the content of the page displayed in the webpage
using vb.net
Can anybody help
I will be very very pleased if i get answer
|
|
|
|
|
You need a client side script like:
window.print()
you can check this link:
http://www.javascriptkit.com/howto/newtech2.shtml
|
|
|
|
|
Hi
I am having 2 html pages
a.html and b.html
In a.html I am having a tag
go
Then in b.html how can we retrieve the value of querystring in b.html
only in javascript(not in asp or .net)
Thanks
Karan
|
|
|
|
|
a.html
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<p><a href="index.htm?id=1982">New Page 1</a></p>
</body>
</html>
b.html
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
<script language=javascript>
function chkQueryString(){
document.getElementById('myid').innerHTML = "Result : " + getQueryVariable('id');
}
function getQueryVariable(variable) {
var query = window.location.search.substring(1);
var vars = query.split("&");
for (var i=0;i<vars.length;i++) {
var pair = vars[i].split("=");
if (pair[0] == variable) {
return pair[1];
}
}
alert('Query Variable ' + variable + ' not found');
}
</script>
</head>
<body onload="chkQueryString();">
<div id="myid">
</div>
</body>
</html>
Hopefully. it would help.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Thank you. 
|
|
|
|
|
i have a usercontrol and there is a datalist and one imagebutton is there in datalist.when i am clicking on image button inside the datalist then itemcommand is not firing.plzz help me to solve this probs.
tbhattacharjee
|
|
|
|
|
use "LinkButton" instead of button..
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Thank you. 
|
|
|
|
|
i have given inetmgr in run my iis opened .I created one virtualDirectory and placed one.html and one.aspx files with same content.
i am able to run one.html from browser .
but i am getting page can't be displyed error for one.aspx page.
My main problem http://localhost couldn't display default server page .
So pls tell me what i have to do.
Thanks inAdvance.
|
|
|
|
|
Hi,
1. If you are adding any .aspx, that file should be a valid .aspx file. i.e Page should have '<% @Page Language='C#' %>. Otherwise it will not display.
2. If the page is valid then you need to set default page.
Open Inetmgr -> Right Click your web application -> Go to second tab 'Documents' -> Remove all files from the list -> And add your default page name.
3. If application files are in main folder (i.e wwwroot/inetpub) .. then it can be accessed using the link 'http://localhost.
4. If in some other folder then 'http://<virtual directory> (make sure that you have added default document as given in step 2).
Hope this helps.
Harini
|
|
|
|
|
Check and make sure that C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll is assigned to the Aspx extention in you application mapping dialog. You may have not installed .NET
nothing
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
