Search results for query: *

Im sorry not sure how that would work, could you explain a little bit more about this option.

Is there an easy way to create a report that shows optional fields dependent upon the parameters chosen without hardcoding each field/formula?

I have a report set up to run that basically shows any accounts > 60 days from list date. The client runs it daily & weekly etc... She will run this report and use it as a production type tool for example... she may say i want 25% of these resolved by... etc... The data returned is pretty...

Ok, pretty new to SQL but I have the following.... Tbl columns client class client name username useremail rptnum rptname parametername parametervalue For each report the useremail/parametername can be multiple values so instead of reporting as rows I need them in seperate columns see...

Using Crystal 2008 I have a an Account Analysis Report, it is a complete history of the account, the report has 5 sections all report footers. sec 1 activity summary sec 2 account status sec 3 graph 1 sec 4 graph 2 graph 3 sec 5 graph 4 graph 5 sec 1 is all of the clients history for...

Not sure posting in right area.... apologize if not. Have a rpt that returns the following... Company File # Acct # TT Desc Pl $ System John Hopkins JH05162011 106217 P Success 94.71 CHA-FAC John Hopkins JH05152011 106217 P Success 40.28 CHA-FAC...

In Crystal XI R2 is there a way to suppress the column headings if the crosstab spans multiple pages... I have tried EVERYTHING. See below... if you look down you can see it repeats the dates. 02/01 02/02 02/03 Total Official / Unofficial/ Total 2865 2732 1766 73...

I have 19 reports that get sent to approx 186 different email addresses, each report can go to multiple emails and each email address can receive multiple reports. End result is approximately 7400 monthly instances and 12000 weekly instances. Most of the reports have parameters, some static...

I am trying to create a publication with "client" profiles and the values being the clients email addresses, on avg about 5 people from each of our 100+ clients get reports on a daily/weekly/monthly basis. BUT, none of these emails are in our cmc as users as they are external emails and have no...

FURTHER UPDATE for this, they also want to schedule weekly for the prior weeks data. Thru BO Scheduler.

Sorry, the standard BO Scheduler.

I have a report that needs to run on the 16 & 1 of every month, the 16 for 1-15 and the 1 for 16-eom. They are wanting to create a schedule that will easily do this without having to input dates and without having to input multiple schedules, is this even possible???

ok, no problem thanks for trying.

not sure how to obtain the sql for the lov out of business view manager. if you can tell me how to get it I will. Sorry

ok, maybe my verbage is incorrect, I created the customer business view above to basically obtain a list of values, it is as stated above so I don't believe it is cascading. The lov is using the customer business view out of business view manager and specifically the customer table to prompt...

I have created a business view as follows... DF has customer tbl - master tbl on c.customer=m.customer also has a filter on it where customer.status = Active BE has c.customer, c.name and c.status on it and a filter where c.status = active LOV field is customer and description field is name...

Sorry, new to this, I have a report that I need to schedule to run monthly AFTER a specific table is updated, is there a way to do this through events??? The table is only updated once a month but with no consistency, could be the 1st, 5th, 14th etc... My thought was to create an event that if...

Very new to business views, I have created a view that links 2 tables, inner joined on customer number, want to limit it so it only pulls back lov based on ACTIVE status, thought I was doing this by putting a filter in the data foundation but when I use the parameter in the report it is still...