Search results for query: *

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.

...a re-synchronization process with a SQL Server database using VB.Net. If there is a mismatch in the tables, I delete the Access table (Delete * From Table), then insert the records from SQL Server. Previously, during this process, I have seen some of the tables full of records that said...

...2 Ring Ring 3 3 SPT SPT 5 4 Shelby Tube ST I can write a query such as: Select * From table and 4 rows are returned. But if I sort on certain columns, no data is returned, and no error is encountered. Select * From table Order By...

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

...Join Project P On P.TracsNumber = L.TracsNumber) Left Join SAMaterialType T On T.MaterialTypeCode = L.MaterialTypeCode Where P.ADOTPrefix Like '*60*' Order By L.TracsNumber, L.SamplePhase, L.TestHole, L.UpperDepth; I am using the query in VB.Net to populate a DataTable as follows: mdtList =...

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

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.

I may have part of the solution. I installed the latest service packs for both Crystal Enterprise 8 and Crystal Reports 8.5. Then I updated the viewer files (npviewer.exe, ActiveXViewer.cab, etc.) which my users can download from the server. When the updated viewer was downloaded, the problem...

I am trying to install some reports on a web server using CR.NET, and can't get them to run using SQL Server. If I use an Access database, they run fine. I have tried 2 different methods of coding, and I get different errors. Here are the 2 code methods...

I am trying to install some reports on a web server, and can't get them to run using SQL Server. If I use an Access database, they run fine. I have tried 2 different methods of coding, and I get different errors. Here are the 2 code methods...

I have the following array which is used to populate an MSChart: X Y 0.0012 29.19 0.00277 39.17 0.0054 49.25 0.00749 52.9 0.01013 61.63 0.01743 62.88 0.02679 67.87 0.075 88.43 0.425 92.73 2...

I'm not sure why you would say I am confusing the products?? We are considering the installation of the Advanced version of CR9 alongside our currently installed CE8 and CR8.5. This is not an upgrade. CR8.5 reports would be accessed using current web pages. CR9 reports would be accessed using...