Search results for query: *

Hello, I have a CR8 connected to an SQL server database.. I have a table called SPECS with the primary key being SPECID (nvarchar 10) and a field SPECDESC (nvarchar 255). the SPECID contains a number incrementing for each item inserted. the problem is that we have to sort the data in the crystal...

Hi, We have a web application that we wrote in ASP that also has reports tied to them. However, when we ran load tests with 4 users logged in and accessing the server, we encountered a 10% or less report failure rate (10 times out of 125 reports we ran gave an error). Here is the structure: A...

We have Pervasive 2000i installed on our server. Till last month, any ASP page that gets data from Pervasive via an ODBC connection wrked fine. Also crystal reports deployed over the web worked fine. Now, nothing... I have even made a simple page to connect to the database with objconnect.open...

we are using Pervasive V8 and are running some ASP pages that report on financial data from MAX. The ODBC drivers are somehow very slow, so we decided to switch to OLEDB. I downloaded the OLEDB for Pervasive from the pervasive website and installed it. However, when I write out the following...

I am using Crystal 7. ODBC is very slow to the Pervaisve SQL server 2000, so I decided to switch to the Crystal Btrieve Driver. Performance within Crystal was significantly improved. Here is my report structure Main Report 3 groups of fields innrmost group, account ID has a subreport in the...

Hello, I am joining an SQL Server Table to a Pervasive SQL table in a report, and am consistently getting an invalid descriptor index error. Here's the structure SQL Server tables: tbl_accounts all fields are nvarchar and fld_MAXID is char(7) tbl_territory all fields are nvarchar...

I am using Crystal 7. ODBC is very slow to the Pervaisve SQL server, so I changed to the Btrieve Driver. This is all in a subreport - I then specified the f:\MAx\sales\file.ddf location as the definition location. The database table location (just 1 table) is f:\max\sales\invdet.dat alias...

I am using Crystal 7. ODBC is very slow to the Pervaisve SQL server, so I changed to the Btrieve Driver. This is all in a subreport - I then specified the f:\MAx\sales\file.ddf location as the definition location. The database table location (just 1 table) is f:\max\sales\invdet.dat alias...

Hello, I'm using Crystal 7 in a web deployment. The actual crystal report within CR7 shows up in 20 seconds. We have a subreport within a group, which displays diff data for each group values. I'm connecting via Pervasive SQL inthe subreport and SQL Server in the main report (3 tables in main...

Hello, We are running MAX with Pervasive backend. Also we're deploying reports in Crystal Reports 7 over the web. The problem is that when i use an ODBC connection using Pervasive ODB Client tool, the reports are SUPER slow. On another site, using Crystal 8 and ODBC to Pervasive us very fast. I...

Hello all, here is my situation. We have an SQL Database that has account ifnromation, organized by sales territory and region. What we want to do is have users like sales guys have in their public folders on the exchange server have folders for each account, that match the SQL Server... For...

Hello, I have a subreport that contains a simple detail section t hat shows a comments field from an SQL Server db of type text. The subreport is linked to the main report with just 1 parameter. The text field is geting cut off at around 190 characters. However, if I create a standalone report...

We have an internal FoxPro application that uses MS Outlook to automatically send emails from MS Outlook. For every mail sent automatically by the program we get an annoying When we were using Outlook 2000, the mails were sent and we had no problems. Now With Outlook 2003, we are getting an...

We are using CR7 to publish some web reports. The web reporting pages are made with recrystallize. Sometimes they work, and sometimes they dont. I'm puzzled and the client is none too happy. What could this issue be? The report uses an SQL Server with a few tables, and a subreport connected to...

I have a Pervasive SQL table linked to a MSSQL 2000 table, both fields are char(7). I'm getting an Invalid Descriptor Index error in Crystal (7 and 8), what coudl the problem be? I'm not using any stored procedures or antyhing. Thanks!

Hi, I wrote a simple report for a client to show sales per month for a specified year. the report simply sums up each month and puts running totals for each month side by side. Now, the complicated thing is that their manufacturing calendar is differnet, and we need to go by that, so for...

I'm writing a report on an IIS server for publishing, but its so slow connecting via ODBC to a PErvasive 2000i database. Are there any performance enhancements I can do? thanks

I'm running Pervasive 2000i and am having very slow connection issues. I have a regular IIS server and the reports are run on this server, connecting via CR7 to the pervasive database on another server. I'm using a regular Pervasive ODBC client DSN to connect. is there a faster way (ie, using...

Hello, I have a CR8 report, and am trying to create a running total to sum the count of ID's using an evaluation formula: The idea is that the Id's will be counted only if the field CUSTID_32 is contained in a string of ID's, which are in the format...

I'm using CR8 and have 2 tables - Procedures and Physicians. The Procedure Table has a field that specifies Physician ID. I need to create a table that ranks Physicians based on how many procedures they have done. Currently I'm grouping by Physician and doing a Sort topN Group. But, I need to...