Search results for query: *

  1. J

    Array Grouping

    I'm trying to group the results within an array which is being populated by a dataset. For reasons outside of the scope of this forum I can't group within the query populating the dataset. Example from Recordset a a a b c Example of Array values a b c Thanks for your help.
  2. J

    Simple VB .NET field

    Looking for a quick and dirty answer, I haven't seen anything but if there is a way this will save me a lot of brain damage. Is it possible to set up a combobox control so it groups the contents? For example the list of values pulled from a database (I know you can group on the database...
  3. J

    Live Reporting in CrystalViewer

    Thanks for your continued help. I'm about witts end. The report has been live for about a month now and data in it is about a week old, nothing has changed (minus criteria changing slightly in one of the SQL queries, I highly doubt this would impact it and I did verify database afterward)...
  4. J

    Live Reporting in CrystalViewer

    Thank you for the response. I have tried verifying my datatbase over, but to no avail. Any other ideas would be appreciated. This is my code to load the reports: Try 'Load report If strReport <> "" Then vwrReports.ReportSource = strPATH & strReport vwrReports.Refresh() Else...
  5. J

    Live Reporting in CrystalViewer

    I'm having difficulties ensuring that a report refreshes automatically when loaded. The data in the report is old and does not reflect recent modifications to the data it is pulling. I've developed this report in the .NET interface and have checked "discard Saved data when loading reports"...
  6. J

    Crystal Report 8.5 Viewing using CrystalViewer

    I've created a Crystal Report using 8.5 and would like to view in VB .NET's Crystal Viewer. However, when I do so I'm prompted for a login to the datasource driving the report. WHen I specify the datasource, user login, and password the system returns a message notifying of authentication...
  7. J

    Crystal Viewer

    I'm developing crystal reports in Crystal 8.5 and then calling them in a VB .NET application using the Crystal Viewer. As a user updates information in the application I want them to be able to run a report at anytime and see the changes reflected in that report. However, the current way I...
  8. J

    Combobox fill on Keypress

    I'm trying to populate a combo box on keypress. Basically, when the user begins typing in something the results of the combo box will autofill with the closest match. For example if the user types in 'S' the remainder of the world from my data source populates such as 'S' + 'ail'. If the...
  9. J

    Crystal Licensing in .NET

    I'm using the Crystal Reports Viewer in .NET. When I deploy the application I'm developing for other users, it is my undersatnding that all I need is to ensure I have included the Crystal .dll's as well as the license number obtained through the web site registration when installing Visual...
  10. J

    Crystal Reports

    Okay, just diving into Crystal Reports. I'm able to generate a report and view it during run time from a SQL Server datasource. However, something that seems so simple I can't figure out. How, if possible, can I adjust the width of the report, so that when viewed it is in landscape for...
  11. J

    Beginner who needs help!

    I would go straight to learning VB .NET. I'm not entirely familiar with your information architecture but I believe that you will be limited with VB 6.0. Since VB .NET is the way things are moving I'd definately try to learn this, you can sign up for classes for cheap. VBA is Visual Basic...
  12. J

    Beginner who needs help!

    I began programming with VB 6.0 and a lot of VBA. Within the past month I've migrated to VB .NET. VB 6.0 in my view was quite incomplete and where it was incomplete VB .NET seems to pick up the slack for the most part. With that said I find that VB .NET tends to be a little more difficult...
  13. J

    comboBox items show from database

    There are a couple ways of doing this, I feel the best way is using datasets. Look into datasets (you'll find tons of information out there on how they work, benefits, etc) to do what you need to. First you will need to create a connection the SQL Server, configure your data adapter and then...
  14. J

    The Debate VB .NET vs. C# .NET

    I'm performing a comparitive analysis on VB .NET vs C# .NET. In addition to posting here I'm posting in various other Internet Forums C# and VB .NET. Also, industry professionals and various literature sources. I've broken down the analysis into a few categories and would appreciate if any...
  15. J

    Datagrid Detail

    Thank you both for you're input. I figured it would be possible.
  16. J

    LEFT Function?

    Thank you for all the input on this. I figured out how to get it working using Microsoft.VisualBasic.Left(string,2) And thank you for the info on the substring function!!!
  17. J

    LEFT Function?

    Okay, just learning VB .NET migrating from VBA and VB 6.0. This should be super easy but I cant seem to get the LEFT Function to work. Does VB .NET support this? Thanks.
  18. J

    Datagrid Detail

    Is it possible to select a cell within a datagrid during run time and have that information populate a different control?
  19. J

    Use of datasets in code

    Thank you for all your input. In first response I tried declaring the dataset but was unable to declare the dataadapter. So what I tried was after the inherits statment I would declare the command objects. I still felt like this was inefficient. I've heard of dataviews and since I'm new...
  20. J

    Use of datasets in code

    I'm working on my first VB .NET application. I feel I'm using datasets inneffeciently. In form design I'm adding the connection, adapter, and dataset. This works great for populating controls on form load. However, if I want to populate controls during run time I find myself altering...
Back
Top