Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reporting from IIS logs

Status
Not open for further replies.

tful282

Programmer
Jun 26, 2001
42
US
I am using Crystal Reports and Enterprise 8.5 running on a windows 2000 server on IIS. The CR documentation makes reference to a way of reporting from the IIS logs under the heading 'Web/IIS log files'.
It basically says that CR provides translation from the log files using a dll p2smsiis.dll - however after scouring the web for other documentation and attempting to locate and use this dll from both the server and my machine I am at a loss.
I am looking for a way to report on our usage of eportfolio.
Does anyone have any experience with this or suggestions?
Thanks.
 
CE does do some logging itself, check the Web Component Server in the CMC to learn where it's writing information.

If you have static IP's, you can backtrack and get specifics.

Here are a couple of good threads on this:

thread782-749485
thread782-294520

Someone had some code for pulling from the APS database but I can't find the thread now.

-k
 
It's an option under the "More Data Sources" in CR 8.5.

I use a Crystal report to track web hits using my IIS log files and can confirm it is not only doable, but easy :eek:)

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Ido, that's good to hear!
What type of connection are you using- under my 'More Data Sources' choices i do not see any choices that seem to relate to IIS or logs, and I do not find the 'p2smsiis.dll' anywhere in my file system.
Any suggestions?
Thanks.
 
I had to reinstall crystal (full version option) and it magically appeared!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top