Search results for query: *

I solved this by doing the following: 1) Creating a stored procedure instead of linking in crystal reports. 2) In the stored procedure I created a simple select statement that selects the ContractNumber. 3) In a sub query I selected the ContractNumber and linked the ContractHistory.ContractID...

CR Version: Visual Studio.Net 2005 Crystal Reports I am having a speed problem while using the subreport linking in crystal reports. I have three tables: Document - DocumentID, ContractID Contract - ContractID, ContractNumber ContractHistory - HistoryID, DocumentID, ContractID In my report I...

Just following up to my original post, I created a stored procedure using a while loop to achieve this. CREATE Procedure get_contracts @ContractID int AS BEGIN DECLARE @NextID int DECLARE @ContractTable TABLE -- Temporary Table (ContractID INT, NextContractID INT, ContractNumber...

Thank you very much George for your quick response. Basically I am looking to Select every ContractNumber that is linked to a starting point: a @parameter. I wanted to create something that is similar to a linked list. something like this link...

Database: MSDE SQL Server 2000 Table Contract ContractID PK* ContractNumber Status NextContractID FK* I am looking to select [ContractNumber] based on an input parameter and return all (non-null) of the linked [ContractNumber]s based on the [NextContractID] / [ContractID] relationship. I...

Using: Visual Studio.NET Crystal Reports, ASP.NET, C# The following code takes my parameters into the report, exports to a pdf on the client side and redirects the client to the PDF file. I need to load the pdf without leaving a file on the client or server. My basis for comparison is the way...

Thank you Shaun, I confirmed that it was a hardware issue and am having it repaired under warranty. I appreciate the help!

I'm not sure if this is a hardware or software problem but I am having a strange problem with my Toshiba A105 Laptop with a DVD+R / CD/CD-R rom drive. It will load DVD's (retail and DVD+R) fine as well as data CD's and CD-R. However the CD reader will not read the Audio CD. I was wondering if...

Hello, I am having a strange problem with my Toshiba A105 Laptop with a DVD+R / CD/CD-R rom drive. It will load DVD's (retail and DVD+R) fine as well as data CD's and CD-R. However the CD reader will not read the Audio CD. I find this to be rather strange, and I would assume it to be a failing...

Thank you again George! This was a great explanation, and it actually tied up a lot of loose ends for me about joins and derived tables. I really appreciate the help, I hope you have a great day!

Thank you so much George it works perfectly. If you don't mind I would love to hear the explanation.

Using MSDE MS SQL Server 2000 I have a table named Visitor that has two primary keys (int), Visitor_ID and VisitorVersion_ID. I am trying to return unique Visitor_ID's that have the most recent version, or in other words the Maximum VisitorVersion_ID value. My current query: SELECT...

My current formula: Day ({Visitor.SecurityDate}) & " " & uppercase(totext({Visitor.SecurityDate},"MMMM")) & " " & Year ({Visitor.SecurityDate}) Produces an undesirable result: 1.00 SEPTEMBER 2,007.00 Probably an error on my part, I did turn off the decimal places and thousand seperator for the...

Hello! I just had a (hopefully) simple question. Crystal Reports defaults the date to be lowercase and I need uppercase. I selected the format object and customize options and the formula, but I'm unsure how to distinguish the month as a string and convert it to uppercase. Any help would be...

Although this post might not be helpful to others I appreciate your feedback and the solution was simple, I had to use a subreport to get the job done. I hadn't used them before and I'm fairly new to crystal reports so I really appreciate you taking the time to respond. I have been using the...

Using Crystal Reports for VS .Net DB: SQL 2000 I have a details section that has data from a seperate table than the fields in the sections above and below. I need to print all fields in the section based on a selection criteria. For example: while (recordNumber = specifiedRecord) do (line1)...

Fixed the problem.. It was a permission setting on the database table for non admin-users.

I get a load error using Crystal Reports for visual studio.Net when using a webpage with a crystal report viewer. It loads fine in my development environment, but when exporting it to IIS it gives me an error. The table that it says is not there IS there, I am using a SQL database SQLOLEDB. When...

Fixed. Had to re-install my web package /w merge modules I believe a file got corrupted. Thanks!

I just split up the pages prior to submitting it to the database. A bit of a pain but I got it working... Thanks for your help though, you helped me realize it can't be done the way I wanted it to be done! Thank you so much