Search results for query: *

Not sure if this is a SQL issue or CR issue. We are capturing signatures electronically via signature pad. They are stored in a text column. When I try to add the signature field to the report, it shows numbers (pages of numbers). I’ve tried converting from text datatype to varbinary(max)...

Hello! We have a report grouped by Teams. The teams are currently maintained in an Excel file which allows the user to maintain the Teams. I know having Excel as a data source is not ideal, but the data is not available in the SQL Server tables. The report is based on an SQL command with a...

I created a Data Foundation (DF) in Business View Manager (BVM). Then added a command which is the subquery below (to get max ServiceID where BonusType is NULL. Then added left join from the Appoinment table to the command on the AppointmentID field. Trying to accomplish in the DF what is...

How do you exclude records based on values in multiple rows? If a customer has purchased "BEH" in the past, exclude customer from results... CustID Order# ProdDesc 13 0001 BEH 13 0002 CS 15 0003 CS 12 0004 BEH 14 0005 VR 15 0006 PS 12 0007 BEH If I...

Crystal Reports 2008 BusinessObjects Enterprise XI 3.1 MS SQL Server 2005 (SQL Server 9.0.4035) In CR2008, is it possible to select a date range parameter based on a category in a drop down list? Would like to add a couple of date range prompts which are based on a selected type of date...

Crystal Reports 2008 BusinessObjects Enterprise XI 3.1 MS SQL Server 2005 I am trying to set up a Data Foundation based on a stored procedure in Business View Manager. I click File, New, Data Foundation, select the Data Connection, select the Stored Procedure, then click Add button. I wait...

Crystal Reports 2008 BusinessObjects Enterprise XI 3.1 MS SQL Server 2005 I was working in BVM (adding passwords to data connections, etc.)...then the Property Browser went blank. You can see the window but no properties. I closed BVM and reopened with no resolution. Anyone know how to...

Crystal Reports 2008 BusinessObjects Enterprise XI 3.1 MS SQL Server 2005 The report has several optional parameters which work when the report is run locally. Added the report to InfoView using the Publishing Wizard. When you run the report thru InfoView, available values for dynamically...

Hello, (Crystal Reports 2008 with SQL Server) Working on a report which shows customer appointments grouped by technician (the person who provided the service). In the detail, would like to include a count of appointments in the last 30 days for each customer based their Account Status...

Hello! I wrote a nested if in Excel that seems to work nicely. However, I am not able to get the same results in Access query. The second if returns "Null End Date" in Excel, but returns "#Error" in Access query. Excel formula (sub'd field names for cell names here)...

Hello, I'm posted this in the MS Windows XP Pro forum too -- the problem also occurs in non-MS apps). Some fonts that I was using are still listed, but do not display properly. This has happened in MSWord/Excel 2002 and in Paint Shop Pro. One of the fonts is Raavi (raavi.ttf). I checked the MS...

Hello, I'm going to post this in the MSOffice forum too -- the problem also occurs in non-MS apps). I did not see a forum for Win XP Home version, so I'm posting here. Some fonts that I was using are still listed, but do not display properly. This has happened in MSWord/Excel 2002 and in Paint...

Hi ya'll, Not sure if this is the place to post this. We just got an LCD monitor, and I'm not sure if I like it yet. I use PSP to edit digital photos (from our digital camera). I'm concerned about color -- would like to get as close to "what you see is what you get" for the prints. I...

I found a similar post from a couple years ago, but the browser versions were different. I have a page with CSS. I want to play background music (midi file) when it loads. Here is the code I'm using: <EMBED SRC=&quot;audio/somesong.mid&quot; width=144 height=60 AUTOSTART=TRUE></EMBED>...

I had Windows Media Player set as the default for *.wav and *.mid files in IE5.0. Now it is set to QuickTime. How can I change it back? D.A.

I created a table that will generate record numbers using an Oracle sequence (increment by 1). There is a date field in the record (Oracle DATE type). Is there a way to delay the time in the DATE field by a few seconds (between each transaction)? I thought about using a PAUSE, but would like...

Using SCR8 Trying to create a report that shows all the dates from TABLE1 for a given week (via parameter fields) even if there is no corresponding record in TABLE2. The following is what I have in the Select Expert when you show the formula. {TABLE2.DEPT} = {?Department} and...

I found a suggested solution to this at: http://support.seagatesoftware.com/library/kbase/articles/c2005126.asp?AJID=AA445CBF22308D468A82EE2F3E60334C I made the changes to the client access settings and continue to receive the error. Do I need to recreate the report or edit the SQL statement...

I'm a Newbie to Seagate Crystal Reports (using version 8.0). I am attempting to design a report that sorts by date and groups weekly. I have a basic understanding of the grouping but cannot find a function to group by date. Is it necessary to have a table of week numbers and date detail...