Search results for query: *

Thank you!

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

Thank you Linda! I'll give this a shot.

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

Meant to include... Crystal Reports 2008 BusinessObjects Enterprise XI 3.1 MS SQL Server 2005 (SQL Server 9.0.4035)

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

Thank you Andy and iuianj07 for your quick responses! I got pulled to another project and just had a chance to try this. Adding the where clause to the query returns no records *sigh*.

Similar but different... :) If a customer's primary insurance for a given program is Medic and the secondary insurance is State, can both rows be excluded from results (same for secondary/tertiary insurance)? CustInsID CustID ProgID InsDesc PST 1 10 444 State 1 2...

As usual, I was trying to over complicate the solution. Thank you!

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

Thank you Brian, this works great!

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

In case you have not found a solution yet... Base your LOV on an SQL command where the CustStatus="Active". In BVM, add a data foundation (or edit your existing DF). Insert, Insert Data Tables. Under your DB Connection, double-click Add Command, enter your SQL and click OK. Then create your...

The report took 1-2 hours to run. Will post again if we get the issue resolved. Thanks!

Didn't see differences. I tried to add it again but waited longer this time. After an hour or so, it adds the SP. I tried to run the report in CR and after an hour, Task Manager shows "Not Responding". I'm just gonna let it run to see what happens. Will report back.

Thank you Turkbear! Saying I'm a newbie at SP would be an understatement :) I will take a look and report back. Thank you, DA

Meant to add I am able to add other SPs. Maybe it is something in this particular stored proc?

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

I fixed it! Went to View, Property Browser - it was checked, but the window was blank. I unchecked it. Then clicked View, checked Object Explorer. Then clicked View, checked Property Browser again. It's baaaaack. Not sure why it disappeared in the first place?

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