Report - subreport hiccups

[muffntuf]

Hi,

I have been helping develop several reports (in CR10)that have anywhere from one to 10 subreports (yes I know, yucko)in each.

When we publish out to CE 10 they are requiring us to log in for each subreport.

The subreports are linked subreports.

I know I saw this a couple years ago, but honestly don't remember how it was resolved.

Anyone else seen this?

Thanks,
muffntuf

 

[paulmarr]

You can hardcode the username/password in CE10 so it doesn't ask you to log in - perhaps creating a user that is for Reporting only - a generic one with read only rights.

cheers
paulmarr

 

[muffntuf]

Hi Paul,

Yes but they want to use the JDE security of the underlying database instead of the generic crystal user usually setup.

Any ideas?

Thanks,
muffntuf

By the way where do you teach?

 

[paulmarr]

Hi muffntuf,

I was a Public Trainer in Australia and now for a private company.

I believe in CE10 you still had to develop a processing extension - that would go and check/filter the data based on the users id/password - before bring any data to the report - there is doco on this in the Knowledge Base. (Processing extensions are dll library files that carry out the row level security in the db)

Apparently BOEXI has this facility available without developing processing extentions.

cheers
paulmarr

 

[muffntuf]

Do you remember the document title or something more concrete to search on? You know BO's site is a tad ambiguous.

An Aussie huh, that's great!

Thanks for the tip, I will start looking for something in CE.

muffntuf