cyrstal report into asp

Hello friends,
I am a newbie in crystal report - working on 9.2 version i have created a report and would like to view the same in an asp page -
Please if anybody can help me out with this - wanted steps to acheive the same
Thanks in advance
sandyGive a look to -->
http://www.thinkydink.com/crystal.html
This tutorial assumes you already know how to code in ASP and your Crystal and IIS servers are already set up and fully functional.

Cyrstal Report count

Need help. I am new to crystal reports. I have the sql below that would run perfectly fine unders windows SQL 2000 server and give me the results that I needed. But I can't get the correct count from crystal report if I only want each distinct record to shown once.

SELECT TYPE, PART_NUM, COUNT(PART_NUM) AS Expr1
FROM dbo.ITEM
GROUP BY PART_NUM, TYPE

type part_num count

Monitor gx260 20
Monitor gx620 40You might need to use distinct count in Crystal.

GJ

Cyrstal Report and ASP- HEEEEELLLP!

Hello:

I am using ASP and Crystal report. I created a .rpt file on a dev server and I can access the report in pdf format using ASP.

But now I want to implement the same on production server. I copied the .rpt file and changed the database settings. The preview pane shows the new data. But when I call the report from ASP and convert it to pdf I get nothing. Just the report heading and no rows get selected.

I know there is data in the database, and I confirm that the db connection is ok.

Any clues?

Also why do we specify the
Set crtable = session("oRpt").Database.Tables.Item(1)
crtable.SetLogonInfo CStr(databaseServer), CStr(databaseTables), CStr(databaseUser), CStr(databasePassword)

in the ASP, when we have to specify the same credentials in the rpt file as well?

Is is adviced to save the report with data or without?

Your help will be greatly appreciated.
ThanksThe report is not to be saved with that data.If u save the report with the data the data will be not be refreshed each time while opening the report.

Set crtable = session("oRpt").Database.Tables.Item(1)
crtable.SetLogonInfo CStr(databaseServer), CStr(databaseTables), CStr(databaseUser), CStr(databasePassword)

These lines are written so that the report can log on to the data server.|||Hi

Iam going to include a crpt report in our existing asp application.
I dont have any idea to code for how to call and use crpt in asp file.

Pls, any one give me sample codings for the same.
mail id saravanakumar77@.yahoo.com

regards
Saravanakumar.D

Cyrstal Report

Hi,

Nittu here...i am at enty level of crystal reports...i am into support team.

i am facing a problem in most of the reports related to grp by.

viz : i have a table called ward charges...

wardid wardname charges
1 ac room 1950
2 room #1 1400
3 room #2 1400

i need to calculate charges for patient admitted in room#1...
in report since they have groped by wardid...always
1950 is fetched for calculating the ward charges
i want 1400 instead

ward charges = charges * no. of days

same probm i facing in many other places due to grp by..

plz help me hw to sort it out.

from,
nittuIf you are grouping by wardid, then create a formula and place that formula in your group header.

Formula: ({Charges * no.ofdays}) \\ Place this in wardid group header
This will give the calculation for each wardid.

Hope that is what you are after.
GJ

Cyrstal Management Console

Hi

Once I upload my report to Crystal enterprise and i do preview of that report i can see the print button in the crystal tool bar. But once i call the report via query string from my application that print button disappears! Can some one help me with that issue! that how i can get the print button enable for the reports which are being called from query strings!

ThanksCR.EnablePrintButton=True

CR is the Crystal Report Viewer|||Thanks for the reply but.. here is the problem..

I am using URL reporting on Crystal enterprise

http://webserver/crystal/enterprise10/ePortfolio/en/viewrpt.cwr?id=10000&apsuser=user&apspassword=password&apsauthtype=secEnterprise&promptex-CompanyName=ABC Company&promptex-CompanyAddress=123 Main Street&promptex-CompanyCSZ=New Orleans LA

Is there anyway we can pass query string parameter?!

Let me know
Thanks|||I finally found the solution!!
The URL you are utilizing to interface is calling the DHTML viewer which does not include that by default. If you want to utilize the ActiveX viewer, you can try adding the "&init=actx" to the end of your querystring, however depending on how you're interfacing with the report this may or may not work. If it doesn't work (i.e. different .NET interface methods) you will need to change some parameters in the code, which I'm not sure exactly what it is but do a search on support site for the help file for Report Viewers and the full object model is listed there.