Formatting Prompt Values

[blueblue]

Hi all,

I have a report which takes in two prompts – start and end dates in the format MMYYYY. (It doesn’t take in day values)

I can manipulate these values by creating data items in a query and comparing against date values in the database, however when I go to display the values on the ‘Page’ itself I cannot manipulate them or call the data items which I created.

Any ideas? I just want to display the prompt values in the format MM/YYYY. Only difference is the backslash in between.

Thanks!

 

[almeids]

I think I understand what you are trying to do and it is possible, I'm just not sure where you are running into trouble. Once you have added a Data Item to your tabular model with an expression like to_date(?Parameter1?,'MMYYYY') you should be able to add it to your query and report, then use the Data Format property to control how the date is displayed on your page (this is Oracle syntax, you'll need a similar string-to-date function for your db if different). You may also be able to do the calculation at the query level but I'm not sure that's always true, I think it depends on how much (and where) ReportNet is locally processing the data.
Steve

 

[blueblue]

Thanks Almeids,

Yes, its fine to add it to a query or report as a column but I just want to add it in the header (for example, Report from date: MM/YYYY) so as a text box item.

At the moment my text box item calls the parameter like so:
ParamDisplayValue(?parameter?).

but you cannot seem to be able to format this and you cannot call the Data item I created either....

thanks

 

[almeids]

Your text item is making use of a Report Expression; if you are trying to change that to Query Item and the list of query items shows as <empty> then the problem is that you don't have your query associated with the page. You can do that in the page explorer with the Page Breaks button, or by setting the Query property of the Page.
Steve

 

[kt4]

Have you tried adding your prompt to a list in the header?