I have, at one point in time, been a pretty good programmer, but
that was years ago. I can pass programming classes with and A with no
problem, but writting a business class application is a bit of a
struggle. I am relitively new to .NET and C#, but do have pretty strong
background in computers and general programming concepts.
Now to my question. I have to create an app that will pull data from
a database and create a report. This report will have many rows and
five columns. The columns are for four quarters and afifth column is
for a YTD total. You would think that the YTD would be the sum of the
other four columns, but it it not. On a per row basis, the five columns
will be calculated the same way - they will run a query for the data it
is looking for with a start date and an end date to match the time
frame of the column. So, Q1 will be from July 1 to Sept 30; Q2 will be
from Oct 1 to Dec 31; and so on. The YTD will be calculated with the
same equation, but the start date will be July 1 and the end date will
be June 30. These totals will be counting unique people over the given
time frame. So, due to the fact that the YTD column will also be for
unique people over the whole year, it may have a different count than
adding the four quarters totals. Each row will have a different set of
data it is counting, but almost all of them will be doing tallies this
way. There are a few sections that will require a different number of
colums and different calcualtions.
The main question is what should I use to create this report? Is
this more complex than can be done with the Crystal Reports engine
included in VS2003? Can the full version of Crystal Reports do this?
Should I try to use something like Excel? I'm just not sure what method
to use to try to get this report made. We have a short term goal of
giving this report to a "parent" organization that currently receives
this in Excel format, but the longer term goal is to give them an
application that can pull the data from out SQL servers and give them
the report in realtime. The Crystal Reports engine can export the
report in Excel format if I understand it correctly.
Trying to print manually from Windows and .NET seem like a major
pain. From my very limited knowledge of Crystal Reports, I just don't
know if it can do a report like this or not. I'm not sure about using
Excel directly. I have never written an application that would
integrate with an outside app like Excel to create anything, so I don't
know if this is too hard or if maybe this is a good option. I am also
trying to keep this a "profession al" app, so I am kindof resistant to
doing something that would require the use of Excel to generate a
report. This just feels hokey. Because of this I lean towards the
Crystal Reports engine, but if it can't do this, then I have to do
something else.
As much advice as possible would be greatly appreciated!
Thank you in advance!
7  1429 
"AMeador" <am******@tampa bay.rr.com> ha scritto nel messaggio
news:11******** **************@ o13g2000cwo.goo glegroups.com.. . The main question is what should I use to create this report?
Trying to print manually from Windows and .NET seem like a major
pain. From my very limited knowledge of Crystal Reports, I just don't
know if it can do a report like this or not.
I don't think that this could be of some utility to you, but for all the
people that don't need something special in theirs reports and want a report
designer/engine really simple to use (and not with dozen of undeciphrable
options) I'd like to suggest my solution at www.neodatatype.net :)
--
Reporting tool: http://www.neodatatype.net
I agree, so I wrote a framework with printable controls. Basically, it
lets you build WinForms with drag and drop controls that just print
themselves. Just drag, drop and print. I am suprised that there is not a
lot of interest in this approach in C#.
Regards,
Jeff
Trying to print manually from Windows and .NET seem like a major pain.
*** Sent via Developersdex http://www.developersdex.com ***
I will keep an eye on this, but I really need to go with a more
tried and true method right now. This project is the first project that
we are doing for a state agency that kind-of has an almost oversite
type position over our organization - so I really need this to work
well. I think my CIO would laugh at me at this point if I suggested
useing a small, 3rd party, beta version of something to generate
reports. But, I have not gotten very far on this at this point and like
you said, it seems like the Crystal Reports engine is a little monster.
Its very confusing to me at this point. I hope your product continues
and manages to stay simple - maybe we will look at it on future
projects.
As far as my question above goes, can Crystal Reports engine (or
full version) do the kind of report I described?
Thanks for the input.
How would this work to print the report? You would just use these
contols for each place where a data field would be and then manually
print the whole form? It seems like Crystal Reports engine wants a
header, footer, and a single record structure to be repeated over and
over in the body. One, can Crystal Reports engine do the field by field
method of a report? Two, using your method, how hard would it be to
print the whole report and to export the report to Excel?
A. Meador.... I am used to writing database applications where the input
form
is the report and represents the raw data to be stored in the database
and
represents the search grid for filtering the record set. I have never
used
crystal reports, but suspect it is more designed for creating summaries
on
stored data.
If I wanted to create a summary page, I imagine that I would add a
calculate
button on the form that populates the printable labels based on user
selected criteria and then the user would review the report and then
print the
page. Only the printable labels would appear on the printed page, no
buttons
or standard labels. There is no support for exporting to Excel, but
there is
support for header body footer and page breaks in my little framework
which
basically is a "What You See Is Almost What You Get" approach to
database
forms and printing.
Regards,
Jeff
*** Sent via Developersdex http://www.developersdex.com ***
"AMeador" <am******@tampa bay.rr.com> ha scritto nel messaggio
news:11******** **************@ o13g2000cwo.goo glegroups.com.. . I think my CIO would laugh at me at this point if I suggested
useing a small, 3rd party, beta version of something to generate
reports.
That's right.
I also won't suggest it to you for "critical" applictions.
Also if I must add that in my opinion the Crystal Report is a
beta-monkey-coded report tool ;)
--
Reporting tool: http://www.neodatatype.net
I won't completely disagree with you there - I have seen some pretty
crappy stuff come out of apps using Crystal Reports before, I just
don't know it well enough to know if it was the coder implementing it
wrong, or if Crystal Reports was the culprit, or both!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: ferit meftun harmankaya |
last post by:
I have some report which are designed in "Crystal Report". I want to run
these reports in "Reporting Service"
My aim is to convert from extension of Crystal Report (rpt) to extension of
reporting service (rdl).
Crystal report and Reporting Service are both production of microsoft. i
think that there is a way to solve this
question.
Thanks for your helps
|
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 the first time, so I am interested in
learning what web reporting options are out there, and the pros and cons of
each. In general I need to generate reports with XML documents as inputs,
and make them available to all web users.
I am partial...
|
by: Steve Miller |
last post by:
hello...
i am a 'user' of access, meaning, i import excel files, join, and
merge....that's about the extent of my expertise with ms-access. my
boss wants me to create an access application that will replace our
'excel' version of time reporting. we use ms-access 2000. i have a
huge book (mastering access 2000) though the cd is missing. i looked
at using the wizard for time reporting, but is was designed for
external clients, and the...
|
by: jez123456 |
last post by:
Hi
My users, use ms access for querying and reporting on a backend database,
however they need to replace ms access with a new reporting tool.
I’m thinking of developing my own reporting engine in C# to replace the
existing ms access model.
Are there any c# reporting application samples that I could look at to get
started?
|
by: Woody Splawn |
last post by:
I am asking this question here because I asked this question in the
Reporting Services Newsgroup and did not get an answer. Does anyone know if
Reporting Services is intended to work in a client/Server or Local machine
environment? Based on what I have seen my guess is yes but that is a guess.
In some materal it talks about it running on a web server but my supposition
is that this does not necessarily mean that it would not make for a...
| | |
by: John |
last post by:
Hi
vs2005 rc/sql server 2005 sep ctp. In vs 2005 when I try to add an item
there are two icons 'report' and 'crystal report'. What is the difference
between these two and sql server reporting? What are the pros and cons and
which of these can be use din a vb app?
Thanks
Regards
|
by: Rich |
last post by:
Hello,
In VB2003 I can access Reporting Services by selecting a New Project option
of Business Intelligence Projects. But I don't see an option like that in
VB2005. My question then, is if when using VS2005, you can only use the
Reporting Services that comes with Sql Server 2005.
I have VS2003 and VS2005 on my workstation, and use Sql Server2000 for the
datasource. Am I limited to using only VB2003 in order to get Reporting...
|
by: YellowFin Announcements |
last post by:
Whitepaper: "Yellowfin Reporting" enables Embedded Business
Intelligence
--------------------------------------------------------------------------------
Embedded reports are a standard requirement of most applications. But
users are increasingly demanding more sophisticated reporting from
applications - seeking such features as custom report design, ad hoc
report creation and analytics. Developers that want to embed business...
|
by: yhafeez1 |
last post by:
We are in the process of doing a side by side installation of the SQL
server 2000 and SQL server 2005 on the same server. To install the
Reporting services feature of SQL server 2005 requires IIS. We have a
seperate web server running IIS that connects to the database server.
My question is : can we still install Reporting services on the
database server without the IIS?
Thank you
|
by: Paul Furman |
last post by:
How do I turn off MySQL error reporting? I set error_reporting(0); but
that doesn't seem to be working.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
