Drop down list box with dynamic month and year in Date Prompt in Cognos
 

Hi all, I wanna add the current month and the last 2 months for user to select in prompt, e.g. if this month is 2008 Nov, then I wil see foowing in ddlbox 112008 102008 092008

may I know how to do it? no hard-code

http://www.stackoverflow.com/questions/321260/

        

There are 2 answer(s) to this question.


<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>

  for (int i = 0; i < 3; i++)
            {
                ListItem item = new ListItem(string.Format("{0: MM/yyyy}",DateTime.Now.AddMonths(-i)));
                DropDownList1.Items.Add(item);
            }

Try this :)


You could also create a query subject with SQL like this Oracle example:

SELECT to_char(add_months(SYSDATE, -1 * LEVEL + 1), 'MMYYYY') AS mon
FROM   dual
CONNECT BY rownum < 4

Related Questions

Related cognos Video tutorials from Youtube.


Cognos 8.4: Using Slicers in R
PerformanceG2?a full-service consultancy that can help your organization achieve breakthrough perfor
Cognos 8.4: Using Slicers in Report Studio
PerformanceG2?a full-service consultancy that can help your organization achieve breakthrough performance. Our solutions allow you to be smart, faPerformanceG2?a full-service consultancy that can help your organization achieve breakthrough performance. Our solutions allow you to be smart, fast and accurate in analyzing and reporting your results, and help you to better manage your performance goals. We do this by offering a comprehensive package of IBM Cognos performance management solutions, delivered by our team of experienced Cognos consultants and award-winning Cognos trainers.st and accurate in analyzing and reporting your results, and help you to better manage your performance goals. We do this by offering a comprehensive package of performance management solutions, delivered by our team of experienced consultants and award-winning trainers.

BSP - IBM Cognos 10 Report Stu
www.bspsoftware.com IBM® Cognos® Report Studio Enhanced Charts Enhanced User Interface Drilling Enha
BSP - IBM Cognos 10 Report Studio Enhancements
www.bspsoftware.com IBM® Cognos® Report Studio Enhanced Charts Enhanced User Interface Drilling Enhancements Custom properties Interactive Report Style

IBM Cognos 10 Launch Event Liv
www.bspsoftware.com See the IBM Cognos 10 Launch event from the back of a room filled with 10000 ver
IBM Cognos 10 Launch Event Live!!!
www.bspsoftware.com See the IBM Cognos 10 Launch event from the back of a room filled with 10000 very excited people!

BSP - IBM® Cognos® Business In
www.bspsoftware.com IBM® Cognos® Business Insight Advanced provides a single integrated environment
BSP - IBM® Cognos® Business Insight Advanced
www.bspsoftware.com IBM® Cognos® Business Insight Advanced provides a single integrated environment for advanced business users who need to do more than consume reports and dashboards that have been authored for them.

BSP - IBM Cognos 10 - My Inbox
www.bspsoftware.com New enhanced event management tasks can be created as part of an agent within Ev
BSP - IBM Cognos 10 - My Inbox
www.bspsoftware.com New enhanced event management tasks can be created as part of an agent within Event Studio as well as within a new user interface for Cognos Connection called My Inbox.

BSP - Enhance IBM Cognos Repor
www.bspsoftware.com Report Studio offers HTML Items as part of its toolbox. This podcast shows you a
BSP - Enhance IBM Cognos Reports with HTML Items
www.bspsoftware.com Report Studio offers HTML Items as part of its toolbox. This podcast shows you a few simple ways you can use HTML Items to enhance your reports. You will see how to create dynamic links, custom charts and data driven tooltips.

BSP - Scheduled Email Extracto
www.bspsoftware.com The Scheduled Email Extractor enables users to extract vital information on all
BSP - Scheduled Email Extractor for IBM Cognos
www.bspsoftware.com The Scheduled Email Extractor enables users to extract vital information on all scheduled reports run with an output set to email. The content is saved in a spreadsheet.

