Recent content by cazellnu

Apologize for the wrong sql. I'm trying to get the total sales grouped by the "Company" with number accross different table (sitting in different database) with exactly the same database schema.

All: I had been asked to create a report against Pervasive 8 using crystal but similar is currently sitting in different table. I used the union query to links these tables as follow Select "t1"."Company", "t1"."Product", "t1"."Sales" from "t1" Union Select "t2"."Company", "t2"."Product"...

HI All I'm currently using Pervasive SQL 8 and wonder if the feature would be available for the scenario below: T1.C1 T2.C2 A 20 B 30 C 0 T2.C1 T2.C2 A 70 B 10 Result A 90 B 40 C 0 The issue is if it is possible that I can link two...

All: Is it possible to create report excel report directly against SQL Server using MS Query that had embedded in Excel 2000. If possible, is there any example that I can follow in order to entablish the connection. Any help or suggestion would be greatly apperciate. Thanks.

Dear TheAceMan1 The initial state of the recorset of the subform had not record. What I would like to do is to append the record from another table. Thanks for your help.

Hi All: I had create a form along with the subform to capture the respond of the survey. Because we are not certain that how many question will be ask in the future. I had create a table to store all the questions and would like to preload these question in one of the column within the...

I did use the add command object but I cannot get the table sitting in the db1 talk to the table sitting in the db2. Please help.

I have tables with the same schema sitting in the database (all with Pervasive SQL). I wonder what would be the best approach to union these table within the report. The tables contains two columns. Customer number and the balance,but a customer may perhaps exists in different tables. I had...

Hi All: I understand that there are thousand ways to customerize the vlookup parameter. However, if there is anyway that I can reference the table array by the following: vlookup(a1, [some sheet name reference by the cell]!A:A, 1, false). Any suggestion would be extremely helpful Regards.

Hi all I had being giving an assigment to constuct an application that involve two datagrid. To do that, I create a collection object call colObj and bind the datagrids with something similar to the following colObj1.add(obj) or colObj2.remove(obj) dg1.datasource=colObj1 dg1.databind()...

I was downloaded the driver from Seagull Scientific. I work fine with my report when I attempt to setup the print driver to print on file. However, when I attempt to connect driver to the actually printer (w/ LPT port). It gave me whole bunch of error (ie. printer not found if i tried to...

I am currently using CR8.5 and the challange is to extract fields from the database and print it in the lable printer (one of the industrial use TEC printer). I can create the report easily but the challenge is to get it to printer. My question is do crystal support those barcode printer...

I am currently using Version 7 or Crystal Report and I would like to pull out given number of randomly selected within the table randomly. I don't see I am able to use Rnd() function in my crystal report and I am wonder would there be any alternative approach. Any suggestion would be helpful...

sleipnir214: I am currently using PHP4.3.4 and Apache2.0 installed on Win2k Platform. Thanks

I had tried both code from MrBelfry and herman75. I encounter the following error when I rn Mr.Belfry's code, "Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in....". I wonder if my code was not working due to some configuration of my php.ini becasue my code is copy...