Jump to content


Photo
- - - - -

Connection Crystal Report


5 replies to this topic

#1 kmkpatro

kmkpatro

    Newbie

  • Members
  • Pip
  • 2 posts
  • Gender:Male

Posted 11 August 2004 - 10:32 AM

hi all

i am new to PROIV world.

please can anybody guide me how to call a crystal report (.rpt) file from

PRO-IV and SuperLayer.



Thanks And Regards
Murali

#2 Joseph Bove

Joseph Bove

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 756 posts
  • Gender:Male
  • Location:Ramsey, United States

Posted 11 August 2004 - 02:11 PM

Murali,

In 4.6 - you'd want to use a system call:

#STAT = SYSTEM('run_crystal filename.rpt')
Server runs report

or

#STAT = SYSTEM('GUI WINDOWS run_crystal filename.rpt')
Client runs report

In 5.5 you, if it is client based, you can simply do the following:

CLIENT.EXECUTE('filename.rpt')

Due to file associations, it should open in crystal.

hth,

Joseph

#3 kmkpatro

kmkpatro

    Newbie

  • Members
  • Pip
  • 2 posts
  • Gender:Male

Posted 12 August 2004 - 05:43 AM

hi
thanks for helping me.

i tried the code what has been given by you.
but i am getting the clinet version - syntax error
client.execute('invoicelist.rpt')

the other two are not showing the error message but not displaying the report.

how to give the report file path.

i am using crystal V-10 and PROIV-5.5,OS-XP

Thanks
Murali

#4 MarkIV

MarkIV

    Member

  • Members
  • PipPip
  • 10 posts

Posted 12 August 2004 - 12:00 PM

kmkpatro

Try passing the path as your argument.

For example:
client.execute('C:\Reports\invoicelist.rpt')

#5 Guest_gdmjdkc_*

Guest_gdmjdkc_*
  • Guests

Posted 12 August 2004 - 01:41 PM

I have been trying the same type of call to Crystal and have made it work. These reports exist on a local server instead of my C: drive, but the syntax should be the same.

$PATH = '\\servername\folders\'
$REPORT = 'filename.rpt'
#STATUS = CLIENT.EXECUTE($REPORT,,$PATH,'SW_SHOW')

Even though the above works I have an issue with passing parameters to Crystal. I am using VIP 5.5/Crystal V.10/OS XP. What we are wanting to do is pass parameter(s) to a defined Crystal report.

I am fairly new to PROIV and brand new to Crystal. I have attempted to load the Crystal 10 report viewer OCX into VIP but it errors and will not load properly. I had thought that this might be the answer to passing parameters but since I can't get it to load I am not sure. Has any one else had this problem?

Gayle

#6 MarkIV

MarkIV

    Member

  • Members
  • PipPip
  • 10 posts

Posted 12 August 2004 - 02:27 PM

To open a Crystal Report the command must be assigned to a numeric variable, like so.

#X = CLIENT.EXECUTE('C:\proiv50\Reports\chart.rpt')



We have been able to view and refresh Crystal Reports in PROIV by creating an Active control.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users