BSP MetaManager® - Productivit
www.bspsoftware.com MetaManager offers administrators and developers the ability to gain full contro
BSP MetaManager® - Productivity Tools for IBM Cognos
www.bspsoftware.com MetaManager offers administrators and developers the ability to gain full control over all aspects of their deployment through one intuitive, powerful user interface. Through the various product modules, users are able to save tremendous time automating manual processes while adding a wealth of capabilities to extend the value of the out-of-the-box IBM Cognos software.

BSP - Cognos Finance Excel Exp
www.bspsoftware.com The CF Expansion Pack simplifies many of the complexities associated with creati
BSP - Cognos Finance Excel Expansion Pack
www.bspsoftware.com The CF Expansion Pack simplifies many of the complexities associated with creating, editing and maintaining financial reports. As an extension to IBM Cognos Finance, the CF Expansion Pack for Excel provides functionality that automates many of the manual processes associated with report development and maintenance.

BSP - Recycle Bin for IBM Cogn
www.bspsoftware.com The BSP Recycle Bin for IBM Cognos was designed to retain content that has been
BSP - Recycle Bin for IBM Cognos
www.bspsoftware.com The BSP Recycle Bin for IBM Cognos was designed to retain content that has been deleted from Cognos Connection. Positioned directly inside of Cognos Connection, users will have their own My Recycle Bin, enabling them to recover deleted items when the need arises. Administrators will have access to the Recycle Bin of all users.

BSP MetaManager - Backup Resto
www.bspsoftware.com MetaManager provides the ability to backup, restore and deploy any object within
BSP MetaManager - Backup Restore Deploy
www.bspsoftware.com MetaManager provides the ability to backup, restore and deploy any object within or between IBM Cognos Content Stores.

BSP MetaManager - Video tutori
This instructional video demonstrates how to use the MetaManager User Access Rights utility and pack
BSP MetaManager - Video tutorial of the MetaManager User Access Rights Utility
This instructional video demonstrates how to use the MetaManager User Access Rights utility and package to generate security reports in IBM Cognos. The 4 sample reports can be used to audit group & role memberships as well as a user's access and permissions to content. Download the MetaManager User Access rights utility below.

LeaderMES MES Software Plannin
Introduction to part of the functionality of LeaderMES, see www.leadermes.eu, the leading Manufactur
LeaderMES MES Software Planning Scheduling Quality Maintenance Cognos ERP
Introduction to part of the functionality of LeaderMES, see www.leadermes.eu, the leading Manufacturing Execution System Software ( MES ) including Planning and Scheduling, Maintenance, Quality and Task management, Reporting, Cognos, Excel. Connected to your ERP like SAP Business One, Navision, etc.

BSP - Content Extractor for Mi
www.bspsoftware.com The Content Extractor for Microsoft SharePoint combines the capabilities of the
BSP - Content Extractor for Microsoft SharePoint
www.bspsoftware.com The Content Extractor for Microsoft SharePoint combines the capabilities of the Microsoft SharePoint Portal with the power of IBM Cognos BI. IBM Cognos archived content from previously run or scheduled reports that are stored in the Content Store database is synchronized to the desired location in your SharePoint Portal. The content is automatically renamed to reflect the name in IBM Cognos Connection, with the run date time stamp appended.

IBM TV--Archive--New Data Cent
See the IBM vision for New Enterprise Data Center and improve IT service delivery and control costs.
IBM TV--Archive--New Data Center and IBM System z10 EC
See the IBM vision for New Enterprise Data Center and improve IT service delivery and control costs. Meet the new IBM System z 10 Enterprise Class. Up to 85 percent smaller footprint. Up to 85 percent less energy costs. And see new software for System z. Rational. Tivoli. And new System z software from IBM and Cognos.

