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

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

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

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

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

We currently have an intranet server running Crystal Enterprise 8.0 with web several reports (CR 8.5) that have been in operation for about a year. We are living with the 5 concurrent user licenses, and it is working fine. Now, we want to add some additional reports using Crystal Reports 9.0...

I am populating a hierarchical flexgrid with a disconnected recordset mrstList. The query used looks like this: Select ID ' Identity field, primary key Field1, Field2 = Substring(Field2, 1, 5) + ' ' + Substring(Field2, 6, 3) From MyTable The Recordset property of the...

Crystal Reports is not interpretting the value of fields correctly. The report runs from a SQL Server view, and the view displays Null values for the “MonthExecuted” when it is run alone. But within Crystal Reports, the value is a string zero - &quot;0&quot;. This is the portion of the view...

We have data like this. (The x to the right is added for clarity - it identifies pending records, see below): Group Submitted Executed -------- ---------- ---------- Group 1 200103 200104 x Group 1 199904 Null Group 1 200103 200103 Group 1 200103...

I have just installed the following: Crystal Reports 8.5/Crystal Enterprise 8 Personal Web Server The server is correctly set up to display asp pages in my web server folder. However, if I rename the file to a .csp file, it displays the text in the file, rather than the file. I am using the...

We have designed a project using VB6, SQL 2000 and Crystal reports 8. We will soon be upgrading to Crystal reports 8.5. The project has about 50 reports, and the user has decided that they want to make many of the reports available on the Web. We have 3-4 developers that have little or no Web...

My project is using VB6, Crystal Reports 8 and SQL Server 2000. I am creating and updating a Temp Table thru VB, then connecting the Temp Table to my report using OCX, Active Data and SetTablePrivateData. This works OK! However, I want to apply Filter and Sort after connecting report to the...