Search results for query: *

Need help quickly please as I'm fairly new to CR 11. I have a crystal report 11 which Is calld from my vb.net app. The database connection is added to the report via database expert using a DSN which is both on my pc and on the server. DSN is saved on the server as a system DSN. Database is...

pmegan, Thanks for the tip but .SummaryInfo is not avaliable. References: Imports VB = Microsoft.VisualBasic Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.ReportSource Imports CrystalDecisions.Shared Imports CrystalDecisions.Windows.Forms My Code: Find =...

tperri, No problem. The report is a an existing cr 6 report that wasn't created by me, however I have made changes to it in the past. It does have a field at the top of the report which is named ReportTitle1. Basically I need to send the title along with a date range (see below) to the report...

BBousman, No. I can change the text of the tabs. At the top of my report I have a field called Report Title which I want to set the title at runtime of my app. The title would read something like: "Main Plant - 02/21/2008" I just don't know how to send the title text to the report when I...

Thanks tperri I'm still missing something. I already have a report source as from above. So I'm setting a new report source? I have this code from one of the links you provided above. Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared ' ' Load the...

I'm using vb.net 2005 with crystal XI which I'm new at. I have a report viewer form called CrystalReportViewer1 My report runs fine with: frmReportViewer.CrystalReportViewer1.ReportSource = strReport '(Path to saved report file) frmReportViewer.CrystalReportViewer1.DisplayToolbar...

SanatMufasa, I finally found the problem! My query was working as it should. I found a CR or char(13) attached at the end of each string in my DESCRIPTION field. So in effect the string by string comparison wasn't matching and therefore returned no rows. I found it by pulling up sql plus then...

SantaMufasa, Ok. I'll try as close as I can. The DESCRIPTION field is defined as varchar with a length of 30. The contents of one of the fields would look something like: 1234MM020000005 RR0200-MEAT The above example is not an actual part number, but that is the format of the part number...

Mufasa, Thanks for your response. The first select statement above returns no rows. The second select statement: SELECT * FROM MY_TABLE WHERE DESCRIPTION LIKE '1234%' returns the correct row, but I need the remaining text including the minus sign compared as well. Simply put, a string to...

This maybe a dummy question but here goes.... Not sure which SQL forum to post this question but... I have a select statement for an ORACLE (9i) database similar to this: SELECT * FROM MY_TABLE WHERE DESCRIPTION = '1234-GEORGE' The DESCRIPTION field is defined as variable charater. It seems...

Thanks gmmastros. I couldn't find an ORACLE forum from the listing. Since I don't know how to move the post, I'll post over there. Thanks for the tip. SorryDog

This maybe a dummy question but here goes.... Not sure which SQL forum to post this question but... I have a select statement for an ORACLE database similar to this: SELECT * FROM MY_TABLE WHERE DESCRIPTION = '1234-GEORGE' The DESCRIPTION field is defined as variable charater. It seems that...

This maybe a dummy question but here goes.... Not sure which SQL forum to post this question but... I have a select statement for an ORACLE database similar to this: SELECT * FROM MY_TABLE WHERE DESCRIPTION = '1234-GEORGE' The DESCRIPTION field is defined as variable charater. It seems that...

Hypetia, Thanks! Your second suggestion was what I was looking for.! Too simple! I was looking the hard way of doing things! LOL Thanks again!! Sorry Dog

Anyone know where in the registry to change the default project folder? For example, I open vb, click on existing project tab. This takes me to "C:\Program Files\Microsoft Visual Studio\VB98" folder. Then I have to navigate to my project folder on the file server. My many projects are stored...

Not sure if this will work, but I have used it with an insert query. "WHERE ((Account_Detail.Account_Start_Date) BETWEEN #11/03/2002# AND #11/09/2002# AND ((Organization.Region_Num)='04') AND ((Organization.District_Num)='74')" Cheers....

Thanks for all of your replies and suggestions! As merlinx suspected, I didn't do a re-install. I have now un-installed it from the server and re-installed. It seems to be worked fine for now. Will wait until our user's start using it and see. The original api had two date values that are...

I have an app that runs on a server which use's some ORACLE API calls. I have made some changes to one of the api calls, re-compiled the app and put on server. Now, app gives error message in which I'm sure is related to the api changes that I made. The app runs fine in vb6's ide but not after...

Sounds like you want your splash screen to show instead of showing a retangle as my splash screen has in the past. I put a delay in..... try this.... put in main.bas frmSplash.Show Delay (1) Then call this function... Public Function Delay(HowLong As Integer) Dim PauseTime, Start...

Thanks for all of your suggestion's folks!!!! I ended up using another vairation of code... This does exactly what I want... Private Sub txtComment_Change() Dim char As String char = Right(txtComment.Text, 1) Select Case char Case "A" To "Z" Case "a" To...