Search results for query: *

Hi, I am printing a report off a VB application by passing parameters to the report but I am getting the dialog box prompting with the parameter values to the report, Is there a way to supress or eliminate this. Thanks jack

ken, Thanks for responding, I need some initial info as I read in the help about Crystal Report control which can be used for this kind of work, but when I checked for the Components in VB app can pull only CR Viewer or CR ActiveX component, Can you suggest which or these has to be used. Thanks...

Hi, Can someone help me with info on passing a parameter to CR8 which runs on a parameter and also I have couple of fields on screen that needs to be included in the report which as to be printed. An suggestion on tackling this situation. thanks Jack

Hi, I need some help working with VB6 and CR8, I have designed a query with my select statement with a parameter to be passed from VB form, so as to print a report. Also I have couple of txt boxes which are not stored in the d/b which the user inputs on the form has also to be printed on the...

Thanks for the info. Jack

Hi, I need some info on a tool or a method of running a set of reports developed in crytal reports. Is there a way that by using a some tool or so that these reports generate and print on there own. Thanks Jack

Hi, I am trying to limit records based on NULL values for a data field, as the database(visual foxpro) is displaying as 12/30/1899 as the default date. I created a formula field to check for value of above date(12/30/1899) and blank it in a IF condition, later tried to limit the records to check...

But designer stores a static data and it get difficult working with it, as the report will be based on that static data. Correct me if I am wrong. Thanks Jack

Is there a way to create a report based on a select statement that the user writes, as I am having problems with visual linking but to the limitations with multiple DSNs use. Thanks Jack

What's VFP ? Is there any other method to tackle this problem? Thanks Jack

Ken, Sorry for the confusion, I did try with each of the dsn's and tables within that(dsn) and it seems to work properly. I am using Visual Foxpro d/b not Access. Thanks Jack

No I cant retrieve with both the dsn's, Yeah if I use just one dsn and linkup tables then it works fine, problem arises whenever I try to pulling tables from another dsn, Now that I know that it limits on linking option. Is there another way to link tables out side Crw? What do you think is the...

Adding to the adove comment, I got this message when I tried adding tables for second DSN as "Database error message: More than one datasource or a stored procedure has been used in the report. Please make sure that no SQL Expression is added and no Server Side group by is performed." Jack

Ken, Just now I tried to look at the Show SQL script but for some reason whenever I add more that 2 tables from 2 DSN's it don't seems to work(greyed out). I tried adding tables from one single DSN it seems to work, wont work with multiple tables from both the DSN's. Also in the Visual Linking...

Ken, I did link the tables in Visual Linking, but for some reason it doesnt seems to recognize the links, do you think some thing I am missing some where? Jack

I am not getting any errors as such, when I generate the report it doesnt seem to recognize the linked tables, just displays data only from one of the DSNs(database), the values from the other database prints out as blanks. That is the reason I tried with ADO's(produced cartesian product for the...

Hi, I am trying to link tables thru two different databases(Visual Fox Pro), using crystal reports 8.0, but whenever I try doing it thru DSN's it doesnt seems to recognize the link or relation and doesn't give the required output. Then I tried using ADO's then its giving me a cartesian product...