ASP and Crystal report

Hi

Can u please help me out in this problem. Thanking u in advanced.

Development Environament:
I am using Crystal Report 9.0 Professional edition, I have IIS (v5.1) and Intenet Explorer (v6.0) install on my machine.

Problem:
I have downloaded the sample from crystal report site for crystal report 9.0 version but it is not working at all, it is just displaying the gray shade frame in the browser whenever i try to run the asp page. Why?
I read somewhere that i need to have Developer ot Enterprise edition beacause Professional edition does not support Web report and RDC. Is it so?
If not then can u just help me out in this? Can u give me the steps that i might have to carry in setting up the IIS server and Internet Explorer?

Thanking u again.

Bye
BhalchandraHi,

I'm using CR Profession Edition 9.2. Used the same example given in their web site. I used SmartViewer ActiveX Viewer in my asp page. Initially I got the same problem as yours.

Then only I knew that, if your client machine already having crviewer9.dll, then the report won't display. So try with a machine where this file is not already registered. Ohterwise unregister crviewer9.dll then try again.

Hope this will work.

Try to visit this page, contains some troubleshooting guide.Click Here (http://support.businessobjects.com/communityCS/TechnicalPapers/cr_troubleshooting_activex_viewer.pdf.asp)

ask help for licence problem

I am using asp and crystal report to create a report on web.

However, due to the licence problem, I need to clear the user's login session info each time after they access the report.

The probelm, when user returns to other page, since the session info is clear, user needs to login again.

Can anyone help me to solve this problem? Thanks a lot!It seems problem in Session valriable. Increase the lifetime of session

Array manipulation

Hey all

I have a crystal report
I have a field in the database in table "1" that is a clob and stores codes separated by commas (e.g "1,343,4546,57657,67567,767,")

Then I have table "2" that has multiple records with the codes above in separate records
(e.g.
record 1 = 2
record 2 - 343
)

But not all codes are necessarily in table 2

So i want to separate the codes and show the ones that are not in table 2 as opposed to table 1

I created a formula field that has some manipulation
----------------
StringVar suppCodes:={table1.field(clob)};
stringvar array sort;
sort:=split(suppCodes, ",");

stringVar notresponded := "";
stringVar notr = "";

numberVar i ;

for i:=1 to ubound(sort) do(
if {table2.field} <> sort[i] then
notresponded := notresponded + " " + {table2.field}
)
------------------

But it is returning True and not the string notresponded

I want it to show me the string notresponded

Please someone helpSpot the difference:

stringVar notr = "";

stringVar notr := "";|||Didnt work cos I already dont use that var|||OK, then make it return notresponded, e.g.

for i:=1 to ubound(sort) do(
if {table2.field} <> sort[i] then
notresponded := notresponded + " " + {table2.field}
);

notresponded

Note the semicolon after the )
Should still fix the assignment though :)

array

hi,
I am having problem with inserting the progress data
to crystal report.
I am using Progress Database with Merant Progress SQL
driver. In my db, I have a table with a field defined
as extent 5.
it has the following values: 12 23 345 12 23. When I
place the field on the crystal report it displays
"12233451223". How am I suppose to make CR to display
every value seperately.
thanks in advance.

fatihadd command in the CR like this

select
( "PUB"."salesrep"."RepName" ) As Name,
( "PUB"."salesrep"."Region" ) As Region,
( PRO_ELEMENT("PUB"."salesrep"."MonthQuota",1,1) ) As January,
( PRO_ELEMENT("PUB"."salesrep"."MonthQuota",2,2) ) As February
FROM "PUB"."salesrep"

and than in the CR design drop field

name region January February

thanks all