vb.net - Crystal report export in excel -


There is a problem with my crystal report, exporting Axl does anyone help me to code or a suggestion code How to get caught, the file you exported already exists For example if you have exported lotinfo then next lotinfo2 will be so lotinfo3 etc., my code is always exporting a single file and a name.

Click the private sub button 1_Click (System.Object, as ByVal Sender, System.EventArgs as ByVal E) button 1. Click 

  Dim CrExportOptions as export options dim CrDiskFileDestinationOptions as new _ DiskFileDestinationOptions () Dim CrFormatTypeOptions CrDiskFileDestinationOptions.DiskFileName = as new ExcelFormatOptions _ "c: \ Lot Enterprise Information.xls "Kreksportopshans = Crypt .aksportdestinashntype = Aksportdestinashntypekdiskfile .aksportformeteepe = Aksportformeteepe.aksel Kdestinashnopshans = Krdiskfiledestinashnopshans. Finished with Formetopts = CrFormatTypeOptions crypt.Export () to MessageBox.Show ( "in Czech on C:", "drive located on Enterprise Information located in Su-drive C:", "drive C:" message box button. OK, message box icon.) Hold the Expansion MSBBX ("Select specific date to convert!"). ) End end try

I have been using this function for a while I am Fix it on your usage basis. 

  The personal function filexists (strings, such as the volt path, string filename filename), string 'This function basically adds a counter when the file already exists' such as the filename file name (1) file name (2) integer as oval = 0 dim Orgeniylfailnam string = Sistmkaiokpathkcomben (path, filename) dim newFileName = as orginialFileName extension string = "" dim Training index = integer = 0 while file. Example (Nufailnam) counter = counter + 1 extension = Nyafailnamksbstring (Nyafailnamklistindaksof ( ".")) Filename = filename. Substring (0, filename.LastIndexOf ( ".")) TestIndex = filename.LastIndexOf ( "( ") If testIndex  then substring (0, testIndex) end if newFileName = String.Format (" {0} ({1}) ", System.IO.Path.Combine (Path, file name), counter.ToString ()) file name = String.Format ("{0} ({1})", file name, counter.ToString ()) NewFileName + = extension file name + = extension end File name expiration ft to return Example:  
  command output string output = fileExists ("C: \ test", "File.xls") MsgBox (output)  
 
 / Code>

link can also be useful to you.

Edit:

You can try it on your try -catch block 

  can use full full path as String = "C: \ fileinfo.xls" directory, output, file name as string if file. Example (full text) then directory = full path Sebstring (0, fulltext.listindex ("\") file name = full path FullPath = path.combine (directory, output) end if

then this part Change 

  CrDiskFileDestinationOptions.DiskFileName = _ "c: \ Lot Enterprise Information.xls"

the 

  CrDiskFileDestina TionOptions .DiskFileName = _ Fulltext

Comments

Post a Comment

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

I am using Objective-class in my Swift Project through a bridging header. The method signature looks like this: - Some cement (some type) some parameters; I started by getting an example of class, calling method, and storing the value: var myInstance = MyClassWithThatMethod (); Var cfArr = myInstance.someMethod (some value); Then try to get the value in the array: var valueInArrayThatIWant = CFArrayGetValueAtIndex (cfArr, 0); However, I get the error unmanaged & lt; Cfarray & gt; Not like 'CFArray' . Unmanaged & lt; Cfarray & gt; also means? I looked, but I do not need to change the array in a fast array (though it would be good). I need to be able to get value from the array. I also tried CFArray method to pass in a function: func doSomeStuffOnArray (myArray: NSArray) {} Although I get the same error when using: doSomeStuffOnArray (cfArr); // unmanaged & lt; CFArray & gt; I am using CFArray because I want to sto...
Read more

eclipse plugin - Run java code error: Workspace is closed -

To create an automated project, I created a plug-in project with the following dependencies: Org.eclipse.core.resources org.eclipse.equinox.registry org.eclipse.core.runtime and the following The Java class is located in the src folder: Package Examiner; Import org.eclipse.core.resources.IProject; Import org.eclipse.core.resources.IWorkspaceRoot; Import org.eclipse.core.resources.ResourcesPlugin; Import org.eclipse.core.runtime.CoreException; Import org.eclipse.core.runtime.IProgressMonitor; Import org.eclipse.core.runtime.NullProgressMonitor; Public class tes {public static zero main (string [] args) {// TODO auto generated method stub IProgressMonitor progress monitor = new NullProgressMonitor (); IWorkspaceRoot root = ResourcesPlugin.getWorkspace (). GetRoot (); Ipoject project = root.jetproject ("desired projectname"); Try {Project.create (progress monitor); Project.open (progressMonitor); } Grip (CoreException E) {// TODO Auto generated blocking block e....
Read more

c - Error on building source code in VC 6 -

When I create my project in VC6, the BScMKE reports the following error Linking .. Creating Library ... .. / ... / PB / Bean / Debub / ICEERP.Lib and Object ........ P.B. / Bean / DBube / ICREPlay.APP Browse information file ... BSMMK: ​​error can not be read from BK 1505: file '../../PB/bin/TmpOut/ICReplay/Debug/ICReplay_PB.bsc' Error executing bscmake.exe Can someone help me? 2 Reason for reference from: "ICReplay_PB .bsc "file will be corrupted The trunk of the file will be happening with the compiler running out of disk space or is being interrupted when creating .sbr file I think this answer will help you!
Read more