Search results for query: *

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.

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

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

I had attempt to create the report with the following format with cross-tab but seems doesn't work: Mon Tue Wed Thr Fri Sat Sun MORNING xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx...

I noticed that crystal report allow user create label easily with Mail Label Expert. I am curious if there is an alternative way(s) to have similar functionality using only the Stand Report?

I am a newbie very interest to Cognos and wish to get in the field. Is there any good resource to get my feet wet and help me enter into the field?

If I had setup two parameters and its default values are pull from the database (i.e. first parameter is Country and the second parameters is city). I am curious if it is possible to write a formula somewhere in the report so the lookup in the second parameter will limit or even control by the...

I am installing an client/server application require Pervasive 2000 for the Backend. As result of it, I installed Pervasive server engine into database server and the application for each client. However the setup of the the application installed the workgroup engine that came with the package...

I am a newbie of Pervasive and I had tried to cofigure the old betrieve database written by Magic into the Pervasive Control Centre. I first went to create new database and point the directory field within Create Database Wizard to exactly the same directory where the actual data file was...

I need to create a report base on betrieve database(with native connection). It contains two tables (ModA and ModB)with exactly the same structure but different information. Mod A has the following field: Bin_ID Type Qty Weight A1 Normal 30 225...