try this instead of SetLogOn Info
With CrystalDbTable.ConnectionProperties
.Item("Server Name") = ODBCDatabaseName
.Item("Database") = ODBCDatabaseName
.Item("User ID") = ODBCUserName...
You need to set the location of the subreport from VB, as well as the main report. I see you are not having problems with the main report, so here is a blurb about the subreport part...
Set CrystalSections = CrystalReport.Sections
For Each CrystalSection In CrystalSections
Set...
Do you have the report set to save the data with the report? If so, uncheck this option in the report options. -This should be the only change you need to make if you are programmatically connecting the report to the database properly. You may not be setting the connection to the database in the...
I feel silly. Just after this posting, I found what I needed. (Isn't that the way it always works? ;) )I will share it, as maybe others can use this info too.
Forms(i).Controls(j).Name will net you the name of the control at index j on form at index i
LilAmyRae
I would appreciate any help available on this. I am writing an application, in which a form's controls are set at runtime by any one of a number of outside templates. I'm curious to know, if anyone knows how I can obtain the list of controls on a form, by referencing the form through the forms...
Hi. Perhaps this will help. There are multiple ways you can do this. One would be sort of like this (if you truly don't care what's happening with excel, you just want to make your program wait a bit)
dim xlfile as excel.application
set xlfile = new excel.application
xlfile.visible = false
'do...
You can make just a portion of you filename a variable.
Take the Filename portion and set it to something like this:
myName = WHATEVER THE USER ENTERS
FileName = "G:\QAProdDataAcq\10Tank2_" & myName & ".xls"
I hope this helps.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.