How to Filled a Report Field with Request Values

building semantic layer
1

Hello,

I am creating a template that will prompt the user for Start Date and End Date. The date values are based on a rolling year (i.e., 10/01/1998 - 9/30/1999) we consider this 3Q99. What I would like to do is create a prompt that will also, ask the user what is the rolling Quarter, the will enter 3Q99, and have a column in the results Title Quarter with the value of 3Q99 for each record.

Listserv Archives (BOB member since 2002-06-25)

2

Instead of prompting the user for an additional prompt. Why don’t you create an object in designer with a decode statement based on the prompt? You can include the same prompt values so that you only get prompted once for start date and end date, then this object will give you the Qname based on the month. Just parse out the month. So it will work something like this:

Prompt for start date and end date.
Return an object - if end date is month of jan, feb, mar - then Q1, else…

Hope it helps.

Julie

I am creating a template that will prompt the user for Start Date and End Date. The date values are based on a rolling year (i.e., 10/01/1998 - 9/30/1999) we consider this 3Q99. What I would like to do is create a prompt that will also, ask the user what is the rolling Quarter, the will enter 3Q99, and have a column in the results Title Quarter with the value of
3Q99 for each record.

Listserv Archives (BOB member since 2002-06-25)

3

That is a great idea; however, I fail to mention that I setup an ODBC connection to Microsoft Access and I can not export user defined variables that I create within the report. How can I implement your suggestion with the query panel?

Thank you for your quick and helpful reply.

Ivon

Listserv Archives (BOB member since 2002-06-25)

4

This would not be a variable created within the report. It would be an object that you build in the universe with the designer module. Then, you simply add the object to your query panel to retrieve the value.

Let me know if you need further assistance.

Julie

Listserv Archives (BOB member since 2002-06-25)

5

Oh! I don’t have access to the design of the universe. Thanks anyway

Listserv Archives (BOB member since 2002-06-25)

6

Can you create a user object within your query panel? That will work too!

Oh! I don’t have access to the design of the universe. Thanks anyway

Listserv Archives (BOB member since 2002-06-25)