Author Topic: DYnamic page headers  (Read 745 times)

Offline zenith

  • Full Member
  • ***
  • Posts: 40
  • Forum Citizenship: +1/-0
DYnamic page headers
« on: 20 Apr 2006 12:52:39 am »
hi

I have a problem. i need to display no data in the page header whenever theres no data in the list
I tried many ways using conditional text etc it dosent work howver
i also attached the query to the page i have a single query
Cheers

Offline bdybldr

  • Global Moderator
  • Statesman
  • *****
  • Posts: 275
  • Forum Citizenship: +7/-1
Re: DYnamic page headers
« Reply #1 on: 20 Apr 2006 06:32:51 am »
zenith,
Add a data item to your query (doesn't have to be displayed in the report) called "RowNum".  Define it as running-count(RowNum()).

Then create a boolean variable called "varNoRows" defined as [RowNum] < 1.

Add a conditional block to the header based on varNoRows and set current box to "Yes".  Then create a text item "No Data" and place it inside the conditional block.

I haven't tried this but it should work.  HTH

Keep us posted.

Offline zenith

  • Full Member
  • ***
  • Posts: 40
  • Forum Citizenship: +1/-0
Re: DYnamic page headers
« Reply #2 on: 21 Apr 2006 02:28:25 am »
hi i think i am applying the condition wrong
can u tell me when to exactly apply the conditonal ... in a sequence
Cheerss

Offline bdybldr

  • Global Moderator
  • Statesman
  • *****
  • Posts: 275
  • Forum Citizenship: +7/-1
Re: DYnamic page headers
« Reply #3 on: 22 May 2006 08:41:45 am »
The sequence doesn't matter.  As long as you create your variables first, there should be no problem.  What is happening when you run the report?

Offline pg0816

  • Associate
  • **
  • Posts: 1
  • Forum Citizenship: +0/-0
Re: DYnamic page headers
« Reply #4 on: 10 Jun 2006 06:37:22 am »
zenith, did this work for you?
I am trying something similar.
I want to show a text message on the report when the report returns no data.


Thanks.