BSP MetaManager - Using the Se
www.bspsoftware.com This podcast illustrates how to quickly and easily see and manage the security i
BSP MetaManager - Using the Security Editor Extended Module
www.bspsoftware.com This podcast illustrates how to quickly and easily see and manage the security in your IBM Cognos environment. Learn how to edit security using the drag-and-drop capabilities of the MetaManager portal tree, and how to batch load security information from external sources.

BSP MetaManager - Pagelet Blas
www.bspsoftware.com IBM Cognos - BSP Software MetaManager's Pagelet Blaster
BSP MetaManager - Pagelet Blaster
www.bspsoftware.com IBM Cognos - BSP Software MetaManager's Pagelet Blaster

BSP - Demo Authentication Prov
www.bspsoftware.com The BSP Demo Authentication Provider is a text based LDAP for IBM Cognos demonst
BSP - Demo Authentication Provider Installation & Configuration
www.bspsoftware.com The BSP Demo Authentication Provider is a text based LDAP for IBM Cognos demonstration systems. This free extension makes it possible to set up a demonstration system of Cognos 8 with a security namespace for logging in, without the need for a true LDAP such as SUN One or Series 7 Access Manager.

IBM Cognos Express
Tenha uma visão geral de como os relatórios integrados, as análises e as capacidades de planeamento
IBM Cognos Express
Tenha uma visão geral de como os relatórios integrados, as análises e as capacidades de planeamento customizado do Cognos Express podem ajudar a sua empresa de médio porte a impulsionar maior eficiência, controlar custos e identificar oportunidades de crescimento. Para mais informações acesse: www.ibm.com

BSP MetaManager - Security Pai
www.bspsoftware.com IBM Cognos - BSP Software MetaManager's Security Painter
BSP MetaManager - Security Painter
www.bspsoftware.com IBM Cognos - BSP Software MetaManager's Security Painter

BSP MetaManager - Viewing Acti
www.bspsoftware.com This podcast demonstrates how to use MetaManager's Content Store Documenter to g
BSP MetaManager - Viewing Active and Inactive Users in your Cognos Environment
www.bspsoftware.com This podcast demonstrates how to use MetaManager's Content Store Documenter to give administrators a better insight into who is using their Cognos Environment. We document users that have a profile versus those that do not, and the last successful login date of each user.

BSP MetaManager - Using the Ad
www.bspsoftware.com A search path is an expression used to navigate the content store hierarchy to f
BSP MetaManager - Using the Advanced Search Path
www.bspsoftware.com A search path is an expression used to navigate the content store hierarchy to find objects. This video podcast will show you how to create and use search paths in MetaManager. Also check out the Cognos 8 Software Development Kit Developer Guide - Appendix A (Search Path Syntax) for more information.

BSP MetaManager - Screen Tip G
www.bspsoftware.com IBM Cognos - BSP Software MetaManager's Screen Tip Generator
BSP MetaManager - Screen Tip Generator
www.bspsoftware.com IBM Cognos - BSP Software MetaManager's Screen Tip Generator

LeaderMES MES Software Plannin
Introductie van een deel van de functionaliteiten van LeaderMES, bezoek www.leadermes.nl, het toonaa
LeaderMES MES Software Planning Rapportage Kwaliteit Onderhoud Cognos ERP
Introductie van een deel van de functionaliteiten van LeaderMES, bezoek www.leadermes.nl, het toonaangevende Manufacturing Execution Systeem ( MES ) inclusief Planning, Onderhoud, Kwaliteit en taak-management, Reportages, Cognos, Excel. Gekoppeld met uw ERP systeem zoals SAP Business One, Navision, Exact, Ridder, Plan de Campagne, etc.

Stephen Lukens and Michael Svi
Stephen Lukens, vice president, Global Financial Management Practice, IBM Global Business Services,
Stephen Lukens and Michael Svinte on Information On Demand
Stephen Lukens, vice president, Global Financial Management Practice, IBM Global Business Services, and Michael Svinte, vice president, Global Pharmaceutical/Life Science Industries, IBM, discuss the client value of Information On Demand and recent Cognos acquisition.

