Crystal Report - 'All' question
Hello Babu,
hoping this is an easy one - I am really new and I have a report that I need to have the user choose multiple elements or 'all' elements for the sort - I have the multiple element working but I am not sure how to get the 'al'' working...
example:
database holds element COLOR - values: blue, red, yellow, green, orange..
I want the user be able to pick 1 value, multiple values, OR I would like them to be able to pick 'ALL' and I would like ALL by default (so it picks ALL colors)...
I hope this makes sense :)
Thanks !
Jennifer
Crystal Report performance
How to Improve Crystal Report performance ?
For simple report it took 1-2 minutes to show report.
DNS-Less connection-Crystal Report Viewer
I have upgrade to crystal reports 8.5 to take advantage of the Active Data Driver/Reporting. Problem, the documentation states that a System DNS connection must be created. I have been successful in creating and connection to a report. However I would like to create a DNS-Less Connection. Any clues on how to connect to the Crystal Report Viewer using a DNS-Less Connection?:D
Parameter passing to crystal report from vb Form
Hi every one ,
I am trying to pass parameter to crystal report 8.0 from VB6.0 form .
But it is giving problem .
I have written following code
CrystalReport1.ParameterFields(Todate) = CDate(DTPicker2.Value)
CrystalReport1.ParameterFields(PaymentType) =CStrCombo1.Text)
it is okay up to this level but when i tryed to give action to crystalreport1 as
CrystalReport1.action = 1
then it is giving problem .
can any boody tell me why i am getting problem .
Thanks in advance .
Suyog
Using CR objects from a module in Access
Hello,
I'm new to this group, so sorry if I'm a little slow off the blocks.
I'm creating a crystal report object in an Access module, that is
using a report already created using the standard version of Crystal
(version 9).
Everything is ok, except when I password protect the database, and
subsequently update the tables in the database connection dialog in
the Crystal Report, I can no longer create the object in the Access
module....
perhaps I need to be using something like .logonserver or such
like.....but I suspect this uses DLLs that aren't available with the
standard version of Crystal Reports.
any info much appreciated
Tim
Parameter to Crystal Reports
Greetings Babu,
I am using a dataset that consists of a SQL Server Stored procedure with a parameter, I would like to have a bottun on a windows form in my C# app that the user would press to pass in a param, do you know how I can pass in a param to my crystal report? EVerytime I add a param, and run my app, this dialog box pops up and asks for the parameter, i don't want this to happen because I want my text field to take care of passing hte param in? Could you provide any advice?
Thanks!!!
The TreeofWoe
Not all the records ......
Hi,
I am having a problem with a report for a table in a Access DB. I am filling this table with 3 - 5 records from a VB program and after that I display the report (crystal report 7.0). The problem is that not all the records are displayed. I have to wait about 5 sec and after that to make a refresh. After that everything is OK. Some times there is nothing displayed, some times there are displayed only some records. It is very rare that all the records displays since the first display.
PLS, anyone helps me.
All the best,
Eri.
Re: Crystal Report - 'All' question
Jennifer,
Create a parameter called color, check the multiple value box, then click the set default values box. Add the values you want to choose from i.e. Red, blue etc.... Then type in "All" and add that. Make sure "All" is at the top of the list.
Then go into "Select expert" and create the formula below
if {?Color}= "All" then {Your . Field} like "*" else {Your . Field}={?Color}
Replace "Your . Field" with the appropriate database field
You will still have to click add for "All" when selecting, but it will be up by default.
Hope that helps,
Mike
Quote:
Originally posted by Jenreb1
Hello Babu,
hoping this is an easy one - I am really new and I have a report that I need to have the user choose multiple elements or 'all' elements for the sort - I have the multiple element working but I am not sure how to get the 'al'' working...
example:
database holds element COLOR - values: blue, red, yellow, green, orange..
I want the user be able to pick 1 value, multiple values, OR I would like them to be able to pick 'ALL' and I would like ALL by default (so it picks ALL colors)...
I hope this makes sense :)
Thanks !
Jennifer