Greg Aluise wrote:

I guess I'll end my rant / 2 cents there. I just ask all who make posts like "I like Linux better!" to follow up that declaration with some reason why besides "It's just better!"

Hear Hear well said!

Ok it is official that I have asked the dumbest question of the day. Thanks for you help!!

Dear all, I would like to make a narrow width combo box on the toolstrip control. It seems to limit me to 75px and greater. I would like to make a FontSize drop down which includes numbers from 1 to 7. Or should I use drop down images? but then it doesn't look "windowsy" Thank you Andrew

Make a baseline accounting sum. As in, Ok dude, each configuration change you require will be at $0.10. Then allow client some time to get better prices. When client doesnt (not even from India) and asks you for the application. You compile a color picker control. Then tell him ok, the color picker gives you 16,777,216 color configuarable options. That will be $1,677,720 (you give him 16 free config options) He he

Thank you Tiyani

This is a simple yet strange (to me) problem.In one project I can add rows to a dataset by: Dataset created dsWaterReadings and datatable inside it dtWater. dsWaterReadings.dtWater.Rows.Add("value1", "value2") In the other project I have created the same dsWaterReadings and dtWater Now if I type: dsWaterReadings.dtWater it forces me to chose dtWaterDataTable and that does not have a rows property. Using dtWaterRow yeilds even less properties. What could the difference be. All references are idential apart from System.Configuration (which I dont think is the problem) Many thanks Andrew

Hi Christian, Ok you are correct. I am currently busy converting a project from C++ to VB.NET (why I dunno but here I find myself doing this) I only notice now amongst the millions (ok not quite millions) of classes and forms and other resources that the previous guy made a LinkDialog class which basically has a textbox to indicate what text must be show and a URL textbox for the link and a dropdown to select target. So that is where it comes from. So basically I just make another one. Thank you

How does one initiate windows hyperlink dialog selector. By this I do not mean the link label. There is a dialog that is called in C++ with "using (LinkDialog dlg = new LinkDialog())" With the other dialogs you (color, font, etc) you add them via a control in the toolbox, but I do not find a LinkDialog. Many thanks

Hi David, thank you! The report is working as it should. Thanks for your perserverance and help! :thumbsup::thumbsup:

Hi David, We are on the same page. That is basically how mine works too...

Dim rpt As New rptCVForClient()

'Code to hide sections

