Web Reports Parameters

[Jacob438]

I have created web reports using Crystal Reports 8.5. I have some parameters that can accept multiple values and I have the default choices set list populated from a SQL database field. Everything works as it should when I run it from within Crystal Reports.

However, when I run the report from the web, all of the parameter fields that can accept multiple values automatically have the first value in the list selected and in the added list box. It is a pain to have to remove that everytime before I add the values I want to report on. What's going on here? How do I fix it?

Thanks in advance,

Jacob438

 

[synapsevampire]

What do you mean by reports on the WEB, is this Crystal Enterprise?

I often approach multiple parms by making the first selection "All", which I then code for in the record selection criteria.

This shows the users in a friendly way how to get everything, and then I just do a check for "All" in the record selection criteria.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Jacob438]

Yeah, I guess it is Crystal Enterprise (I'm still bitter that it's separate now, back with CR7 you could access reports from the web without an additional program). Anyways, I have an all value, I use "*", and since it queries from SQL it will return all records.

However, here is my problem. I have a list of values stored in the "pick list" as Crystal reports calls it. When the user gets prompted for the value, the first item in the pick list isn't in the pick list section, it's in the selected items section. It's confusing, but just remember that when crystal reports uses a pick list and you can select multiple values, it has two list boxes, one to pick the values from, and another where the picked items go. So my problem is that the first one is automatically in the selected box even though the user didn't select it.

Am I making sense? Sorry this is just kind of difficult to explain since CR is a pain. I swear I hate this thing sometimes.

Thanks in advance,

Jacob438

 

[Jacob438]

I don't know if there is a way to include attachments here, so I'm going to try this, please bear with me. Here's what it looks like, then maybe you can see what I'm talking about:


Select Product Type. Input * for all.
Please enter a string value.
-------------------------------------------
Value:
_______________ ______
|Product B |\/| |Select|
--------------------- --------

--------------------------------------------------------
Selected Values:
_________________________ ________
|Product A | |Remove|
| | -----------
| |
| |
------------------------------------

---------------------------------------------------------


As you can see, when the user is first prompted for this parameter (Product Type), Product A (what would be the first item in the Value dropdown list) is already in the Selected Values list. Although the user didn't put it there.

By the way... the above "graphic" was much hard to make than it looks, the post isn't WYSIWYG.

Thanks in advance,

Jacob438

 

[kenhamady]

CRv8.5 has several options for web deployment. Not all require Enterprise. Read the list of options in the article below and confirm which one you have so that we don't spin our wheels.

It sounds to me like you are using ASP, Not CE, and that the ASP code on the page is moving the value into the default box. But this is just a guess. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Jacob438]

Well, what I'm doing is kind of a mix of a few. I've read the article about deployment methods, and here's what I'm doing.

I have Crystal Enterprise 8 installed on the "server". Instead of using their "new" interface they created, I am accessing reports like you could do in CR7. On the server, I have HTML page with a link to the report like this...


<A HREF='cases_opened_daily_wkly_product.rpt?apsuser=Administrator&apspassword=&aspauthtype=secEnterprise&user0=report&password0=report'>Cases Opened by Product</A>

So I automatically pass the APS info since I don't want the end user to have to deal with that. Basically, I want the end users not to really notice a significant difference when we upgrade from CR7 to CE8, the main functionality we are trying to gain is multiple value parameters. I believe it opens the report up with an ActiveX control. So I am using the fact that CE is installed on the server to open the report in a URL.

Let me know if you need more info, thanks man,

Jacob438

 

[Jacob438]

anyone have any cool ideas here?

Thanks again,

Jacob438

 

[kenhamady]

So you are doing &quot;unmanaged&quot; reports using CE. This is essentially the same as the WCS in v7.

This sounds like a bug. Have you searched the CD KB to see if it is a known issue? If you register the product you can get a few free tech support calls, and they might be able to tell you if this is bug or not. I can't imagine that this is the intended behavior. Does this happen with all of these reports? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[KhushiRaina]

Hi all,

About multiple parameters having default value, even i faced this problem while running from Seagate Info. So what i have done is like what synaps said add 'ALL' parameter and then evaluate for 'All' in record selection criteria.
Before you choose picklist or from table just insert text 'ALL' and then choose the picklist.So everytime you run the report the default value wld be 'ALL'.
So you need not remove this value everytime.

Khushi.

 

[Jacob438]

Yeah, unmanaged reports, that's what it's called. I had that on the tip of my tongue! Ok, cool, I'll look around on their support site and see what I can find.

I don't think I understand what you guys mean by ALL. What I have is a &quot;*&quot; that I use to symbolize all records. So if I want to see how many bugs were found my everyone, I would select &quot;*&quot; from the picklist. But if I wanted to know how many were found by userA and userB, then I have to first remove the &quot;*&quot; and then add userA and userB, you know what I'm saying?

Please clarify this for me, thanks for the great replies!

Jacob438