473,385 Members | 1,593 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,385 software developers and data experts.

MS Access parameterized reports

Hi, All
I need help:
I have VS .NET 2003 version 1.1 (C#) and MS Access
What will be the best way to create parameterized reports?
Please, help
I don't know where to start, any linkss to this topic will be appreciated

Oct 2 '06 #1
5 2518

elena wrote:
Hi, All
I need help:
I have VS .NET 2003 version 1.1 (C#) and MS Access
What will be the best way to create parameterized reports?
Please, help
I don't know where to start, any linkss to this topic will be appreciated
Hi

Are you going to use the bundled Crystal Reports 9 to report off the
Access database or do you plan to open the Access report from within
your C# application?

The first method is easier but requires some coding and is reliable.

The second method requires advanced coding techniques ie. interfacing
with Access... probably COM interop to access the Access application
involved.

Cheers,
ND

Oct 2 '06 #2
Hi,
I need to open and print reports within C#, back end Access db and all
reports created in Access.
Please, any links to this topic...
Thank you,

"no*************@yahoo.com" wrote:
>
elena wrote:
Hi, All
I need help:
I have VS .NET 2003 version 1.1 (C#) and MS Access
What will be the best way to create parameterized reports?
Please, help
I don't know where to start, any linkss to this topic will be appreciated

Hi

Are you going to use the bundled Crystal Reports 9 to report off the
Access database or do you plan to open the Access report from within
your C# application?

The first method is easier but requires some coding and is reliable.

The second method requires advanced coding techniques ie. interfacing
with Access... probably COM interop to access the Access application
involved.

Cheers,
ND

Oct 2 '06 #3

My advise is this:

1. Abandon the creation of reports inside the program "Access". Treat
Access as a simple datastore holding data.

2. If you have some funding, perhaps going to Active Reports is a solution.
You can get the code and try it out....... without buying it. You'll just
get a "evaluation" message on generated reports.
3. If you don't want to shell out the money for AR, then check this:
http://www.asp.net/ReportsStarterKit/
out.
or here
http://www.asp.net/DownloadWizard.as...up=StarterKits

(they seemed to have removed the web pages talking about it, though you can
still get the source code)

...

4. If youre using access because its free and what you already have, then
take a look at:

MSDE (sql server 2000 "lite")
http://sholliday.spaces.live.com/?_c...26ayear%3d2005

or SqlExpress ( the same "lite" thing, 2005 style)

"elena" <el***@discussions.microsoft.comwrote in message
news:2F**********************************@microsof t.com...
Hi, All
I need help:
I have VS .NET 2003 version 1.1 (C#) and MS Access
What will be the best way to create parameterized reports?
Please, help
I don't know where to start, any linkss to this topic will be appreciated

Oct 2 '06 #4
Try this:
http://www.thescripts.com/forum/thread13823.html

HTH
Steve

"elena" <el***@discussions.microsoft.comwrote in message
news:83**********************************@microsof t.com...
Hi,
I need to open and print reports within C#, back end Access db and all
reports created in Access.
Please, any links to this topic...
Thank you,

"no*************@yahoo.com" wrote:
>>
elena wrote:
Hi, All
I need help:
I have VS .NET 2003 version 1.1 (C#) and MS Access
What will be the best way to create parameterized reports?
Please, help
I don't know where to start, any linkss to this topic will be
appreciated

Hi

Are you going to use the bundled Crystal Reports 9 to report off the
Access database or do you plan to open the Access report from within
your C# application?

The first method is easier but requires some coding and is reliable.

The second method requires advanced coding techniques ie. interfacing
with Access... probably COM interop to access the Access application
involved.

Cheers,
ND


Oct 2 '06 #5
Opps, sorry, that's a vb.net link. Hope you can translate it.

S

"Steve Long" <St**********@NoSpam.comwrote in message
news:eU**************@TK2MSFTNGP06.phx.gbl...
Try this:
http://www.thescripts.com/forum/thread13823.html

HTH
Steve

"elena" <el***@discussions.microsoft.comwrote in message
news:83**********************************@microsof t.com...
>Hi,
I need to open and print reports within C#, back end Access db and all
reports created in Access.
Please, any links to this topic...
Thank you,

"no*************@yahoo.com" wrote:
>>>
elena wrote:
Hi, All
I need help:
I have VS .NET 2003 version 1.1 (C#) and MS Access
What will be the best way to create parameterized reports?
Please, help
I don't know where to start, any linkss to this topic will be
appreciated

Hi

Are you going to use the bundled Crystal Reports 9 to report off the
Access database or do you plan to open the Access report from within
your C# application?

The first method is easier but requires some coding and is reliable.

The second method requires advanced coding techniques ie. interfacing
with Access... probably COM interop to access the Access application
involved.

Cheers,
ND



Oct 2 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: gary b | last post by:
Hello When I use a PreparedStatement (in jdbc) with the following query: SELECT store_groups_id FROM store_groups WHERE store_groups_id IS NOT NULL AND type = ? ORDER BY group_name
7
by: Wayne Wood | last post by:
i posted this problem on microsoft.public.excel.programming, but there's no one replied till now. because this issue is time critical, i put it here to try my fortune :) ...
7
by: Teri Welch | last post by:
Hello, We maintain a VB6 front-end application using an Access 2000 database. All code and forms are in VB6. The program also uses several queries/reports defined in Access. For corporate...
4
by: Alex | last post by:
Dear netters, We are looking to build a SQL Server database that will be hooked up to a Web server (WebLogic or a .NET). The database will house data for multiple customers, and the...
3
by: John Fine | last post by:
I wrote a Delphi application that accesses a local Access database using 2 instances of the TADOQuery class. Unfortunately, when I traverse the DB records using the first TADOQuery instance, the...
8
by: brian kaufmann | last post by:
Hi, I'm new to Access and this may be a basic question but I would appreciate it if you could let me know how to do this: I've created an Access table and would like to insert a column with...
8
by: deko | last post by:
I'm trying to open a Recordset based on a parameterized query. I'm kind of new to parameterized queries, so I'm sure I'm missing something simple. Set qdfs = db.QueryDefs Set qdf =...
16
by: JoeW | last post by:
I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report,...
0
by: elena | last post by:
Hi, All I have VS .NET 1.0 and Access database, How can I print parameterized reports in C# from Microsoft Access? Please, any links related to this issue or code snipets. elena
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

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.