Allowing Report users to modify parameters

[nervous2]

I have created a stock report for my company. Our products are categorized by product then batch # the batch number represents the day it was made (year and month) but it is a code system which we have created internally.

Eg 4D728 = (4)stands for 2004 D represents abcD=4th letter = jan, feb, march, APRIL the D represents the month of APRIL

Eg 5H5300 = (5) stands for 2005 H represents abcdefgH=8th Letter of the alphabet= 8 month
jan, feb, march, april, may, june, july, AUGUST

I need the user of the report to specify the date range as a parameter if I use the "report expert" built into the crystal and publish the app then the user has the ability to select a range but the range isn't in proper order, is there away I can have the user be able to select does not start with letter, instead of me embedding it into the report and not allowing them to alter it?

 

[synapsevampire]

Please post your software version.

"to select a range but the range isn't in proper order" doesn't state what is wrong, what order are you expecting, and if it's just a single date parameter as you state, it can't be in the worng order, please be specific abotu your problem.

I suggest that you stop using the select expert, and use the Report->Selection Formula->Record

Then the record selection should look something like:

{table.date} = {?MyDateParameter}
and
{table.value} = {?MyValueParameter}

As for the order of the parameters, right click a parameter in the field explorere and select set parameter order.

-k

 

[tahseenm]

I would like to get some information on my crystal report I created. I would like to put this report on a server so that other users can access it remotely. Also I want to setup permissions so that they could use the parameters but cannot change the design or edit. Can you let me know the easy steps to setup permission for the users so that they could use the report and the same time we protect the design. Thanks and appreciate your quick response.

 

[nervous2]

I run Crystal reports 8 with the obsolete (report distribution addon)this lets users click on the icon it give them parameters (if setup) then the report loads. You need to install this on each workstation and setup the report, but we use Citrix here at the office so I just published to report to the one computer then distributed the report to the users. This isn't the best way to handle reports but it works I think the new crystal enterprise will do what you are looking for (over the net) but I'm sure there is a hosting fee.

 

[nervous2]

synapsevampire thanks for the response.

I'm using crystal report v 8, when I say the range isn't displaying properly I mean if I do a select expert "between" it groups or lists the parameters in alphabetical order and some of our products will not follow suit, therefore this isn't a good option for me to use.

We when I use the Report->Selection Formula->Record

I am a little confused as to how I enter the data, a window opens with a formula that i already in place (a select expert parameter which I have use on another area of the report) when I create a new formula I am not sure what formula to enter I entered (exact) what you had posted hoping to change
only the field record to make formula work but I am struggling to understand how what this means and how the record selection works, if you have time can you please elaborate on this..
Thanks Appreciate it.
>>
>>
{table.date} = {?MyDateParameter}
and
{table.value} = {?MyValueParameter}

As for the order of the parameters, right click a parameter in the field explorere and select set parameter order.

 

[lbass]

Create a formula {@yearmo}:

numbervar yr := val(left({table.batchno},1))+2000;
numbervar mo;

mo :=
(
select mid({table.batchno},2,1)
case "A" : 1
case "B" : 2
case "C" : 3
case "D" : 4
case "E" : 5
case "F" : 6
case "G" : 7
case "H" : 8
case "I" : 9
case "J" : 10
case "K" : 11
case "L" : 12
);
date(yr,mo,1)

Then add this to your record selection formula (report->selection formula->record:

and
{@yearmo} = {?daterange}

...where {?daterange} is a date parameter that you have set up that allows range values, but not discrete values.

-LB