How to invoke Crystal Parameters in the web?

[ReportingAnalyst]

I am using ASP and CR 8.5

I pass 2 parameters from the web. Additionaly I want the Crystal Parameters Dialog box which we see within the software on the web page to prompt the other 2 paramters.

How can I achieve this?

Thanks.

 

[Turkbear]

Hi,
Usually,any non-supplied parameter will trigger a Prompt for the missing ones from the report - what behavior are you seeing?








To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ReportingAnalyst]

Hi,

I pass 2 parameters from ASP to CR 8.5 However there are 2 more parameters that should be taken by Crystal to view the reports.

When I select this report, the 2 ASP parameters are being passed, the report opens up with no data and no parameter dialog box of Crystal pops up.

How can I invoke this parameter box of Crystal.

Thanks.

 

[ReportingAnalyst]

Any ideas on this?

 

[ReportingAnalyst]

However when I run this report directly by typig the URL (

http://....salesranking2006.rpt),

then I am prompted to download the Crystal Dialog which I do, then I get prompted for the Crystal Paramters.

But when I try to click on this report through the ASP page, then I am not prompted with any data, neither any Crystal Reports Parameters Dialog.

Any ideas...

 

[ReportingAnalyst]

I even removed all the dll files from the physical directory of the client machine. (Sys32)

Then I registered all the dll and Active X Control back in the registry. Rebooted my machine.

Following files:

swebrs.dll
xqviewer.dll
crviewer.dll
cselexpt.ocx
reportparameterdialog.dll
sviewhlp.dll

were registered.

But still the parameterrized report does not show with the Crystal Parameter Dialog.

Please do give any input on this - where I can look into again.

Thanks.

 

[ReportingAnalyst]

I am just giving you more information so that it is easier to think about a solution for parameterized reports not popping up the remaining parameters.

In the web server, in the registry,

only crviewer.dll is registered.

In the Internet Services Manager Console where we can see the Default Web Site Directory, there is a virtual link pointing to the Program Files\Seagate Software\Viewers\SmartViewerActiveX folder.

Anything more you could suggest for this report to work.

 

[PatrickIRL]

See GJParker's reply in thread768-857134

Hope this helps,

Patrick

 

[ReportingAnalyst]

Hi,

I was using the ASP sample file for Crystal 8.5 I noticed in the AlwaysRequiredSteps.asp, there were 3 lines:

session("oRpt").MorePrintEngineErrorMessages = False
'session("oRpt").EnableParameterPrompting = False 'the line that came with the Sample ASP code.
session("oRpt").EnableParameterPrompting = True
session("oRpt").DiscardSavedData

I changed the EnableParameterPrompting to true.

However I see that the reports where the Crystal should prompt for the paramters ( I also pass 2 parameters), is taking so long....I do not see the report. IE status bar still shows that blue bar expanding...So I do not know if that line will help me or not.

My report does not used any stored procedure. It has a simple SQL query with joins.

This report works fine with the Perl Script. I am migrating the web application to ASP based application.

Any ideas.

Please anybody with this situation....please give your input.

Thanks.