Search results for query: *

  1. S

    Running a Report from a DataSet/DataTable

    I am currently trying to run a crystal report from a DataSet with the following code I found: 'create report object Dim rpt As New ReportDocument 'load the report rpt.Load(MyReportLocation) 'create dataset dim ds as new DataSet 'get your data dim dt as DataTable = DatabaseClass.GetSomeQuery()...
  2. S

    Unexpected error with a dataconnection

    I have finished working on a VB.Net front end for an Access database and now want to create a setup file using the setup wizard provided with Visual Studio. So that the program can find the database once installed I changed all the OleDbConnections to simply "Database.mdb" after moving the...
  3. S

    Using Main Report Parameters within a SubReport

    Novell experience! Figured it out by myself, in case anyone has the same problem, put the sub report into the Group footer and not the Report footer!
  4. S

    Using Main Report Parameters within a SubReport

    I am trying to pass some parameters to a sub report from a main report, I have tried using the Change SubReport Links menu and while it displays the the parameters I want from the parent report it does not display the parameters I want to link too from the sub report! Any help would be...
  5. S

    Passing parameters from VB.Net to Crystal Reports

    I have tried re-creating the report etc but doesn't seem to change anything! I'll ask around see if I can find out what it is. Cheers mate for all your help!
  6. S

    Passing parameters from VB.Net to Crystal Reports

    I changed the code for the date pickers to: Private Sub dtpEndDate_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dtpEndDate.ValueChanged dEndDate = dtpEndDate.Value.ToShortDateString End Sub But everything else I've pretty much kept the same, if I just click...
  7. S

    Passing parameters from VB.Net to Crystal Reports

    Sweet!! Just one last thing if thats ok? Just wondering how to get rid of the dialog box that pops up when I click on Submit? It is essientially asking me to re enter the dates.
  8. S

    Passing parameters from VB.Net to Crystal Reports

    Still exactly the same problem! Does it make any difference if the dStartDate = dtpStartDate.Value.ToShortDateString is in the body of the form or part of the date picker itself? Also would it help any if I just used a text box instead of a date picker?
  9. S

    Passing parameters from VB.Net to Crystal Reports

    I have double checked the select statement within the report and it is exactly as you posted it, also I have checked the parameters (they are both discrete and set at just simple date format. The code on the date picker form is: Private Sub UserInput_Load(ByVal sender As System.Object...
  10. S

    Passing parameters from VB.Net to Crystal Reports

    I've tried inputting the code but two things happen, the first after I have pressed the submit button I get a second dialog box asking me to put the dates in again. Then when the report comes up it displays nothing but the report headers and todays date! Any suggestions? Thanks!
  11. S

    Passing parameters from VB.Net to Crystal Reports

    Hey, Can anyone help me? I am trying to figure out how to run a report that is based on information given during run time. For example a user is presented with two text boxes one asking for the toDate and the other for the fromDate. When the dates are entered a report is then run only showing...
  12. S

    Saving Time value to Access

    Hey, I keep hitting a wall when trying to save a time value to an Access table from VB .Net. I have set up a DateTime column within a DataGrid that has the following format "dd/MM/yy HH:mm" and the format within the database itself just to the General format. When I enter the date and time...
  13. S

    Concurrency Error

    The date format I'm using in the database itself is General Format and the format I’m using within VB .Net is dd/MM/yy HH:mm within a datagrid. I enter the date and time as say 06/01/06 13:20 and add other values then press my Submit button and all of that works fine. Then when I close down the...
  14. S

    Concurrency Error

    Thanks it has worked indeed, something so simple! =) I have come across another problem though, I have a DateTime field that won't update the time in the access database. It doesn't even come up with an error message it simple ignores the time i've entered and then fills it with 0's. For...
  15. S

    Concurrency Error

    Hey, I am having trouble with a DataGrid. I am using VB .Net 2003 and Access 2003, when I try and update the access table with information from the DataGrid it seems to work fine however when I try and modify a row that has already been entered I recieve the following error...
Back
Top