liquidspaces

I finally found the information I need and will post it here for future reference. Hope it helps: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/crystlmn/html/crcondeployingcrystalreportsinnetapplications.asp

Robby, you rock! Thanks for your help. But I do have to ask...what's with the pound signs? Does that just indicate a date or is does it indicate any sort of special formatting such as currency or time as well? If that's the case, would I reference a field of type currency with [] as well?

I wrote a program that does a variety of different things, one of them being that it creates dynamic reports using Crystal Reports. Everything works fine and dandy when I execute the file on my machine, but when I try it on different machines everything works just fine except for the reports. They won't open at all. Are there specific files that I need to include in the same directory as the executable? I tried including the .rpt and .dll files associated with the reports but still didn't have any luck. Any advice?

I just fooled around with the database a little bit...this works fine when DATE is of type text, but not when it's type date. You're probably onto something here Robby:)

This is very strange...it started working for a couple hours and then bang, the same exact thing is happening. DATE is of type date in the database. Do you mean that I should surround it with square brackets in the SQL statement? If so, I went ahead and did that though it hasn't made any noticeable difference. Do you know of any reason why it could be cutting in and out like this? Thanks, Kevin

This section of code had been working just fine for a good while, when today it started to generate errors during execution. I didn't make any changes that I'm aware of and all variables are named as they should be. I receive the following error: "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll" When I've received this error before it's been because the field in the database that I was trying to return was empty. This isn't the case here as the field I'm trying to return is present in every database record. Here's the code. If you need more information please let me know. Dim strSelected1 As String = lbDate.SelectedItem Dim strSelected As String = LBTo.SelectedItem Dim objDateDataAdapter As New OleDb.OleDbDataAdapter( _ "SELECT BILL_OF_LADING_NUM FROM Shipping WHERE SHIP_TO = '" & strSelected & "' AND DATE = '" & _ strSelected1 & "'", OleDbConnection1) Dim objDateCommand As New OleDb.OleDbCommandBuilder(objDateDataAdapter) Dim objDateDataSet As New DataSet() objDateDataSet.Clear() objDateDataAdapter.FillSchema(objDateDataSet, SchemaType.Source, "Shipping") objDateDataAdapter.Fill(objDateDataSet, "Shipping") // WHERE THE ERROR OCCURS lbBOLN.Items.Clear() Dim i As Integer Dim strCurrent1 As String For i = 1 To objDateDataSet.Tables("Shipping").Rows.Count strCurrent1 = objDateDataSet.Tables("Shipping").Rows(i - 1).Item("BILL_OF_LADING_NUM") lbBOLN.Items.Add(strCurrent1) Next

I'm not very experienced in VB so there might be a simple answer, but I have to ask this question anyway: How are you going to write a program that interacts with a database when you have no idea how to reference the data?

LostProgrammer, Thank you so much. That works absolutely beautifully. Thanks again for your time and patience. I really appreciate it. Kevin

And let me ask you this: Does the date format that I enter in the search need to match the database date format? Or is it always necessary to use yyyy/mm/dd for the Date function? Would it be problematic if my database data format does not match the yyyy/mm/dd?

Forgive me, but there must be something basic that I need to do to in order to get this to work. I appreciate your time and patience. I execute this code on a button click event, and when I click it right now nothing happens. It doesn't crash, but it doesn't bring back any results either. I'm positive that the date range is present in the database I'm testing on. This is the code I have right now, which is essentially just what you gave me. Dim startDate As String Dim endDate As String startDate = txtStartDate.Text endDate = txtEndDate.Text Dim rep = New CrystalReport() rep.RecordSelectionFormula = "{Shipping.DATE} >= Date(" & startDate & ") AND {Shipping.DATE} <= Date(" & endDate & ")"

What I'm trying to do should be simple I think, though I'm having difficultly finding appropriate tutorials or instruction. Ideally I'd like to have the user enter in two dates, both a "From_Date" and "To_Date". I would then like to display each record that falls within that range in Crystal Reports. I'm not asking anybody to do it all for me (though if you showed me a working example I wouldn't complain), I just really need some guidance. Any book or tutorial recommendations that you might have are also very welcome. Thanks, Kevin

I'm using Crystal Reports for the first time and everything is up and running. I've grouped the records by name by right-clicking the report->insert->group, etc. The end result is that each unique name is listed on the left hand side of the control, and the data corresponding with those unique names is displayed on the right. Nothing fancy...straight out of the box. My question is, and I hope I'm asking this clearly, can I make it work so that when I click a unique name on the left hand side of the report control that only the corresponding records will be displayed on the right? Currently the starting position will be highlighted, but this does nothing for me in the way of printing relevant information. I hope that was clear...it's a bit difficult to explain. Thanks, Kevin

I'm running VB.Net Standard Edition, and can't find Crystal Reports anywhere. It isn't in the toolbox. It isn't a component that I can add to a form. Is it not included in my version of Visual Basic? Do I have to buy VisualStudio Professional just to use this one thing?

Great, thanks for your help. I just have one more question: How do I insert a newline? I just need to know how to insert a hard return. The example I found in the VB.NET help was a bit strange...it looked like an awful lot of work just to do this.

I'm trying to create a report directly in Visual Basic.Net, and I'm not sure what component to use. In VB 6 I used text boxes for this type of thing since it was very easy to size them however big or small I wanted and formatting the data within them was a snap. However, in VB.NET I can't figure out how to set the height of the text box. Even changing the windows generated code doesn't do the trick. Am I stuck with a height of 20px? A list box could work as it's easy to resize, though I don't know if there's a way to get more than one item on each line. Is there any formatting code in VB.NET like there is in C++? A '\n' or anything for hard returns? Thanks, Kevin