Recent content by 1SorryDog

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...