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...
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...
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...
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...
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...
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)...
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...
I just updated my site added a new database table and some fields to the report, when I run it on my VS2005 machine using ASP.Net development server It runs fine. However when I run it on my IIS 6.0 server I get the following error:
Logon failed.
Details: Error Code: 0x
Source: ADODB.Connection...
Hello,
I was wondering how to generate a new page when a certain single field value grows to the max number of lines.
In my particular example I have a database field that is multiple lines in length and I want it to overflow onto a new page when it reaches the maximum number of lines (9)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.