Search results for query: *

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

Guys and Gals: I am trying to learn php from some books and I had some problem. It will be apperciate if someone can tell me what's wrong with the following syntax <FORM> Please type your name here: <BR> <INPUT TYPE=TEXT NAME=username><BR><BR> <INPUT TYPE=SUBMIT VALUE=&quot;SUBMIT...

hi: I don't know if anyone able to help me with this. I have set of flat file data in PervasiveSQL/Betrieve Format but I do not have the ddf file. I wonder if there are any reliable third-party tools that I can use to create the DDF File base on the existing data. Thank you very much.

I had some problem of apply interface polymorphism concept into my coding and I wonder if anyone know that there are some handly examples that can help me out (except the one in microsoft) Thank You

I am currently using version 7 of crystal report but I had lots of problem when I tended to export the report to Excel speadsheet especially for the format so on and so on. I would like to know what will be the best approach or if there is any rule to develop a report so it will minimize the...

In the sub reoprt, you have to use type the folling: Shared numberVar intX; intX:= sum({field}]); instead of just use grand sum Afterwards, in the main report, you have to tyep the following: Shared numberVar intX; intX You can display the Grand total of the sub report in this way as long as...