Customization and Integration

[parry2k]

Hi,

I created one crystal report which uses command to extract the data from multiple table. When I preview the report in crystal it works like a charm but thru MAS 500 desktop it doesn't show any thing.

I used customreporttemplate.rpt to create the custom report.

At the same time I made another test report to list a table and it worked fine thru MAS 500 Desktop.

So using command in  crystal report  has something to do that  MAS 500  is not display the data.

Any idea?

thanks,

p 

[markp]

I have this same issue.  Has there been any resolution to it?

It would be great to be able to use the command feature in Crystal Reports and run it from the MAS desktop. but for some reason it just doesn't like that.

[JohnHanrahan]

I also tried the same thing and was unable to get it to run.  I ended up creating a program which builds the data I need then I call the report.  This is a fair amount of work.

John

[mateusstock]

I've had the same problem!

The report would run perfectly on Crystal Report, but not when I ran from the MAS500 menu.

In my case I turned the SQL query into a View and rebuilt the report from that view.

Just one of those CR things...

[markp]

My 3rd party provider gave me a great solution for this.

Basically all that needs to be done is to turn the select statement into a view with the command (in either the management studio or query analyzer programs):

Create View *NewViewName* as

*Insert complete select without an order by clause*

Then you use that view as your table in Crystal Reports.  I had to close Crystal Reports and re-open it before the new view was selectable.