 |  |  |  |  |  |  |  |
Change Crystal OLE path?
 |
Hi,
I currently have a crystal report (verison 10) with a linked ole object linking to an excel spreadsheet. I need to be able to programmically change the link path at runtime using vb6.
You can do it in crystal by going view -> links ->change source so surely there is a parameter we can pass to the ole object that denotes its source path?
I currently have a crystal report (verison 10) with a linked ole object linking to an excel spreadsheet. I need to be able to programmically change the link path at runtime using vb6.
You can do it in crystal by going view -> links ->change source so surely there is a parameter we can pass to the ole object that denotes its source path?
Hi
This is exactly what I am trying to do now. I want to pass a variable from the crystal report into the pathname or alternatively link to the excel sheet saved as a BLOB in a database???
any help apreciated
Thanks
john
This is exactly what I am trying to do now. I want to pass a variable from the crystal report into the pathname or alternatively link to the excel sheet saved as a BLOB in a database???
any help apreciated
Thanks
john
I used an OLE field in the end.
http://devlibrary.businessobjects.co...ramming29.html
The key is the .SetOleLocation member function. This can only be set in the Section_Format or declare WithEvents.
There is a size limit with ole objects of about a page.
http://devlibrary.businessobjects.co...ramming29.html
The key is the .SetOleLocation member function. This can only be set in the Section_Format or declare WithEvents.
There is a size limit with ole objects of about a page.
|
Similar Threads
- build output path (C++)
- Application Installation Path (VB.NET)
- ClickOnce Installation Path (VB.NET)
- crystal report image.. (VB.NET)
- Creating Dynamic Crystal Reports at runtime in .Net? (ASP.NET)
- Is it necessary to buy Crystal report? (VB.NET)
- crystal report to pdf using c# (C#)
- My main page is "http://rl.webtracer.cc/-/?bayzm" no matter what i do to change it... (Viruses, Spyware and other Nasties)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: VB6:setting footer for an existing word
- Next Thread: converting a text or xml file into binary format
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
