Search results for query: *

Hi - when I schedule a report for an email Alert with a hyperlink, I only receive a hyperlink if the format is 'Crystal' but not other file formats such as excel, text, etc. If i schedule a Crystal report from enterprise and want a hyperlink, with a format of excel, it works fine. Anyone know...

I am new to using arrays and I am first trying to understand their practical application. I understand them to be data lists that can often be used in place of subreports for improved processing. 95% of the reports I build use SQl command objects. I can’t seem to build an array on data elements...

Thanks for the reply. To clarify using you're example of NY or states. If I set row level security on state and have 1 user with rights to only see, say, New England states. No problem so far. Now, when someone schedules a report (someone with ALL Data Access) that has parameters/prompts won't...

Hi - I have set-up a report and associated BVs so that a super user can schedule it and then based on the BV filter on current CE User Name and db field, each person sees their own data. Ok. The problem/question i have is on how to implement a user prompt into this model as well. Example...

Using CRXI and BOE XI. We have reports with a record selection formula. If a user has schedule rights in enterprise, they are able to change this formula. Is there a way to prevent this while still giving schedule rights? thanks

Hi - Using CRXI and BOE XI. we have reports with 3 dynamic/cascading prompts. The first prompt is based on 'ceuserid' which drives parameter lists for the other 2 prompts. The data changes frequently. My questions: 1. how can we schedule a recurring report while also picking up the most recent...

HI - Using BOEXI and CRXI. We have a large report with a Group on Supplier with their specific information (of course). We can easily distribute this entire report to email adresses, but is there any way to distribute only the relevant report part (grouped on data) to each supplier. Bascially...

Hi- We are trying to achieve row level security which exists in our database, though through a somewhat unorthodox method. I do not have experience with using stored procedures and had a question or two. Basically what we need to do is pass several parameters back to the database, in sort of...

I have 1 group in the Main report already on, let’s say, region. And then 1 customer group in the subreport. The subreport is in the report header. Naith – I’m not sure if I need a subreport either…But either way I’d like to know how to accomplish this since it comes up frequently. I have...

This should be easy for you pros, but giving me trouble…using CR10 Main report - a) need a subreport that displays all customers with count of products that b) when clicked on takes you to the (subreport) detail of that sale. I have accomplished, obviously, creating the main report and basic...

Using v10 I have an unlinked subreport chart within a Main report (chart lies within the subreport Header and main report header underplayed to accommodate for data). When I click on the subreport chart (based on groups) it takes me to the exact same view of the chart rather than the drill down...

Hi - Newbie here I am working with subreports ok but need some help. How can I link the summary data to a subreport? For example: Jan Feb Cust1 10 12 Cust2 8 9 Numbers=count of orders How do you link the (count of orders) in the x-tab to drill-down to the detail level, I was...