URL Reporting Question 1

[checkai]

I have one report working with URL reporting. It accepts 1 parameter of a user ID...However, I am trying to send dates through to a different report and I am getting prompted for the parameters...Not sure if my url format is correct :

http://reports.virchowkrause.net/vi...;&promptex1="Date(2003,7,15,0,0,0)"

 

[pelajhia]

Is your date parameter in crystal should actually be a string, which you then convert in the report to date in the report. At least, that is working ok for me.

 

[checkai]

My only issue with that is, if someone needs to use this in ePortfolio, they'd have to know exactly the format to enter the dates as....can you give me an example of a url that you call?

 

[checkai]

It seems that other reports are not picking up the value as well...I have one that I simply send it year which is a varchar(4) and it looks like it returns the latest instance. Is this because there are parameters set on Enterprise already for this object?

DLC

 

[pelajhia]

Yes, I think you'd have to have a 2nd version of the report for use by humans, but perhaps there is a better way to pass the date...Anyway, this is what we are doing:

http://server/viewrpt.cwr?ID=1473&a...="7"&prompt0="2003/10/15"

 

[checkai]

So then you handle this String with a SP?

Thanks,

dLC

 

[pelajhia]

While I imagine this could certainly be used in a stored procedure, I'm using a 'command' set up in the crystal report, and I feed the string into the oracle to_date() function, like so:

select blah blah
from tablex
where table.date = to_date({?date},'YYYY/MM/DD')

I am doing this also with another parameter that comes through as a string and needs to be converted using to_number.

select blah, blah2
from tablex
where table.id = to_number({?id})

 

[TedLiu]

Hi,

Could you try use "prompt" & number instead of "promptex" & number? That's the format I'm using and works very well.

Hope it helps.

Ted

 

[pelajhia]

TedLui brings up a great point - your original question is on the syntax of the URL and I have been taking you down a different path.
Try checking out this document which should explain exactly where you might be going wrong:

http://www.crystaldecisions.com,

URL Commands for the WEB Component Server.
I did not notice before, but you are using promptex - while I do not see where your use is incorrect, they offer this example:

http://myserver/myvirtualdir/viewrp...omptex-birthdate="Date(2002,02,02)"

 

[pelajhia]

Here is the exact doc path:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/ce8_urlcommands.pdf.asp

 

[checkai]

Thanks, I am using the dates as strings now...it works great!

 

[checkai]

Any feedback on the performance of URL Reporting. Some of the users may be running reports that scan an entire year's worth of timesheet data....Millions of records...

DLC

 

[checkai]

Is it possible to disable the refresh (lightening bolt) while using URL reporting?

dlc

 

[TedLiu]

I think it can be disabled in CMC. I never try it by url reporting.

Hope it helps.

Ted