BSP MetaManager - Auditing use
www.bspsoftware.com This Podcast demonstrates how to use MetaManager's Security Auditor Module to vi
BSP MetaManager - Auditing user access to packages within IBM Cognos
www.bspsoftware.com This Podcast demonstrates how to use MetaManager's Security Auditor Module to view in Microsoft Excel which user accounts have access to each IBM Cognos package.

Cognos on the NASDAQ Tower
Cognos is taking Times Square by storm! Check out this big and bold new ad campaign from the expert
Cognos on the NASDAQ Tower
Cognos is taking Times Square by storm! Check out this big and bold new ad campaign from the expert in Performance Managament.

IBM Retail | Elie Tahari benef
Elie Tahari used IBM Cognos® to create a seamless reporting framework that provides granular, real-t
IBM Retail | Elie Tahari benefits from Real-Time Analytics
Elie Tahari used IBM Cognos® to create a seamless reporting framework that provides granular, real-time information from the sales floor to its suppliers' inventory and production schedules.

BSP - Dynamic Sorting in Cogno
www.bspsoftware.com This podcast demonstrates how to change the way a query is sorted based on a use
BSP - Dynamic Sorting in Cognos Studio Objects
www.bspsoftware.com This podcast demonstrates how to change the way a query is sorted based on a user supplied prompt value. This technique can be used to make your reports more flexible by allowing the user to make more choices at runtime. The technique is simple and easy to implement with no programming required.

BSP MetaManager - Documenting
www.bspsoftware.com This podcast shows you how to use the MetaManager Content Store Documenter Modul
BSP MetaManager - Documenting User Access Rights with Content Store Documenter
www.bspsoftware.com This podcast shows you how to use the MetaManager Content Store Documenter Module to gain a clear picture what your users have access to in your IBM Cognos environment. Use it to flatten the hierarchy of memberships and show a true picture of the groups which a user is a part of and the access rights acquired from those memberships.

BSP MetaManager - Template Bla
www.bspsoftware.com IBM Cognos - BSP Software MetaManager's Template Blaster
BSP MetaManager - Template Blaster
www.bspsoftware.com IBM Cognos - BSP Software MetaManager's Template Blaster

IBM Business Analytics Success
Listen to our partners talk about what IBM Business Analytics and Cognos software has meant to their
IBM Business Analytics Success Stories
Listen to our partners talk about what IBM Business Analytics and Cognos software has meant to their business and their customers success.

BSP - IBM Cognos Report Specif
www.bspsoftware.com The Report Search utility produces a list of all reports that match a user-defin
BSP - IBM Cognos Report Specification Search Utility
www.bspsoftware.com The Report Search utility produces a list of all reports that match a user-defined search criteria. For example, Report Search can be used to find all reports that use a specific filter or data item. The results are generated as an XML, HTML or CSV document.

BSP - Integrated Control Suite
www.bspsoftware.com The Integrated Control Suite (ICS) was designed to grant organizations better ma
BSP - Integrated Control Suite
www.bspsoftware.com The Integrated Control Suite (ICS) was designed to grant organizations better management and oversight during the development lifecycle within an IBM Cognos environment.

BSP MetaManager - Report Valid
www.bspsoftware.com IBM Cognos - BSP Software MetaManager's Report Validator
BSP MetaManager - Report Validator
www.bspsoftware.com IBM Cognos - BSP Software MetaManager's Report Validator

BSP MetaManager - Cube Connect
www.bspsoftware.com Cube Connector is designed to facilitate the creation and maintenance of Cognos
BSP MetaManager - Cube Connector Extended Module
www.bspsoftware.com Cube Connector is designed to facilitate the creation and maintenance of Cognos 8 PowerCube datasource connections. Users can simply specify a directory where PowerCubes exist and map all respective .mdc files to a datasource in Cognos. Similar to PowerPlay Enterprise Server (in the Series 7 days), any all PowerPlay cubes can easily be added to Cognos Connection through this simple interface.

BSP MetaManager - Deploy IBM C
www.bspsoftware.com This video podcast demonstrates how to deploy content from one environment to an
BSP MetaManager - Deploy IBM Cognos Content within environments containing different security.
www.bspsoftware.com This video podcast demonstrates how to deploy content from one environment to another that contains different security settings.

BSP MetaManager - Security Pai
www.bspsoftware.com This podcast demonstrates 2 new features in Security Painter (currently availabl
BSP MetaManager - Security Painter for IBM Cognos
www.bspsoftware.com This podcast demonstrates 2 new features in Security Painter (currently available in the 3.4 beta). First the ability to reset permissions to inherit from their parent and second the ability to append new policies rather than replace them.

PRONTO-Xi with IBM Cognos 10
PRONTO-Xi is the world's first ERP with integrated IBM Cognos 10, to enable quicker, smarter decisio
PRONTO-Xi with IBM Cognos 10
PRONTO-Xi is the world's first ERP with integrated IBM Cognos 10, to enable quicker, smarter decision-making.

Software execs speak out on Go
A new feature of the Google Search Appliance, Google OneBox for Enterprise delivers relevant, real-t
Software execs speak out on Google OneBox for Enterprise
A new feature of the Google Search Appliance, Google OneBox for Enterprise delivers relevant, real-time information from enterprise sources, such as CRM, ERP and business intelligence systems, based on a user's search query. Google OneBox for Enterprise can provide users with secure access to everything from simple phone book listings to graphs of inventory levels and sales trends. Current OneBox partners include Cisco, Cognos, Employease, Netsuite, Oracle, Salesforce.com, and SAS - and the list keeps growing.

Chad Talks Business Analytics
On Chad's second day of Information On Demand 2010 and Business Analytics Forum, he gives us an over
Chad Talks Business Analytics -- Tuesday 10/26
On Chad's second day of Information On Demand 2010 and Business Analytics Forum, he gives us an overview of what he's seen and heard at the event.

IBM Cognos What-if Analysis an
Your customers make strategic and tactical decisions every day. Analyzing historical performance, mo
IBM Cognos What-if Analysis and Planning for ISVs
Your customers make strategic and tactical decisions every day. Analyzing historical performance, modeling new scenarios, and visualizing impact is critical in making optimal decisions.

Salesforce Performance - Drew
Drew Clarke discusses the importance of sales analytics in evaluating and assessing sales force perf
Salesforce Performance - Drew Clarke, IBM
Drew Clarke discusses the importance of sales analytics in evaluating and assessing sales force performance.

BSP MetaManager - Document all
www.bspsoftware.com This podcast demonstrates how to search the entire document for a list of accoun
BSP MetaManager - Document all users with an IBM Cognos profile
www.bspsoftware.com This podcast demonstrates how to search the entire document for a list of accounts to an XML file which can be used in Excel. By filtering on the Creation Time property we can see which accounts have a profile and which do not.

BSP - System Monitoring and Br
www.bspsoftware.com As a Cognos Administrator, it is often critical to monitor the current and histo
BSP - System Monitoring and Broadcast Messaging with IVC
www.bspsoftware.com As a Cognos Administrator, it is often critical to monitor the current and historical usage of the environment. See how IVCs Studio Monitoring and Broadcast Messaging capabilities take Cognos to the next level!

BSP MetaManager - Understandin
www.bspsoftware.com This podcast demonstrates some common use cases in the Find Replace module for f
BSP MetaManager - Understanding the impact analysis features
www.bspsoftware.com This podcast demonstrates some common use cases in the Find Replace module for finding reports based on search queries. By disabling some of the impact analysis capabilities when they're not needed you can speed up the module's performance significantly. Also a few good tips and tricks along the way!

Post you comment here

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

There are 0 comment(s) to this page.



The questions and answers taken from stackoverflow.com's public data dump which is licensed under the cc-wiki license.
Logo, website design and layout ©2011 CodingTiger.com