Re: How to create DSR so can imbed it in my VB6 exe ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

Sorry for delay in replying - if this is still an issue drop me a direct mail and I will knock up a sample.

Thanks

Rob

"Gary" <Fake@xxxxxxxx> wrote in message news:22F76483-C557-4EE7-9028-58CFF4930F1C@xxxxxxxxxxxxxxxx
Thanks Rob, that did it just fine.
Now I can at least work with it.

I have tried to do a simple 'test', following an example I found on a forum.

But I encounter an error when I try to establish a recordset

'Using CDO -----------------------------------------------------------------
' CDO is CR's version of a recordset. Load all your data to an
' Array and pass the array to Crystal
Set cdoRowset = New CrystalDataObject.CrystalComObject

I get "User Defined type not defined".

The instructions say to load the Reference "Crystal Data Objects".
But, with CRXIR2, that file is NOT available to me.
I have tried several of the other files, but it just will not resolve.

Another approach in this example is to use ADO.
So the code the use that is

'Using ADO -----------------------------------------------------------------
Set rsAdo = cmdAdo.Execute 'this has executed my dynamic select statement
Report.Database.SetDataSource rsAdo, 1, 1

But I get "subscript out of range" message with this approach.

Anything you can do to help me out here?

Once I at least get the data, then I have to figure out how to programmatically insert the data into
my report, so I can change the font/size/color depending on the data retrieved.
That's another hurdle, I expect.

Thanks





"Rob Blackmore" <rob@xxxxxxxxxxxxxxxx> wrote in message news:9E54A13A-761B-455F-894A-677ADB6A2F0A@xxxxxxxxxxxxxxxx
Hi,

No, add a reference to Crystal Reports ActiveX Designer 11.5 and then you should get Crystal Reports 11.5 on the add menu of your project context menu within VB6.


Kind regards

Rob

"Gary" <Fake@xxxxxxxx> wrote in message news:%236M$ueJLJHA.5972@xxxxxxxxxxxxxxxxxxxxxxx
Hmmmm... I am using V11R2.
Is that going to be a problem ?

If so, how do I get 8.5, so I can do this?

Thanks


"Rob Blackmore" <rob@xxxxxxxxxxxxxxxx> wrote in message news:E051DCA9-2F25-4115-B842-F2193CBD0AF6@xxxxxxxxxxxxxxxx
What version of Crystal are you using?

With 8.5 and VB6 you can just add a new report from within the VB IDE which will create a DSR and will be included in the compiled application.


Kind regards

Rob

"Gary" <Fake@xxxxxxxx> wrote in message news:2145BA33-3E6B-4592-8411-EDDA48B78031@xxxxxxxxxxxxxxxx
Hi.
I am a VIRGIN with respect to Crystal Reports.

I have a VB6 application, which has several reports.
I have written them all, using a 3rd party product (PrintPreview), which does a few things....
It does not require any format or template file... I just format a page by placing images/text on it in specified locations,
using specified fonts, italics, bold, etc., and colors, depending on the data.
It does not require any calls to any database. I do all the database calls, and place the data as I wish.
It has the ability to Preview a report, and the Users can then EXPORT the report to one of several different formats (RTF, PDF.etc)

This is all GOOD.

But... it throws an error message running under Vista. This is BAD.

After almost a year back and forth with the developer for PrintPreview, he obviously has no intention of fixing this problem.

I have searched high and low for any alternative, but can't find anything.

So I am now looking at Crystal Reports.
It certainly will work under Vista.
It has a report Preview ability.
It can export to a variety of file formats.
But... it requires a template (.rpt file),
And, it wants to do the database calls.

But, I understand I could create/use .DSR files, which I can imbed within my application.
I do NOT want to have to distribute .rpt files to my clients, nor do they want to distribute them to their clients (re-selling the app).

So... how do I create .dsr files ?
How do I get to include/imbed them in my .exe ?
Can I somehow avoid having CR do the database calls (Sub-Report) ?

Is there anything I have missed ?

Sorry... but I really am a NEOPHYTE in this regard.

Thanks for any and ALL help.





.

Relevant Pages

  • Re: HTML code is showing up
    ... This database has tables that have been around for a very long time. ... know thy limits....know thy newsgroups! ... Then double-check that the Text Format of the property in the form is plain text. ... If that is the case, when you create a report, the text box on the report should have its Text Format property set automaticallly for you. ...
    (microsoft.public.access.reports)
  • Re: Updating database from remote location
    ... To keep it simple they should export the data in a known format. ... >I have built a database for local squadrons so they can create their status ... > reports for their boss at the Wing (Navy squadron chain of command). ... > do not have access to the same network in order to complete their report. ...
    (microsoft.public.access.externaldata)
  • Re: HTML code is showing up
    ... Compact the database. ... This might mean creating another text field in your table, populating it with an Update query, deleting the old one, compacting the database, and then renaming the field back to the old one again. ... Then double-check that the Text Format of the property in the form is plain text. ... If that is the case, when you create a report, the text box on the report should have its Text Format property set automaticallly for you. ...
    (microsoft.public.access.reports)
  • Re: Need Help in formatting a report
    ... In the database you provided the link for, in the other thread, generated an error due I think to trying to stick 01.03.2006 (a non-standard date format, not recognized as an actual date by Access) into a date field. ... What I would like is to create a report that will display each employee's ... with a sample database, and report. ...
    (microsoft.public.access.reports)
  • Re: How to create DSR so can imbed it in my VB6 exe ?
    ... With 8.5 and VB6 you can just add a new report from within the VB IDE which will create a DSR and will be included in the compiled application. ... It does not require any format or template file... ... I do all the database calls, and place the data as I wish. ... But, I understand I could create/use .DSR files, which I can imbed within my application. ...
    (microsoft.public.vb.crystal)