473,320 Members | 2,097 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Crystal report parameters to be controlled by Access database table

Hi there, am wondering if there is a way to do the following:

I developed a Crystal report that runs against a Clarity table envrionment. The report runs fine.

I have been asked to run my parameter form - Crystal report against an Access database table. Once the report runs against this Access table, I need to be able to export/convert into a PDF format, then transfer this PDF report into a folder on our shared drive.

Not sure if this can be accomplished or not. Please advise. If I need to have several buttons on a parameter form, that is okay.

Please HELP.

Thank you . . . . . . .
Sep 1 '10 #1
2 2389
jimatqsi
1,271 Expert 1GB
Is this an Access question? I'm not sure there is anything to do in Access for this, unless you want to make an Access process to run the Crystal report. But maybe the report needs to maintain the ability to run against the Clarity DB.

Looks more like a question for a Crystal reports forum to me.

Jim
Sep 1 '10 #2
beacon
579 512MB
I've created a bunch of Crystal Reports against Access databases, so I know that you can create a Crystal Report that is connected to an Access database.

As far as running the report and automatically exporting it to PDF and saving it into a folder, I'm fairly sure that isn't possible from within Crystal Reports.

You may be able to program Access in VBA to run/export the report by adding a reference to the Crystal Reports library in VBA. I searched "Automatically run Crystal Report and export to PDF" and it returned a few results, although the code was written in VB. However, it would be worth taking a look at to see if you can modify the code for VBA (which may actually not be too difficult).
Sep 3 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Sam Fisher | last post by:
Hi, I have a crystal reports hosted on the IIS as web service. Everything works fine except that I can not access the database other than the one on which the report originally created. I am...
2
by: Chris | last post by:
Hi, I'm new to ASP.Net and Crystal but I've been playing with some samples and have run into a problem. If I put all my code into the Page_Init sub of a single form and run that form, the...
3
by: Matt MacDonald | last post by:
I'm trying to run a report using a form containing a crystal report viewer, but I keep getting an error saying tha "The specified value type is different to the current value type I'm trying to use...
3
by: nvx | last post by:
Hello everyone... Just for the record, I'm a newbie to this data binding thing... In my C# application I need to bind a cell of an Access database table to a multiline TextBox. How should I do...
5
by: Linds | last post by:
I have a report within my access database that I would like to have a shortcut on my desktop that could bring up that report. In other words, now I have to double click on the database, then go...
0
by: ShakirNSK | last post by:
I am facing a problem when i use to connect crystal report with MS.Access datafile i want to edit in Select query for desire results but on right clicking on command for editing is not enabled while...
1
by: geetharamanan | last post by:
i have upgraded our database from microsoft access 97 to microsoft access 2000. While executing i face problem (Unknown database found) in crystal report 7.0. How to solve this problem. the platform...
0
by: geetharamanan | last post by:
i have upgraded our database from microsoft access 97 to microsoft access 2000. While executing i face problem (Unknown database found) in crystal report 7.0. How to solve this problem. the platform...
4
by: KMEscherich | last post by:
Version of Access = 2003 Hi there, is there a way to capture data using TERADATA SQL Assistant and import a portion of this database table into a Microsoft Access database table??? I currently...
5
by: asmi | last post by:
I am new in C# programming. Can anyone plz help me in the following problem. I am changing values in different columns in access database table using c# but these changes are only visible at run...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.