Try
rpt.SetDataSource(dsCVForClient)
crvReport.ReportSource = rpt
Catch Excep As Exception
MessageBox.Show(Excep.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try

The problem is I have unbound text boxes in the sections that make the suppressing via property setting not work. I should probably change that, but I have never made a bound label in crystal reports... as er.. weird as that may sound.

Thats what I am looking for. The question is how do i get to each record? You havent got some code? (just the object with the periods...) :-D

Thank you, that was a great suggestion. The bad news is though, it didnt work. What happens then is it enabled the section for all the records again. So if the last record did have a vaule in the field it unhid the section for all the records.

    For i = 0 To dsCVForClient.dtInHouseOtherCourses.Count - 1
        If dsCVForClient.dtInHouseOtherCourses(i).Subjects = "" Then rpt.Subreports(0).ReportDefinition.Sections(5).SectionFormat.EnableSuppress = True Else rpt.Subreports(0).ReportDefinition.Sections(5).SectionFormat.EnableSuppress = False
    Next

I seem to think the secret lies in the rpt.Subreports(0).ReportDefinition is there some way to talk to a record in that subreport? :confused:

Hi David, Thank you for your reply. Ok the reason you dont see it is becuase maybe my brain is on overload and I posted the section it populates the dataset. The reason being is I thought maybe it could be done there somewhere. But on second thought it cant be done there. A short sample:

If dsCVForClient.dtPersonalDetails(0).ComputerPackages = "" Then rpt.DetailSection49.SectionFormat.EnableSuppress = True

If dsCVForClient.dtInHouseOtherCourses.Count = 0 Then rpt.DetailSection50.SectionFormat.EnableSuppress = True

To get to the subreport, i used: rpt.Subreports(0).ReportDefinition.Sections(5).SectionFormat.EnableSuppress = True But it led to the seciont being suppressed for all the records in the subreport. The personaldetails will only ever have 1 record for this report, but the subreports could have anything from 0 to 100 records.

Dear all, I have a crystal report which has a lot of detaildections. In 3 sections there are 3 subreports. (1 subreport per section). If there is no data available I would like to hide the section. This works perfectly for the no subreport sections. It also works perfectly if there is no data in the whole subreport. However in some cases the subreport also has section and if there is not data for that one particular section I would like to hide it. I can do this, but then it hides that section for all records in that subreport. I only want it for that specific section. I hope that makes sense. If you need more info please ask. My code is as follows:

Do While Not rs.EOF
bFound = True
With dsCVForClient
.dtPersonalDetails.Rows.Add(rs.Fields(0).Value, rs.Fields(1).Value, rs.Fields(2).Value, rs.Fields(3).Value, rs.Fields(4).Value, rs.Fields(5).Value, rs.Fields(6).Value, rs.Fields(7).Value, rs.Fields(8).Value, rs.Fields(9).Value, rs.Fields(10).Value, rs.Fields(11).Value, rs.Fields(12).Value, rs.Fields(13).Value, rs.Fields(14).Value, rs.Fields(15).Value, rs.Fields(16).Value, rs.Fields(17).Value, rs.Fields(18).Value, rs.Fields(19).Value, rs.Fields(20).Value, rs.Fields(21).Value, rs.Fields(22).Value, rs.Fields(23).Value, rs.Fields(24).Value, sClient, sVacancy, sConsultant)
rsInHouse = gCnn.Execute("select regno, tertiaryinstitute, course, duration, completed, subjects from tertiaryeducation where regno = '" & sRegNo & "'")
Do While Not rsInHouse.EOF
For i = 0 To 5
If rsInHouse.Fields(i).Value = "" Then sTertiaryEducation(i) = "Not specified" Else sTertiaryEducation(i) = rsInHouse.Fields(i).Value
Next
.dtInHouseOtherCourses.Rows.Add(sTertiaryEducation(0), sTertiaryEducation(1), sTertiaryEducation(2), sTertiaryEducation(3), sTertiaryEducation(4), sTertiaryEducation(5))
rsInHouse.MoveNext()
Loop
rsJobHistory = gCnn.Execute("select regno, company, jobtitle, datestarted, dateleft, tasks, reasonleft, duties from jobhistory where regno = '" & sRegNo & "' order by datestarted DESC")
Do While Not rsJobHistory.EOF
For i = 0 To 6
If rsJobHistory.Fields(i).Value = "" Then sJobHistory(i) = "Not specified" Else sJobHistory(i) = rsJobHistory.Fields(i).Value
Next
If rsJobHist

Hmm, no wonder I am battling away. So now to get C++.... Thank you Christian.

Dear Coders, At the risk of asking a stupid question, or at least a question that has been answered before many times. How would one go about the following situation. I have an application which comprises the following: 1. VB.NET 2008 Windows Forms application 2. MySQL 3. Framework 3.5 4. Crystal Reports 5. Infragistics UI controls 6. COM controls (to connect to MySQL database) I would like to package and deploy this application so that the user can do this without requiring much computer savvy. (Pretty much standard exam question it seems) Currently I do the installation myself and have taught one person how to install without me. Basically the steps include: 1. Install dotnexfx35.exe (not much user intervention) 2. Install MySQL (configuration is a bit above non computer savvy) 3. Install Crystal Runtime (not much user intervention so is good) 4. Run a bat file that copies the 2 COM files to %windowsroot%\system and runs regsvr32 on each. 5. Included Infragistics the first time in a deployment 6. Install setup What I would like to do is, create an autorun.ini and an exe on a CD that brings up a menu that can install the various components. However, how (in VB 2008) can I make an exe that does not need to be installed first? Do you think I am going about this the right way?

Dear All, Sorry this is a newbie type question though er, I have been programming for er 10 years. I have found one or 2 C++ pieces of code to enable squiggly lines under a text box. Alas I am no good at C++ anymore and am a VB er person. I find references to an Extended Rich Text control, but I have seen in other applications without rich text control. Unless that is just appearance. What would be the recommended path for me to try, I can use a rich text box, but ultimately I would like to have a textbox which has a spell check with some other thesauras type feature (it is for a recruitment project and I would like to have words that move people into categories - eg: if it finds FMCG underlines in blue and if the use right clicks it says it is part of Sales, Marketing and Advertising.) Many thanks