|
Hi,
I am developing a client server application where I need to generate a report in Excel (instead of Crystal Reports.NET). The formatting and other cell attributes need to be controlled through my VB.NET code.
What is it that I have to do?
Vinod
|
|
|
|
|
Hi Vinod,
One possible way to go: create an excel file (in Excel) with the formatting the way it needs to be. Open the excel file with .NET Studio. It will show you the file in xml form, including the necessary information concerning the formatting. Then use your code to manipulate the xml file's formatting and fill in the tags that you want. In the end save the xml file as .xls, and you are done.
Good luck,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi Johan,
What is the process of opening this Excel file in .NET studio. Seems a pretty dumb question but how do I do that?
Vinod
-- modified at 7:21 Friday 8th June, 2007
|
|
|
|
|
Hi Vinod,
Not a dumb question, I forgot to mention that you need to save the file as xml (spreadsheet) in Excel. Then you simply use open file in visual studio. In other words you open the file as an xml file. In your code it is then very simple to save the file again as .xls
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
I have migrated an application from vs 2003 to vs 2005.Everything works fine,but when i create the installation setup and deploy the application on some other machine and try to generate crystal reports i get an error "Absolute Path information required".Also when i installed the same setup on the machine on which visual studio is installed the reports are generated.
I have added all the merge modules.All the pre-requisite to the application.The database bounded to other forms is getting accessed.One more thing i would like to tell you is that even when i create new repot and new report viewer control on new form,create setup and instal the setup same problem is there.Everything works fine except reports.I'm really bugged up with error.
Let me tell u what all things i tried.
1.Adding all the 4 merge modules.
2.Changing the installation path.
3.Given TableLogOnInfo
4.Giving the absolute path during report load.for ex. crpt1.load
(Application.startuppath & "\Reports\abc.rpt")
5.Tried Changing the registry programfilesdir .
6.Create New report in the same application with new form containing new
reportviewer control.
7. I tried to modify the overridable property ResourceName abc.vb (crystal report
file).But then i get error "Unable to locat resource i the manifest"
Following is the code on the Reportviewer Form
Friend Sub UserList(ByVal strSql As String, ByVal Headers As String)
Try
Dim objRptUserLog As CrystalDecisions.CrystalReports.Engine.ReportDocument
objRptUserLog =new CrystalDecisions.CrystalReports.Engine.ReportDocument
objRptUserLog.load(Application.startuppath & "\Reports\rptUserlog.rpt"))
Dim tbCurrent As CrystalDecisions.CrystalReports.Engine.Table
For Each tbCurrent In objRptUserLog.Database.Tables
Dim oLIInfo As CrystalDecisions.Shared.TableLogOnInfo
oLIInfo = tbCurrent.LogOnInfo
With oLIInfo.ConnectionInfo
.ServerName = DatabaseConnection.GetServerName 'SETTING SERVER NAME ,UID,PWD,DATABASE
.UserID = DatabaseConnection.GetUserID
.Password = DatabaseConnection.GetPassword
.DatabaseName = DatabaseConnection.GetDatabaseName
End With
tbCurrent.ApplyLogOnInfo(oLIInfo)
Next tbCurrent
CR.DisplayToolbar = True
Dim crFormulas As CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinitions = Nothing
Dim crFormulaTextField3 As CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition
Dim strDate As String
crFormulas = objRptUserLog.DataDefinition.FormulaFields
crFormulaTextField3 = crFormulas.Item("Header")
strDate = Headers
crFormulaTextField3.Text = "'" & strDate & "'"
CR.SelectionFormula = strSql
CR.ReportSource = objRptUserLog
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub
If anyone has come across this problem before and solved it please help me.I tried searching on different sites but did not get any help as such.Please help its very urgent.
Thanks & Regards,
Manoj Bandgar
|
|
|
|
|
Hi guys,
When i tried to run the same setup on a new machine everything worked fine.Even the reports got generated and in the desired format.
On the previous machines where i installed my application and reports didn't get generated, i tried to uninstall all the components including dot net framework and reinstall them but of no use same error "Absolute Path information required" is repaeted.
Regards,
Manoj Bandgar
|
|
|
|
|
hi,
the pcs on which the crystal report was showing errror of "Absolute Path information required",i removed windows os and reinstalled it.Now everything is working fine.Even crystal reports are getting generated properly.I think some components must not be getting updated.
|
|
|
|
|
Is there a tool to generate VB code from a .REG file. I know I can import bulk registry keys with running REG IMPORT or creating the code manually. Although the latter works fine for a few settings, I would like to have bulk settings done from within the code.
|
|
|
|
|
Not that I've ever seen.
There are external utilities that will import the .REG file for you though, like RegEdit[^], of course.
|
|
|
|
|
hi i'm doing a final project, which need to send sms to the customer regarding its status.. can anyone pls tell how am i suppose to send sms from pc using vb.net 2003
|
|
|
|
|
Try this article: Send Text Message
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
thank you a lot matrix coder.. that helped a lot
|
|
|
|
|
HI
Previously my project was having the Version=0.30.0.0 of the dll IKVM.GNU.Classpath now i am trying to include or refer Version=0.34.0.3, of the same dll and its throwing me this error and i a m just not able to run the project. The dll is in the bin\debug folder of the project from where i was referring it earlier and now also. Plz Help! I am getting this error.
Could not load file or assembly 'IKVM.GNU.Classpath, Version=0.30.0.0, Culture=neutral, PublicKeyToken=13235d27fcbfff58' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
Regards
|
|
|
|
|
Basically, it looks like you tried to replace the .DLL file with a new version, then just ran your project. That doesn't work.
You have to remove the references from your project to that .DLL, then add a new reference to the new version of the .DLL.
|
|
|
|
|
Thanks Dave!
No, i am doing that only.. removing the reference from the project and then, adding new reference of the dll with different version.(I am not replacing the dll file only, I am also changing the reference also) just could not what is the problem...
Regards
|
|
|
|
|
Well, the error message says your reference is still pointing to the previous version.
|
|
|
|
|
Well its very bizard but keeping both the versions in GAC and referring the latest solved the problem....
Anyways Thanks For ur Time.......
Regards
|
|
|
|
|
Hi, i currently using VB.NET with control WebBrowser, it work properly, but when it get link to download i want to show new form not the default download form of Browser, please help me
Socheat
................
|
|
|
|
|
You can't. This is one of the bad things about the WebBrowser control. If you're serious about writing a web browser, I would suggest using the Mozilla Browser Control instead. You can customize everything about it easily.
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
Thanks, but i don't know how to do next?
Socheat
................
|
|
|
|
|
Just download and install the MozillaBrowser component. Then goto Visual Studio's Choose Toolbox Items and check MozillaBrowser in the COM menu.
Here's everything you should need:
Mozilla ActiveX Control
Embedding Mozilla
Hope this helps!
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
Thanks in advanced
Socheat
................
|
|
|
|
|
Need: I need to create a control that I can then embed into MS Word 2003.
Long story short ... I'm using VB6 for the first time in 4 years to create an ActiveX OCX. After registering the OCX, I can go into Word and bring up the Control Tool Box and select my control to add to the Word Doc.
The needed specification is to have access to this new control from the "insert" menu option and then selecting "object". My control does not show up in this list.
Does anyone know of what it takes so that my control will show up in this list? Do I need to expose a certain interface or do anything specific to my ocx for it to show up?
Thanks,
Steve Kasputis
|
|
|
|
|
Hi steve...
Try using MAcros!! May be it cud help u!
|
|
|
|
|
Hi
i have a C# 2005 and oracle 9i database
i was install client component for the .NET from oracle 9i
but when i try to run the program he give me an error message "Need Client Component version x.x.x" where x is some number i do not remember it then
i was install client component for the .NET from oracle 10g
but he give me an error message "Can not Resolove TNS name" ?
how i can solve this problem ?????
|
|
|
|