Crystal reports8 and web reporting

[morfeus]

Hi,
i'm totally new to crystal reports but have complished some already.. I have problem about web reporting or thats where i encounter it only.
When designing the report everything works just fine. I pass 3 variables for the report and on those basis it shoouuld collect the data. In the designer this works just fine but when the report is tried to seen on the web it just show the hour glass.
The report is passed the DateTime range which alone works fine, but i needed a variable to tell what 'product' to get.
The variable is a string of numbers and the database has varchar. First i thought it was bacause the format is some how converted to something incorrect i placed this:
({REQ_UNIT.REQ_UNIT} = CStr({?laitos})) and
({STUDY.EXAM_DATE} in {?pvm} to {?pvm2})
the cstr is just a desperate attempt and same with the extra '(' and ')', works ok in the crystal viewer/designer whatever. But if viewed with ie&activex viewer it just shows the hour glass and in some point it time outs. No error shown or anything. And if I view the pages source the variables are correct in the vb script.
im totally confused with this one.
--Morfeus

 

[morfeus]

A small addition to this...

if i don't send any parameters but go directly to the .rpt so that it prompts for the values it works fine via web too. So it must be in the {?laitos} parameter.... but can anyone give suggestions what am i doing wrong here ?

 

[dlkraft]

I had difficulty passing more than one parameter to Web Reports 8.

I got hold of Recrystalize Pro, which is a tiny ap that writes calling scripts for reports to show under Web Reports 8.

It sounds like it could help you with your passing of multiple parameters.

Hope this helps.

Dave

BTW, try going to

http://www.recrystallize.com/

 

[morfeus]

Latest invention was to pass one parameter to the .rpt and split and extract the needed values from that. Once again works fine in the designer but when putted to web... looking at hour glass.

 

[morfeus]

webSource0.AddParameter "prompt0", "2001,1,1 0:00am/2001,1,31 11:59pm/40415" when looking at source and this is rigth -> the data what was sended. i'm kinda desperate by now...

I would really apreciate if anyone could point me to something... (other than recrystalize).