I am looking for Access reporting add-in that would be easy to use by
end users. My key focus is on selection criteria. I am very happy with
the Access report writer capabilities. As far as development of
reports, it is certainly fine in my book.
But for end-users, with little experience or training, it would be nice
to have an easy way to handle various selection criteria, perhaps with
relatively stock reports. I see easy to use by novice end-users of
selection capabilities as the biggest limitation in just directly having
users use the Report Wizard!
I certainly have built forms with selection criteria on the form that is
then applied to the reports. This works well for reports where the
selection criteria applies to all reports. but if the reports are
varied, each with various potential selection, such would mean unique
selection criteria forms for each report or report type - seems like a
lot of work.
So far I have found the following:
Cub Reporter for MS Access $40
-------------------------- https://www.swreg.org/soft_shop/224/shopscr7.shtml
This is an add in you can add to existing reports. Pretty nice
capabilities for selection, based on the fields in the report
definition. Apparently can be easily added on to previously prepared
reports.
Might even be able to have users create the basic report using the
report wizard. then teach how to add the link to this add-in in the
report. When added, it would give easy to use selection criteria - I think.
Output Writer Wizard for MS Access $50
---------------------------------- http://www.acc-technology.com/owwiz.htm
Advantage is that it allows you to select the fields for the report and
build it all in one. Only three selection criteria. No totals. Stand
along capability - not used with predefined reports. Seems very basic
in capabilities.
Drill down Tally 2005 - $200
--------------------- http://www.intellirel.com/DrillDownTally.asp
Seems to be more oriented to drill down capabilities.
Haven't looked very far into this.
ASP Report Wizard 2.0 - free for educational - $395 commercial
--------------------- http://www.aspwebsolution.com/produc...zard/index.htm
Not really an Access add-on. A web based reporting capability.
Looks interesting but not investigated very far.
I would be VERY interested in suggestions for other products you may
have used with success, experience you may have in trying or using any
of the above products, or alternative suggestions for providing easy to
use selection with Access built in report capabilities including the
report wizard.
Bob
bobalston9 AT yahoo DOT com 6 3641
Bob,
I don't know of Add-Ins, but have worked on projects where there was a form
for selection that applied to many different reports -- of course, they all
dealt with much the same data. I am sure it would be possible to write a
more general one, picking up fields from the RecordSource of the selected
Report. The problem I see with that is that it'll be relatively easy to do
for reports that do have much the same data, because you'll know in advance
whether your selections have to be direct entry into a text box, or whether
you can let the user select in a combo box, use a date picker, and/or enter
a range or a before or after date option.
On that same project, the client project administrator had been sold on a
feature of another product... a very simple report generator, allowing the
user to pick from a predefined set of fields, specify some selection, etc.
But, in making it what they thought was simple enough for an average user,
they made it too simple for the data to be useful to any of the users. They
put a good deal of time and effort into it, and it ended up never being used
(as far as we could determine) beyond a little experimentation right after
it was introduced to the users. So, you have to guard against
over-simplification.
Larry Linson
Microsoft Access MVP
"Bob Alston" <tu****************@cox.net> wrote in message
news:ZLNmf.2749$Ev.2047@fed1read06... I am looking for Access reporting add-in that would be easy to use by end users. My key focus is on selection criteria. I am very happy with the Access report writer capabilities. As far as development of reports, it is certainly fine in my book.
But for end-users, with little experience or training, it would be nice to have an easy way to handle various selection criteria, perhaps with relatively stock reports. I see easy to use by novice end-users of selection capabilities as the biggest limitation in just directly having users use the Report Wizard!
I certainly have built forms with selection criteria on the form that is then applied to the reports. This works well for reports where the selection criteria applies to all reports. but if the reports are varied, each with various potential selection, such would mean unique selection criteria forms for each report or report type - seems like a lot of work.
So far I have found the following:
Cub Reporter for MS Access $40 -------------------------- https://www.swreg.org/soft_shop/224/shopscr7.shtml
This is an add in you can add to existing reports. Pretty nice capabilities for selection, based on the fields in the report definition. Apparently can be easily added on to previously prepared reports.
Might even be able to have users create the basic report using the report wizard. then teach how to add the link to this add-in in the report. When added, it would give easy to use selection criteria - I think.
Output Writer Wizard for MS Access $50 ---------------------------------- http://www.acc-technology.com/owwiz.htm Advantage is that it allows you to select the fields for the report and build it all in one. Only three selection criteria. No totals. Stand along capability - not used with predefined reports. Seems very basic in capabilities.
Drill down Tally 2005 - $200 --------------------- http://www.intellirel.com/DrillDownTally.asp Seems to be more oriented to drill down capabilities. Haven't looked very far into this.
ASP Report Wizard 2.0 - free for educational - $395 commercial --------------------- http://www.aspwebsolution.com/produc...zard/index.htm Not really an Access add-on. A web based reporting capability. Looks interesting but not investigated very far.
I would be VERY interested in suggestions for other products you may have used with success, experience you may have in trying or using any of the above products, or alternative suggestions for providing easy to use selection with Access built in report capabilities including the report wizard. Bob
bobalston9 AT yahoo DOT com
Larry Linson wrote: Bob,
I don't know of Add-Ins, but have worked on projects where there was a form for selection that applied to many different reports -- of course, they all dealt with much the same data. I am sure it would be possible to write a more general one, picking up fields from the RecordSource of the selected Report. The problem I see with that is that it'll be relatively easy to do for reports that do have much the same data, because you'll know in advance whether your selections have to be direct entry into a text box, or whether you can let the user select in a combo box, use a date picker, and/or enter a range or a before or after date option.
On that same project, the client project administrator had been sold on a feature of another product... a very simple report generator, allowing the user to pick from a predefined set of fields, specify some selection, etc. But, in making it what they thought was simple enough for an average user, they made it too simple for the data to be useful to any of the users. They put a good deal of time and effort into it, and it ended up never being used (as far as we could determine) beyond a little experimentation right after it was introduced to the users. So, you have to guard against over-simplification.
Larry Linson Microsoft Access MVP
"Bob Alston" <tu****************@cox.net> wrote in message news:ZLNmf.2749$Ev.2047@fed1read06...
I am looking for Access reporting add-in that would be easy to use by end users. My key focus is on selection criteria. I am very happy with the Access report writer capabilities. As far as development of reports, it is certainly fine in my book.
But for end-users, with little experience or training, it would be nice to have an easy way to handle various selection criteria, perhaps with relatively stock reports. I see easy to use by novice end-users of selection capabilities as the biggest limitation in just directly having users use the Report Wizard!
I certainly have built forms with selection criteria on the form that is then applied to the reports. This works well for reports where the selection criteria applies to all reports. but if the reports are varied, each with various potential selection, such would mean unique selection criteria forms for each report or report type - seems like a lot of work.
So far I have found the following:
Cub Reporter for MS Access $40 -------------------------- https://www.swreg.org/soft_shop/224/shopscr7.shtml
This is an add in you can add to existing reports. Pretty nice capabilities for selection, based on the fields in the report definition. Apparently can be easily added on to previously prepared reports.
Might even be able to have users create the basic report using the report wizard. then teach how to add the link to this add-in in the report. When added, it would give easy to use selection criteria - I think.
Output Writer Wizard for MS Access $50 ---------------------------------- http://www.acc-technology.com/owwiz.htm Advantage is that it allows you to select the fields for the report and build it all in one. Only three selection criteria. No totals. Stand along capability - not used with predefined reports. Seems very basic in capabilities.
Drill down Tally 2005 - $200 --------------------- http://www.intellirel.com/DrillDownTally.asp Seems to be more oriented to drill down capabilities. Haven't looked very far into this.
ASP Report Wizard 2.0 - free for educational - $395 commercial --------------------- http://www.aspwebsolution.com/produc...zard/index.htm Not really an Access add-on. A web based reporting capability. Looks interesting but not investigated very far.
I would be VERY interested in suggestions for other products you may have used with success, experience you may have in trying or using any of the above products, or alternative suggestions for providing easy to use selection with Access built in report capabilities including the report wizard. Bob
bobalston9 AT yahoo DOT com
Thanks Larry.
The first product in my original message, Cub reporter, seems like a
nice, simple add-in to Access reports that would provide user-defined
data selection. And it can support fairly complex selections by the
option of entering a where clause. And it would seem to avoid a lot of
development by me.
Now a tough question. To make this add in easily available to user
generated reports, generated using the Report Wizard, it would be nice
if I could use VBA code to automatically add the online OPEN EVENT to
the report. I could have detailed instructions for the user to edit the
report design and add the event but that seems cumbersome. I would plan
to have a button to bring up a form where the user selected a report
from a drop-down list and then selected a button to run the code to add
the open event to the selected report.
I am experienced in writing Form events and with writing VBA code to
access table and query collections. But I cannot find anything relative
to how I could use VBA code to create an Open event for a report.
Suggestions?
Bob
Bob Alston wrote: Larry Linson wrote:
Bob,
I don't know of Add-Ins, but have worked on projects where there was a form for selection that applied to many different reports -- of course, they all dealt with much the same data. I am sure it would be possible to write a more general one, picking up fields from the RecordSource of the selected Report. The problem I see with that is that it'll be relatively easy to do for reports that do have much the same data, because you'll know in advance whether your selections have to be direct entry into a text box, or whether you can let the user select in a combo box, use a date picker, and/or enter a range or a before or after date option.
On that same project, the client project administrator had been sold on a feature of another product... a very simple report generator, allowing the user to pick from a predefined set of fields, specify some selection, etc. But, in making it what they thought was simple enough for an average user, they made it too simple for the data to be useful to any of the users. They put a good deal of time and effort into it, and it ended up never being used (as far as we could determine) beyond a little experimentation right after it was introduced to the users. So, you have to guard against over-simplification.
Larry Linson Microsoft Access MVP
"Bob Alston" <tu****************@cox.net> wrote in message news:ZLNmf.2749$Ev.2047@fed1read06...
I am looking for Access reporting add-in that would be easy to use by end users. My key focus is on selection criteria. I am very happy with the Access report writer capabilities. As far as development of reports, it is certainly fine in my book.
But for end-users, with little experience or training, it would be nice to have an easy way to handle various selection criteria, perhaps with relatively stock reports. I see easy to use by novice end-users of selection capabilities as the biggest limitation in just directly having users use the Report Wizard!
I certainly have built forms with selection criteria on the form that is then applied to the reports. This works well for reports where the selection criteria applies to all reports. but if the reports are varied, each with various potential selection, such would mean unique selection criteria forms for each report or report type - seems like a lot of work.
So far I have found the following:
Cub Reporter for MS Access $40 -------------------------- https://www.swreg.org/soft_shop/224/shopscr7.shtml
This is an add in you can add to existing reports. Pretty nice capabilities for selection, based on the fields in the report definition. Apparently can be easily added on to previously prepared reports.
Might even be able to have users create the basic report using the report wizard. then teach how to add the link to this add-in in the report. When added, it would give easy to use selection criteria - I think.
Output Writer Wizard for MS Access $50 ---------------------------------- http://www.acc-technology.com/owwiz.htm Advantage is that it allows you to select the fields for the report and build it all in one. Only three selection criteria. No totals. Stand along capability - not used with predefined reports. Seems very basic in capabilities.
Drill down Tally 2005 - $200 --------------------- http://www.intellirel.com/DrillDownTally.asp Seems to be more oriented to drill down capabilities. Haven't looked very far into this.
ASP Report Wizard 2.0 - free for educational - $395 commercial --------------------- http://www.aspwebsolution.com/produc...zard/index.htm Not really an Access add-on. A web based reporting capability. Looks interesting but not investigated very far.
I would be VERY interested in suggestions for other products you may have used with success, experience you may have in trying or using any of the above products, or alternative suggestions for providing easy to use selection with Access built in report capabilities including the report wizard. Bob
bobalston9 AT yahoo DOT com Thanks Larry.
The first product in my original message, Cub reporter, seems like a nice, simple add-in to Access reports that would provide user-defined data selection. And it can support fairly complex selections by the option of entering a where clause. And it would seem to avoid a lot of development by me.
Now a tough question. To make this add in easily available to user generated reports, generated using the Report Wizard, it would be nice if I could use VBA code to automatically add the online OPEN EVENT to the report. I could have detailed instructions for the user to edit the report design and add the event but that seems cumbersome. I would plan to have a button to bring up a form where the user selected a report from a drop-down list and then selected a button to run the code to add the open event to the selected report.
I am experienced in writing Form events and with writing VBA code to access table and query collections. But I cannot find anything relative to how I could use VBA code to create an Open event for a report.
Suggestions?
Bob
I think I am slooooowwwly getting there. I believe I can refer to the
report object (not open) via this code:
Set rptcurr = CurrentProject.AllReports("test")
Still stumped to get access to the module object that is part of the
report object.
I also understand that there is one module in the report object and you
can get various properties to parse the various procedures (functions,
subprograms, etc) within it. If I am creating the only procedure in the
module, that might be pretty easy.
Bob
Bob
Bob Alston wrote: Bob Alston wrote:
Larry Linson wrote:
Bob,
I don't know of Add-Ins, but have worked on projects where there was a form for selection that applied to many different reports -- of course, they all dealt with much the same data. I am sure it would be possible to write a more general one, picking up fields from the RecordSource of the selected Report. The problem I see with that is that it'll be relatively easy to do for reports that do have much the same data, because you'll know in advance whether your selections have to be direct entry into a text box, or whether you can let the user select in a combo box, use a date picker, and/or enter a range or a before or after date option.
On that same project, the client project administrator had been sold on a feature of another product... a very simple report generator, allowing the user to pick from a predefined set of fields, specify some selection, etc. But, in making it what they thought was simple enough for an average user, they made it too simple for the data to be useful to any of the users. They put a good deal of time and effort into it, and it ended up never being used (as far as we could determine) beyond a little experimentation right after it was introduced to the users. So, you have to guard against over-simplification.
Larry Linson Microsoft Access MVP
"Bob Alston" <tu****************@cox.net> wrote in message news:ZLNmf.2749$Ev.2047@fed1read06...
I am looking for Access reporting add-in that would be easy to use by end users. My key focus is on selection criteria. I am very happy with the Access report writer capabilities. As far as development of reports, it is certainly fine in my book.
But for end-users, with little experience or training, it would be nice to have an easy way to handle various selection criteria, perhaps with relatively stock reports. I see easy to use by novice end-users of selection capabilities as the biggest limitation in just directly having users use the Report Wizard!
I certainly have built forms with selection criteria on the form that is then applied to the reports. This works well for reports where the selection criteria applies to all reports. but if the reports are varied, each with various potential selection, such would mean unique selection criteria forms for each report or report type - seems like a lot of work.
So far I have found the following:
Cub Reporter for MS Access $40 -------------------------- https://www.swreg.org/soft_shop/224/shopscr7.shtml
This is an add in you can add to existing reports. Pretty nice capabilities for selection, based on the fields in the report definition. Apparently can be easily added on to previously prepared reports.
Might even be able to have users create the basic report using the report wizard. then teach how to add the link to this add-in in the report. When added, it would give easy to use selection criteria - I think.
Output Writer Wizard for MS Access $50 ---------------------------------- http://www.acc-technology.com/owwiz.htm Advantage is that it allows you to select the fields for the report and build it all in one. Only three selection criteria. No totals. Stand along capability - not used with predefined reports. Seems very basic in capabilities.
Drill down Tally 2005 - $200 --------------------- http://www.intellirel.com/DrillDownTally.asp Seems to be more oriented to drill down capabilities. Haven't looked very far into this.
ASP Report Wizard 2.0 - free for educational - $395 commercial --------------------- http://www.aspwebsolution.com/produc...zard/index.htm Not really an Access add-on. A web based reporting capability. Looks interesting but not investigated very far.
I would be VERY interested in suggestions for other products you may have used with success, experience you may have in trying or using any of the above products, or alternative suggestions for providing easy to use selection with Access built in report capabilities including the report wizard. Bob
bobalston9 AT yahoo DOT com
Thanks Larry.
The first product in my original message, Cub reporter, seems like a nice, simple add-in to Access reports that would provide user-defined data selection. And it can support fairly complex selections by the option of entering a where clause. And it would seem to avoid a lot of development by me.
Now a tough question. To make this add in easily available to user generated reports, generated using the Report Wizard, it would be nice if I could use VBA code to automatically add the online OPEN EVENT to the report. I could have detailed instructions for the user to edit the report design and add the event but that seems cumbersome. I would plan to have a button to bring up a form where the user selected a report from a drop-down list and then selected a button to run the code to add the open event to the selected report.
I am experienced in writing Form events and with writing VBA code to access table and query collections. But I cannot find anything relative to how I could use VBA code to create an Open event for a report.
Suggestions?
Bob
I think I am slooooowwwly getting there. I believe I can refer to the report object (not open) via this code:
Set rptcurr = CurrentProject.AllReports("test")
Still stumped to get access to the module object that is part of the report object.
I also understand that there is one module in the report object and you can get various properties to parse the various procedures (functions, subprograms, etc) within it. If I am creating the only procedure in the module, that might be pretty easy.
Bob
Bob
OK. I have the following code which creates the procedure in the report
module. But I end up with the VBA window open for the report module and
the report is still open in design mode. How do I automatically close them?
Function createrptmodule()
Dim strcode As String
Dim modulecur As Module
Dim rptcur As Report
DoCmd.OpenReport "test", acDesign, , , acHidden
Set rptcur = Reports![test]
Set modulecur = Reports![test].Module
Dim lngreturn As Long
lngreturn = modulecur.CreateEventProc("open", "report")
strcode = "' call whatever"
modulecur.InsertLines lngreturn + 1, strcode
Set modulecur = Nothing
DoCmd.Close acReport, "test", acSaveYes
Set rptcur = Nothing
End Function
When I copy your code, and make a copy a report of mine and call that
copy "test", your code works swimmingly if I add this line:
Set rptcur = Nothing
*****
Application.VBE.MainWindow.Visible = False
*****
End Function
I haven't checked this a lot but I haven't noticed any bad things
happening after running it a few times.
Are you sure the Report is still open? If you've closed it and not
received an error message then it must be closed?
I think the line of code I posted will not work in Access less than
2000.
Lyle Fairfield wrote: When I copy your code, and make a copy a report of mine and call that copy "test", your code works swimmingly if I add this line:
Set rptcur = Nothing ***** Application.VBE.MainWindow.Visible = False ***** End Function
I haven't checked this a lot but I haven't noticed any bad things happening after running it a few times.
Are you sure the Report is still open? If you've closed it and not received an error message then it must be closed?
I think the line of code I posted will not work in Access less than 2000.
Thanks. I also found that I needed to add that line to close the VBA
window.
I also added some logic to check for a report without any modules and to
set hasmodules=yes. That should be necessary in the situation I
anticipate. My final code is:
Function CreateRptModule()
Dim strcode As String
Dim modulecur As Module
Dim rptcur As Report
Dim lngreturn As Long
DoCmd.OpenReport "test", acDesign, , , acHidden
Set rptcur = Reports![test]
If Not rptcur.HasModule Then
rptcur.HasModule = True
Set modulecur = Reports![test].Module
lngreturn = modulecur.CreateEventProc("open", "report")
strcode = "' call whatever"
modulecur.InsertLines lngreturn + 1, strcode
End If
DoCmd.Close acModule, "Report_test", acSaveYes
DoCmd.Close acModule, "module2", acSaveYes
Set modulecur = Nothing
DoCmd.Close acReport, "test", acSaveYes
Set rptcur = Nothing
' close visual basic window
Application.VBE.MainWindow.Visible = False
End Function This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Alex |
last post by:
Subject: Looking for an XML (database-based) Query Reporting
Tool/advice
First off, let me apologize if this thread is somewhat off topic...
PLEASE REPLY TO: xml@solex-bi.com
I am looking...
|
by: Wayne Wengert |
last post by:
I am using VSNET 2003, VB.NET and ASP.NET with an SQL Server 2000 as the
database. I've used Crystal Reports for several years, mostly using RDC in
VB6 and/or standalone reports that used Access as...
|
by: Fabian von Romberg |
last post by:
Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000
PRO and the other one is WIN 2000 ADV. SERVER. When I try to access a
report using the webbrowser, I get the following...
|
by: P Jones |
last post by:
Hi,
I support an enterprise web application (IE client) built in VB6, with about
200 classes, serving about 7000 users, running on 3 clustered servers. I
need to incorporate web reporting for...
|
by: Bob |
last post by:
I want to dump Crystal, one of the many reasons being that it requires a
client-side installation. I'm looking for a reporting package that
integrates into DotNet yet has absolutely no COM in it,...
|
by: Marc G. Fournier |
last post by:
G'day all ...
With the growing # of subscribers to the lists, as well as growing list
activity, ppl are reporting a slowdown in the speed that mail is being
processed through from sender to...
|
by: antonyliu2002 |
last post by:
I am looking for a free reporting package for .net 2.0 against Oracle
database 10g.
The web application I am working on will let office staff members who
don't know much about database generate...
|
by: AMDRIT |
last post by:
I am looking for better concrete examples, as I am a bit dense, on design
patterns that facilitate my goals. I have been out to the code project,
planet source code, and microsoft's patterns and...
|
by: =?Utf-8?B?Umljaw==?= |
last post by:
The following code is diaplaying a blank report; how do I fix it?
private void Form1_Load(object sender, EventArgs e)
{
LoadReport();
}
public void LoadReport()
{...
|
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
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |