en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Steffen Eriksen  
#1 Posted : Wednesday, June 6, 2012 5:29:17 PM(UTC)
Steffen Eriksen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 5/11/2012(UTC)
Posts: 12

Hi all

I'm fairly new to Targit - so bear with me :)

I'm currently designing a report where I want the following headline:

P&L - [Month] - [Year]

where Month is last month corresponding to this month and Year is current year. Ex: P&L May - 2012

The headline is of the Band: Group Header.

If I use a globale criteria on the report like This year; Last month and use a system variable and format dynamic captions like this

(Time: {Month:last} - {Year:last})

will solve my problem but this will mess up a crosstable that I have in the report. I can't alter this crosstable.

Do you have any idea/solution/tips how to solve this? Thinking of defining my own system variable but don't know if this is possible.

If you need more information please write.

Working on Client version 2K11 build 4614

BR

Steffen Eriksen - Egmont Magasiner DK

Edited by moderator Wednesday, July 11, 2012 9:11:18 AM(UTC)  | Reason: Not specified

Dennis de Gier  
#2 Posted : Thursday, June 7, 2012 7:27:01 AM(UTC)
Dennis de Gier
Rank: Advanced Member

Groups: extranet\Forum
Joined: 10/12/2011(UTC)
Posts: 27

Hi Steffen

You are not able to create your own system variable.

In order to use a global criteria on a report for use in dynamic captions but still have crosstabs that are not affected by this criteria, you will have to override the report criteria using either local criteria or comparisons in the crosstab. Local criteria and comparisons in the crosstab will take precedence over the report criteria.

This approach is something I personally use quite often to achieve your scenario.

I hope I have understood your question correctly and that my reply is helpful.

Best Regards,
Dennis
Steffen Eriksen  
#3 Posted : Friday, June 8, 2012 12:05:50 PM(UTC)
Steffen Eriksen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 5/11/2012(UTC)
Posts: 12

Hi Dennis

**UPDATED -> It works (but not a elegant solution in my opnion...)**

Thanks for the quick relply.

Okay so if I understand you correct i should make local criteria in the 3 or 4 corsstables that I have in my report and then have a global criteria with: this year last month?

BR Steffen

Edited by user Friday, June 8, 2012 3:25:43 PM(UTC)  | Reason: Not specified

Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error