Recent content by BobWman

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...

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...

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...

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...

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.

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...

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...

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.

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...

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...

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...

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...

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...

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...

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.