Search results for query: *

that did the trick. thanks!

still no luck means, the data is still being displayed with the ID's being sorted by the group headings (the value of SPECID) as in 10035 9010 9062 9063 9099 whereas the 10035 should be after the 9099... Thanks, i'll try this one now... -

Thanks a lot, but i'm really sorry - I totally forgot to mention that i have a grouping on table.SPECID in Ascending order. I added an SQL expression called %sqlconvert and specified a convert to int, and grouped on that, but still no luck...

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

I dont think anything has changed. the ODBC DSN on the web server is a System DSN. the exact error message - on Crystal, it cant connect, and for ASP it doesnt even connect to the DSN (Data source not found). The MAX/Pervasive server is on a different machine. On my local machine with IIS...

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

would you know why I'm getting the error in the first place? thanks

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

all i get is 1) an ASP error which says " Server threw an exception". 2) if I do an on error resume next, then I get a CRAXDRT error in the ActiveX viewer.

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

Thanks for your help. However, I tried this... the only Btrieve driver in Crystal 7 I see is pdctbtrv.dll. I selected field.ddf and then made the location of Invoice Detail to \\MAX\Sales\invdet.dat. It works fine under crystal but I get a CRAXDRT error when viewing over the web... I'm using hte...

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

nope, the cast did not work. I even changed the field to datatype of varchar (4000), since a max chars of 4000 can be entered via the web interface...

yes, they are both checked.. with 0 lines for unlimited.