1.Create a calculated column which contains the information that the header is to contain, such as "Report for year 1999" (concatenated text and date to string sub string extraction). 2.Highlight
Latest Answer : Create dataitem by using cast function and use that data item value for the dynamic column name by changing the source value (name under properties) for the column you need. ...
The sub-report only includes the first value."When the sub-report query runs, it checks for the first row in the Customer Name column and shows only information for that customer. If you want a sub-report
Latest Answer : By using the 'IN' operator in creation of a prompt we can create a sub report. When the prompt executes, you can select multiple values and the results from the sub-report will reflect those selected items. ...
How to show the data reported horizontally:(For example:)employee skill1 a1 b1 c2 d2 e2 fReport result:1 abc2 def
Assuming 3 records per grouped item:1. Group on employee2. Create a running count based on the skill field.3. Create 3 calculated columns based on the count field.Call them skill1, skill2, skill3:if (count
Use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007 i need to restrect this query to current date and current year [gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char(current_date,'MM'))and [gosales_goretailers].[Orders].[Order month]=to_number(to_char(current_date,'MM'))pass polar ID
What is meant by Junk Dimension?How do you perfom while running the report?Where will you see the time of running report?Size of the cube?What are the types of prompts in ReportNet?What is macro and how it will be work?What is difference between Cognos and Cognos ReportNet?How do you create cube in ReportNet?There are 10 facts are there.How will you connect all?
I need answer
What is the difference between a cascading report and drillthru report?why do we go for drill thru report?
Latest Answer : We can provide border for that chats you select chat and select properties you will set there box type there. ...
Latest Answer : the most common problems are -1.No Data Appears in the Report (to remove this check data source or package)2.Unexpected or incorrect values appears in reports , may be report is running with limited data3.The report filter does not work, values are not ...
Latest Answer : Data source for defining a catalog may be any database.Whether it may be a relational database(like Oracle,sql server, DB2,Tera data etc) ...
Latest Answer : From which package u want to select and then go to select the template. According to ur documents select & add query items and if any conditional and filters u have add to ur report. After complete your report u have to test the report. ...
