how do i get opening balance from previous day closing balance. here is the example date 14/2/2013 closingbalance 2000 date 15/2/2013 opening balance 2000 credit 2000 debit 500 date 15/2/2013 closingbalance 3500 date 16/2/2013 opening balance 3500 and so on here previous closing balance become opening balance. problem is that i have to show data between date and no idea how to get opening balance of first record. i am using sqlser 2005 and crystal report 10.

thanks greg but my question is to transfer data in already opened ie window.

can any one give me the idea to make a software to fill a webpage from my c# window form. i do not have any access to that webpage. i dont know where to start ,your help appreiated

crystal report viewer

unable to open crystal report its a window application . its ok when the database is on local area network. but with wAN it throws error

crystal reports does not work when it retrive data from database on webserver.it works fine when run on any desktop application. this is not login problem. my question is that is there any way to show data into crystal report from database on webserver i have done lots of googling but not found any answer :confused:

its sql expess and i am installing in through windows installer

do you mean that you want to insert data through gridview plz explain your problem

are u fetching data from database or what. if that is the case you can use sql query according to the criteria and bind them with gridview

i can not understand your question . plz provide more details

bind it to textbox column and use text box character casing property

set character casing toupper

hello everybody, i am developing a c# project and sqlsrver 2005. during deployment i used to attach database from installer. every thing works fine on xp. but on windows 7 it install perfectly but while loging it throws exception that execute permission denied on object table name user username dbo. its some time works fine and some use to throw this type of exception. i search lot on google and dont get any suitable answer. thanks in advance

hello all, how can i access data from database server which is on web in my destop window application in crystal report there is remote access alowed from the server but when i use it with crystal report 10 logon failed error it work fine with web app but what to do with desktop plz help me

hello all i am using asp.net with crystal report in my project. when i load report null is not null exception occured. it works fine on my development machine ,testing server but when i upload it to webserver it throws javasricpt exception null cannot be null message box. i have done lots of googling but i cannot find any solution. Plz help me

why dont you use enterprise.smsgupshup.com api to send sms i am using it and it is working fine it cost 6 to 10 paise per sms

set page localization to hindi and set the textbox font to any hindi font like krutidev10:thumbsup:

can you please tell me where to download or found assembly crystaldesicion.enterprise.framework as my asp.net site contain crystal report .it works fine when i run it into server server .but the server where i have to upload does not support crystal report. i have done lots of googling and found that to copy those dll into my bin directory but here i again stuk i dont found crystal.enterprise.frameework.dll and crystaldesicion.enterprise.infostore.dll in my computer and on the google. it is installed in c:\windows\assembly but i dont find the acctual path plz help me

i dont understand ur problem try textbox1.text=dr["columnname"].ToString();:rose:

string year = txtdate.Text.Substring(6, 4); string month = txtdate.Text.Substring(3, 2); string day = txtdate.Text.Substring(0, 2); DateTime dt=DateTime.Parse(year+"/"+month+"/"+day); date = date .AddDays(-1) txtdate is the textbox for date input:rose: