Search results for query: *

Yep, that is what I thought. Thanks.

I have a stored procedure that basically just does a select. Can I do aggregate functions on the procedure's result set within query analyzer without using temp tables or the actual query behind the proc? Here is the query I tried with no luck: select t.field1, sum(t.field2) from ( exec...

So, you are running the report four times five minutes apart? Can't you just manually schedule the four instances? If that's not the case, what affects the change in the parameter value? Give an example of how/why the parameters are changing.

lbass Did you test this? Because I tried it with a couple of different reports and it isn't working for me. The group tree is still created with the blank item. + Sales Rep + Thanks for all your help but I am beginning to think this isn't possible.

Group1 formula: if {?ReportType} = 'Summary by Sales Rep by Region by Product' then {Sales.SaleRep} else if {?ReportType} = 'Summary by Appointment Setter' then {Sales.ApptSetter}... then I group on this formula. Group2 formula: if {?ReportType} = 'Summary by Sales Rep by Region by...

I have three groups, which are all formulas based on the user selection for the ReportType parameter. So for instance if the user selected 'Summary by Sales Rep by Region by Product' for the ReportType, Group1 would be Sales Rep, Group2 would be Region, Group3 would be Product. If the user...

It is not a matter of excluding records. If the user selects 'Summary by Sales Rep', I still need all of the records, I just want to show the single group for Sales Rep. But, if the user selects 'Summary by Sales Rep by Region by Product', I need the same exact data just with the added group...

I am not sure I understand what you are proposing. More report info: I have 4 params; Report Type, GroupSelection1, GroupSelection2, & GroupSelection3. So, if the user selects 'Summary by Sales Rep by Region by Product' for the Report Type param then Product becomes group 1 (and uses...

I have a Crystal Report written in XI. My report has three groups which are conditionally suppressed based on user selected parameter values. I need the group tree to display. However, I only want the groups to display in the group tree when the group is not supressed in the report...

If you have a unique ID on the customer, and I assume you do since you are aggregating in the Excel file, can't you link your tables together using that and do the summary info in one report? Alternatively, have you attempted inserting a group on the customerID and using shared variables to...

I have inherited several reports that were created using tables. I could improve the performance of the reports a hundred-fold (maybe) by replacing the tables with SQL Commands. My question is: How can I make the report point to the SQL Command for the fields that are already on the report...

Split GF3 into two sections using 'Insert section below'. In the first section, do the 'New Page After' routine. In the second section, which should now be printing on it's own page, do the 'Reset Page Number After'.

If you go to Database - Set Datasource Location, you can check to see if you are using multiple data sources. If not, you should update your report.

If you just want patients without an account number, you probably would want: isnull({TABLE.ACCOUNT_NUMBER}) or {TABLE.ACCOUNT_NUMBER} =

If you are using a field from the right table in your record selection, you are probably negating the left outer join. Give some more details about the report. What db are you using? Can we see the SQL?

Insert a group on the contact date in descending order. Show the details in the group header and you should display only the last date.

ttt

Curious what you mean when you say 'a bit less exact on positioning'? And, just to be clear, are you saying that if two users enter text into a single memo field, one using 14 point red lettering and the other using 20 point blue lettering, that I can show the text entered by both users in my...

You may need to put a space after the comma. Replace({Table.Field}, chr(13), ", ")

Here is an old post of mine. My questions is for anyone who has worked with or otherwise has knowledge of Business Objects XI. Was this issue fixed in XI? I have many, many reports with memo fields that contain RTF text. I would like to give the user an option to ignore the RTF formatting...