list and header compatibility issue

[udaychow99]

Hi Gurus,

I have a report which has a prompt page and report page.

In Prompt page , there is one value prompt with 3 static values. It is allowed to select multiple values in it.
In Report Page , I have 3 list reports on the same page which have same number of columns and same columns .For each report, there is a separate filter defined, hence 3 reports are defined. Based on the value selected in prompt page, reports are being rendered.

The problem I am facing here is, Whenever I am selecting multiple values multiple reports are displaying. But I don't want header to repeat for each and every report, since all are having same columns. For this,I took a dummy list report and set the box type of 'List columns body style' as none. I put all the reports under this header and set the box type of 'list columns title' for each report as none.
When running the report, header and the data below is not coming in correct order.

Have I missed out any property?, Any help would be much appreciated.

Thanks in Advance.

[karthik.kadambi]

data below is not coming in correct order
Can you provide more details? Are you using a master-detail relationship to link the dummy list to the 3 list reports?

[bdbits]

Am I correct in that you want the three reports to appear as one? If I may suggest a different approach... add a source key you can sort on to each of your current queries. Create a Union query and use that as the data source for a single list report object. Sort the list on the added source key to get them to appear in the order you want.

Make sure if you remove existing list containers that you cut them instead of deleting them, otherwise the source queries will also disappear.

[udaychow99]

Hi Karthik!

thanks for the reply!..There is no master detail relation between dummy list report and other reports.
Just used the dummy list for using it as header for the other reports.

let me tell you in a simpler way,

I have a query subject q1
columns:
state
country
sub region
region.

I have a prompt page which has one value prompt. I defined 3 static choices in it like
Asia
Africa
Europe

I enabled multi-select option.

I have a report page. It has 3 list reports which have all the query items of query subject q1 i.e. state,country,sub-region,region.

list1  --> filter condition is region='Asia'
list2  --> filter condition is region='Africa'
list3  --> filter condition is region='Europe'

I want to display the report based on the respective value selected in value prompt.
If I select 'Asia', then I want to display list1
If I select 'Asia' and 'Africa', I want to display both list1 and

For this, I am using render variables and I can successfully achieve this task.
But, the problem for me is, when I am selecting 'Asia' and 'Africa', list1 and list2 are displaying with their headers.
Since they both have same headers, I don't want to see the repeating of headers in the final report.

So, I set the box type of 'list title style' property for all the reports as 'none'.
And I put a list report with the same columns above the existing 3 reports, and set the box type of 'list data type' property as 'none'

While running the report, the header and the data is not displaying in proper order. That's the problem I am facing!

Attachment for reference.

[udaychow99]

Am I correct in that you want the three reports to appear as one? If I may suggest a different approach... add a source key you can sort on to each of your current queries. Create a Union query and use that as the data source for a single list report object. Sort the list on the added source key to get them to appear in the order you want.

Make sure if you remove existing list containers that you cut them instead of deleting them, otherwise the source queries will also disappear.

Thanks for the reply bro.!

I don't want three reports to display as one. I explained my requirement in the above post in more simple way, please check it.

[MFGF]

Hi Karthik!

thanks for the reply!..There is no master detail relation between dummy list report and other reports.
Just used the dummy list for using it as header for the other reports.

let me tell you in a simpler way,

I have a query subject q1
columns:
state
country
sub region
region.

I have a prompt page which has one value prompt. I defined 3 static choices in it like
Asia
Africa
Europe

I enabled multi-select option.

I have a report page. It has 3 list reports which have all the query items of query subject q1 i.e. state,country,sub-region,region.

list1  --> filter condition is region='Asia'
list2  --> filter condition is region='Africa'
list3  --> filter condition is region='Europe'

I want to display the report based on the respective value selected in value prompt.
If I select 'Asia', then I want to display list1
If I select 'Asia' and 'Africa', I want to display both list1 and

For this, I am using render variables and I can successfully achieve this task.
But, the problem for me is, when I am selecting 'Asia' and 'Africa', list1 and list2 are displaying with their headers.
Since they both have same headers, I don't want to see the repeating of headers in the final report.

So, I set the box type of 'list title style' property for all the reports as 'none'.
And I put a list report with the same columns above the existing 3 reports, and set the box type of 'list data type' property as 'none'

While running the report, the header and the data is not displaying in proper order. That's the problem I am facing!

Attachment for reference.

Hi,

Unless I'm missing something, the approach you are using is making life very difficult for yourself. Why do this with three lists and not just with one filtered list using group headings based on the region item?

MF.

[udaychow99]

Hi,

Unless I'm missing something, the approach you are using is making life very difficult for yourself. Why do this with three lists and not just with one filtered list using group headings based on the region item?

MF.

Hi MF,

Thanks for the reply.
I just mentioned my requirement in a simpler way. It is very much complex in my real time scenario.There are many filters applied on each list report which differs with each report. I have no option other than using the above said procedure.
Please help me out with the above said procedure.
Thanks in Advance!

[MFGF]

I have no option other than using the above said procedure.

Hi,

Are you sure? You haven't told us what the requirement or the complexity is?

MF.

[udaychow99]

 

Hi,
You haven't told us what the requirement or the complexity is?
MF.

Hi MF,

I didn't get this. I have specified my requirement in the previous posts. It is not possible to specify my real time scenario here.
But to make things simple, If I can achieve the task what I mentioned in the previous posts , then I can implement it in my real time scenario. Actually, my real time scenario is an existing one. The report is perfect when viewing in excel, but the problem is only with HTML and PDF type. I have to just fix this issue.

[MFGF]

 
Hi MF,

I didn't get this. I have specified my requirement in the previous posts. It is not possible to specify my real time scenario here.
But to make things simple, If I can achieve the task what I mentioned in the previous posts , then I can implement it in my real time scenario. Actually, my real time scenario is an existing one. The report is perfect when viewing in excel, but the problem is only with HTML and PDF type. I have to just fix this issue.

Hi,

The requirement you have detailed in the thread above can easily be achieved in a single list. I'm not seeing anything in this requirement that warrants multiple lists? If your requirement is more detailed than you specified, then provide the extra detail so we can help you find the best solution.

Cheers!

MF.

[Lynn]

Your column headings line up with the content of the three lists in Excel because there is no need to address different width sizing. In HTML and PDF the only way to correct your issue is to set the size and overflow property for every column in the dummy list and also in the three lists. Even then it isn't a real guarantee that it will always work exactly as desired since the content may change over time that affects what the optimal width settings should be.

I agree with MFGF and bdbits that even complex report requirements can be handled in a more elegant fashion than what you are attempting to do here.

[udaychow99]

Thank you all for putting in your time for this post.

Finally I could achieve this with 'table properties' and 'size and overflow' property.
Though It did not work for excel, I managed with the help of conditional layout.

cheers!!