Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BobWman

  1. BobWman

    Cant Pin vbproj files

    We are using Visual Sourcesafe to migrate code through development, test and production using a sharing and pinning method. For some reason we cannot pin some of the vbproj files. These seem to be the only file types that cannot be pinned. Some of the vbproj files can be pinned, and some...
  2. BobWman

    Passing data to a Localreport

    Thanks for the response, but the link is not appropriate for a LocalReport (using a ReportViewer). I have figured it out - you have to create a parameter using the Report - Report Properties menu. Then, you link the parameter to a TextBox on the report. Finally, you can pass data from a client...
  3. BobWman

    Either can't Print or Invoke error - Catch 22

    I am using Visual Studio 2005 and SQL Reporting Services 2005 with a Local Report. I have a viewer on a WinForm. For small reports, less than 1 page, I experienced a problem where I couldn't print a report after it was displayed on the screen unless I went into Page Setup or Print Layout first...
  4. BobWman

    Passing data to a Localreport

    With Crystal reports, it was easy to pass a single piece of data from VB to a report in a formula field. How do you implement this functionality in SSRS 2005 (I am using VS 2005)? Seems like this should be commonplace, but I can't seem to find any info on it. I am using a LocalReport, so a URL...
  5. BobWman

    Reporting Services 2000 and Visual Studio 2005

    If you mean "for SQL Server 2000" the answer is yes. You can develop reports using Visual Studio 2005 and RS 2005 and using a SQL Server 2000 database.
  6. BobWman

    Parameters limited to 900 characters??

    I misdiagnosed the problem. The data was being saved. Since the large columns had many lines (CrLf), I was trying to view them with Enterprise Manager (where the rows can be expanded to view multiple lines). Apparently, EM has a 900 character limit on data it will display (seems to be...
  7. BobWman

    Parameters limited to 900 characters??

    I am using VB 2005 to populate a SQL Server 2000 table with text columns and some columns with data type of varchar(1000). The data is inserted via a stored procedure, using several parameters. Everything works fine as long as the parameter strings are <= 900 characters. But, if I try to pass a...
  8. BobWman

    Double click a row in a datagridview

    In the RowEnter event, you can capture the row into a variable: mintCurrentListRow = e.RowIndex I believe this would occur before the DoubleClick event, so the row number should be available.
  9. BobWman

    access query returns no data when order by used

    This didn't fix the problem. However, I just noticed that all the records were removed during the Compact and Repair. So, the table actually is empty. It isn't empty in the original database. I think I need to do some further analysis of the problem. I am creating the data in the table during a...
  10. BobWman

    access query returns no data when order by used

    I have a small lookup table, that looks like this: ID Code Description Abbrev ----------- ---- --------------- ------- 1 1 Bulk Bulk 2 2 Ring Ring 3 3 SPT SPT 5 4 Shelby Tube ST I can...
  11. BobWman

    Query does not return data in VB.Net

    I just found the problem. Even though Access requires * in Like clause, VB.Net still uses % just like SQL Server. This is an adventure. Many queries written in SQL Server need to be re-written to work in Access. Then, when you use Access syntax in this case, it doesn't work. Fun. Thanks for...
  12. BobWman

    Query does not return data in VB.Net

    I have the following query that correctly returns 53 rows when I run it in Access. Select L.ID, L.TracsNumber, P.OldProjectNumber, P.ADOTPrefix, L.TestHole, L.UpperDepth, L.LowerDepth, L.SamplePhase As Phase, Format(L.DateSampled, 'mm/dd/yyyy') As Sampled, T.Description As Type, L.SampledBy...
  13. BobWman

    Data in report different than view output

    I realized I can simplify this question. I create this view: Create View vTest As Select Remark = IsNull('A' + Null, '') Then I can run a query: Select * from vTest The query returns an empty string. When a report is created from the view, it returns the value "A". Why does the report...
  14. BobWman

    Data in report different than view output

    I have created a SQL Server view for a Crystal 8.5 report. The view returns a Remark field, which is a compilation of remarks from several tables. If a remark in a table is empty, there should be no output in the report. If the remark is not empty, the output identifies the table as well as...
  15. BobWman

    Problems running CR.NET web reports

    No, I never did. This was posted on another thread, but I didn't get any help. You are the 3rd person who responded that they have the same problem. So, I guess 4 of us are stuck on this one.
See more

Part and Inventory Search

Back
Top