You will need to insert the field name where it shows {MyFieldName} below. Perhaps select the text in the record selection formula and then double-click on the actual field from the list above it in the formula editor to ensure you get the full field name.
not(isnull({MyFieldName}))or...
It may also be worth considering using a universe with a derived table inside it showing the above SQL. Then it can be re-used if required and also you can keep your SQL snippets in one place. I have found the performance using queries in universes better than commands in the report also.
ShortyA
Hi - do you have any more information as to how the report is being run? For instance is the ERP running the report via Business Objects Enterprise or Crystal Reports Server? Which viewer is being used eg HTML? Is it all users or just a selection? With the HTML viewer I don't believe anything...
In the record selection formula have you tried:
tblSONotesTopic is not null or tblSONotesTopic<>''
This is all dependant upon what the actual field contains ie is it just blank or does it contain a value of a single space.
Hi,
I am using CRD XI R2 and have a subreport. The output is going to be split across two columns going down the left and then down the right column after that.
Page 1
Header
Summary block
Subreport-Shorty
Col 1 Col 2
Value 1 Value 4
Value 2 Value 5
Value 3 Value 6
End of Page 1...
Steve,
many thanks for your help - clearly you are decades beyond my limited experience!
I am a relative new universe developer so am unclear on how a filter can be applied such as this to the universe. Are you able to provide more information please ?
Also, when you have implemented this...
As an addendum when I added in the Clarity security view and did a self-join this worked fine as long as there was a value from that table being used in the report.
For example :
Linking the "Security" view into "Projects" with the self join on the "Security" table (User_Name, Project_ID) and...
Hi,
we are using Clarity for PPM and are implementing Webi to allow users to run their own queries. However we want to make sure that they can only see the projects/resources etc that they would be able to in the Clarity application.
So in the universe I have two main tables. First one called...
This is the first time I have created a measure which is not a direct field value. Is this syntax entered in the "Select" section of the measure ? Thanks.
Hi - thanks for your prompt reply. I am connecting to an Oracle database but have used case statements before in PL/SQL. I am going to summarise the field value within various groupings in the end report. Would a measure be best for that ?
Thanks for your help.
ShortyA
Hi,
I am new to using the BO Designer as used to working with Crystal Reports. Using Designer on BOE XI Release 2 and have a question that I am hoping you can help with.
I would like to create an object which has a value of "1" if various conditions are met. For example "if (field1=A and field2...
Hello folks!
Very quick question. My client is running Crystal Reports Server XI release 1 and wants to move up to release 2. I believe that this is not included in the support/maintenance agreement as it is not a service pack but an actual product release. The client does not have good...
From a single field value of 'DD port.12.3.19' I want to extract the following:
Column names --Shelf,Slot,Port
Values -- 12,3,19.
Normally I would just use a MID but as the numeric values can be 1 or 2 digits their positions are variable but ALWAYS after a decimal point.
Ah another AWD BI implementer and I am guessing from the queue code that it is in financial services. How are you finding the BI product ? Have you done much customisations ? I implemented it for a client a few years ago and am interested that is all!
Regards - Alec
alec dot short at thackeray...
Hi Ian.
Thanks for your reply. I receive an error message of "a subscript must be between 1 and the size of the array" when add this to my report. As there will always be 3 different output values (Shelf,Slot,Port) is there some way of fixing the array to be 3 ? Or another way of not generating...
Hi folks.
I am using Crystal Reports XI R2 against an Oracle DB using native driver.
I have a field with values such as 'DD port.1.2.1' and 'DD port.12.3.19'. Note that all of the numerics can be either single digits or double digits so the field length varies. Basically I want to strip the...
Hi.
I am looking to use Business Objects Enterprise either with Business Objects (Desktop or Web Intelligence) or Crystal Reports as the development tool. Does Business Objects Enterprise support export of report output to XML ?
For background I want to export via XML to integrate into an...
Thanks for the information - most useful. I think the session isn't being removed even though the browser is closed so suspect there is a job, similar to the Weblogic garbage collection, that needs to run...I will dig deeper.
Thanks again.
ShortyA
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.