Search results for query: *

Hello, I am using Crystal Reports 2013. I have a SQL table with about 50K records that looks like this. I want to identify the accounts that have an Inventory_Flag of 'Y' AND 'N'. In other words, using the sample data above, the only Account I want to identify is 78989. Thanks for any...

Hello, I am using Crystal Reports 2013. I have a SQL table that looks like this with thousands of records. My report groups by and does a page break on Dept. There are many pages per Dept. The current report (mainframe COBOL) I am converting, has an index page at the end that shows each...

I am using Crystal Reports XI against SQL server tables. I have 3 SQL tables. Table A – stores all contract numbers Table B – uses the data element contract number Table C - uses the data element contract number I want to identify all contract numbers in Table A that are not found in either...

I am using Crystal XI against SQL server tables. This seems like a simple solution, but I wasn't able to find it in any of my tek-tips searches. What is the general soulution to keep Group Header and Detail records together? In other words, I don't want to end a page with a GH and I dont want...

Can Microsoft Source Safe be used effectively for Crystal XI reports?

I'm using VB.net in Visual Studio 2003 against SQL 2000 tables. I am trying to learn and apply a professional looking navigational structure for my web application. It was suggested to me to use Panels within a 2 column, 1 row table. The left table column would include my menu panel and my...

I am using Crystal Reports 8.5 against a SQL server table. I have a commodity table that looks like this Com_ID Com_lvl_1 Com_lvl_2 Description 005 005 Abrasives 00514 005 14 Abrasives toxic 00528523 005 28 Abrasives non toxic...

I am programming in VB.net using visual studio 2003 and SQL 2000. I am in the process of learning different UI techniques that can be applied to web applications. I haven't found any good resources illustrating possible navigational methods to learn from. For instance, most books/Google...

I am running Access 97. My input file does not have any Date fields at all. The input file will always contain last months data. I created a valid report displaying the data. How would I go about adding a report heading that would display the prior month/year. Examples: If I printed the...

Let's say I'm using Visual Studio to run a 'Select *' query against a SQL Server database. It my understanding that this can be accomplished in one of two ways. (Probably more but stick with me) Option A: Use the Visual Studio interface to drag and drop a SqlDataAdapter from the toolbox and...

I am trying to run some code in SQL 2000 query analyzer. I want to SELECT all columns from the Publishers database WHERE pubs_name is LIKE a supplied strSearch (the string can be anywhere in the pubs_name) When I do a syntax check on the code below I get the following SQL errors. Server: Msg...

I am running Crystal 8.5 against an Access DB. I have two tables joined by Company ID Project Table ProjectID CompanyID Amount Certification Table CompanyID ClassType (values A, B, or C) My report is summarizing each ClassType ProjectID ClassTypeA ClassTypeB ClassTypeC 1...

I need assistance writing my code-behind logic for my Update Command event for a stored procedure. I have a SQL server 2000 table that looks like this… Status_Id Status_Description A Active P Planned Both data types are char. I have a...

Application: ASP.NET DB: SQL Serer 2000 IDE: VS 2003 My SQL server table consists of this Status_id Status_Description A Active P Planned I can't seem to figure out how to update my SQL server table. I have a select statement in a stored procedure that...

Application: ASP.NET DB: SQL Serer 2000 IDE: VS 2003 I am trying to write a simple application to Select/Insert/Update/Delete records against a SQL server table. I am trying to accomplish this task using a Datagrid. I can display my table with the Edit & Update buttons. However, I have to...

Application: VB.NET 2003 DB: SQL Serer 2000 I am trying to write a simple application to Select/Insert/Update/Delete records of a SQL server table. I am trying to accomplish this task using a Datagrid. I can display my table with the Edit & Update buttons. However, I have to double-click on...

I am trying to run a tutorial using the Northwind DB. However, my DBA setup the test Northwind DB as a different name. How do I point my VS 2003 soulution to the correct SQL Server DB?

I am running a Crystal XI report against a SQL table. My SQL table looks something like this Fund Dept Character Amount 100 A 1 100 100 A 2 200 100 B 1 0 100 B 2 999 100 B 3 888 My report has 3...

I am running Business Objects XI (Release 2) against a SQL server table. When I schedule a Crystal Report in Info View and select RTF editable format, it loses reference to where the top of the page should be. In other words, the first page looks perfect, and then each subsequent page starts...

In Crystal Reports 8.5, what is the difference between... "Keep Group Together" in Change Group Options and "Keep Together" in Selection Expert? Thanks