Hi,
Hope I've posted to the right groups.
I'm trying create a Crystal Report for the first time using C# (novice
at that as well). The CR I can handel. What I want to do is to have a
whole bunch of fields in my application (winforms) which the user can
select to include in the report or not.
I believe I can use the CR Engine to change the report at runtime. Here
is my problem. If there's 20 items the user can select to include in
the report, for argument sake, in the report header. You would need to
put all 20 items in the report header section. Even though you could at
runtime show/hide what is displayed, the space each one takes is the
same, and so if the user selects 1 or 2 items, then they will display,
but the other 18 or 19 items would simply be blank spaces.
I want to allow the user be able to select data, and charts/graphs, so
they fully customize the report, but can't think of a way around the
spacing issue. Can this be done in the built in version of CR? Is there
another reporting package which is better suited to what I want to do?
I would've thought that this would be quite a common request. Allowing
the user to customize the report before generating it.
Thanks in advanced.
Puunda 3 1829
There are always other options. But lets answer the question at hand, and
make no mistake I am not a CR expert and I don't like CR.
You would like to allow the user to specify 1:20 data elements to be
displayed. That tells me you will need 40 formula fields, and 20 paramater
fields.
20 Paramater fields state what data elements are turned on, simple a
boolean.
20 for the headers, 20 for the data. Conditionally, these will look at the
paramaters and display the appropriate values or blanks. This allows you to
be dynamic.
I hope that was clear.
As to other solutions. The simplest would be HTML output using XML and CSS
stylesheets, this would allow for totals and such, barring that, CSV files
that populate excel or 123 would work as well. Of course if you have it
available, I would say that Access make an excellent reporting tool.
<pu****@gmail.c om> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com... Hi,
Hope I've posted to the right groups.
I'm trying create a Crystal Report for the first time using C# (novice at that as well). The CR I can handel. What I want to do is to have a whole bunch of fields in my application (winforms) which the user can select to include in the report or not.
I believe I can use the CR Engine to change the report at runtime. Here is my problem. If there's 20 items the user can select to include in the report, for argument sake, in the report header. You would need to put all 20 items in the report header section. Even though you could at runtime show/hide what is displayed, the space each one takes is the same, and so if the user selects 1 or 2 items, then they will display, but the other 18 or 19 items would simply be blank spaces.
I want to allow the user be able to select data, and charts/graphs, so they fully customize the report, but can't think of a way around the spacing issue. Can this be done in the built in version of CR? Is there another reporting package which is better suited to what I want to do?
I would've thought that this would be quite a common request. Allowing the user to customize the report before generating it.
Thanks in advanced.
Puunda
You can embed multiple data items in a text field in CR. CR will then
format the text field appropriately: if some items "disappear" then the
other items will flow leftward to take up the space. As AMDRIT points
out, the best way is to use boolean parameters and formulae within
Crystal: each formula returns the desired data item plus any desired
padding space if the parameter says to turn it "on", and returns an
empty string if the parameter says to turn that data item "off".
The other possibility, for larger data items, is to each one in its own
section, and instruct Crystal to suppress the section if it's blank (in
section options).
Yes, this does limit what you can do in your reports, but then Crystal
isn't really designed to dynamically "flow" report items very well.
Some things which I had forgot to mention were that this report is
designed to be either printed or saved as a pdf then emailed. It also
includes a lot of graphs/chart etc, the the user would also want to be
able to select on creation. Is there a way of accomindating this
feature using CR?
Thanks again,
Puunda This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: rroca |
last post by:
I var a report which is designed to represent a form. The detail rows need
to be seperated by lines. I am recieving mmy data accirately from a SQL
database. The report works fine; however whjen I place the line underneath
the row of fields the fields appear to be blank or covered up. in other
words all or parts of the data seem to disappear. Any ideas???
Thanks
Rick
|
by: Nathan Bloomfield |
last post by:
Does anyone know if there is any documentation which relates to Access2k + ?
or can anyone help adjust the code?
I am having trouble converting the DAO references.
TITLE :INF: How to Create a Dynamic Crosstab Report
PRODUCT :Microsoft Access
PROD/VER:1.00 1.10
OPER/SYS:WINDOWS
|
by: authorking |
last post by:
I had just binded a DataSet obj to a crytstal report obj with the following
code:
crystal_report.setdatasource(DataSet obj);
but how can I make the dataset's selected data field to be displayed in the
report in program run time.
|
by: puunda |
last post by:
Hi,
Hope I've posted to the right groups.
I'm trying create a Crystal Report for the first time using C# (novice
at that as well). The CR I can handel. What I want to do is to have a
whole bunch of fields in my application (winforms) which the user can
select to include in the report or not.
I believe I can use the CR Engine to change the report at runtime. Here
|
by: David Thielen |
last post by:
Hi;
My ASP.NET app (C# calling J# under .net 2.0) creates a png file in a
subdirectory to display as part of the created page. However, the bitmap will
not display due to a security violation.
Everything is the default settings I believe. IIS is running under Local
System. In IIS the DefaultAppPool is running under Network Service.
Annonymous access uses the account IUSR_JASMINE (machine name is Jasmine).
| |
by: sklett |
last post by:
I've developed an ERP application that we use internally and works quite
well. I receiving more and more requests from users to print various
transactions, order forms, search results, etc. I haven't decided what the
best way to do this is because I don't have much experience with generating
printable forms.
Early on I knew one of my modules would need to print a clear report so I
used the open source SharpPDF library to generate the...
|
by: veaux |
last post by:
Adobe has WAY to many forums and I wasn't sure which was correct so
thought I'd try here first. I'm trying to see if there is a product
that will allow us to create a large (1,100 pg) directory, similar to
creating one with MS Word. We have Access tables and want to create a
healthcare provider directory. Table has ~30,000 records. We'd also
want to create a master index and TOC.
We want to set this up so each time we update the...
|
by: sapsy |
last post by:
How can i extract report sql from my Crystal report using c#
Thanks
Rohit
|
by: ofilha |
last post by:
I have created a report in design mode. However, some of the fields i need are dynamic. That is, i have a series of fields text boxes mostly that must show up only as needed. I also have some labels that also should dynamic depending on the text boxes. I first tried createReportcontrol during the OnOpen event for the report,and when i tried to run it, it would give me an error 2147, that i must be in design view in order to create or delete...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
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: 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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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.
| |