Need entire data

[Prakash Bhai]

Hi Team,

Assume in my report, I have 500 + records
If I apply a filter condition based on month selection, I am getting 50 records for the particular month .

Now my question is, I need to have filter condition in place and also I need to get the rest of the values also...

i.e 50 records + 450

Regards,
Abhi

[MFGF]

Hi Team,

Assume in my report, I have 500 + records
If I apply a filter condition based on month selection, I am getting 50 records for the particular month .

Now my question is, I need to have filter condition in place and also I need to get the rest of the values also...

i.e 50 records + 450

Regards,
Abhi

Hi,

A filter will (as the name suggests) filter your query, so that you only get matching rows.

Can you explain what you need to achieve? It might be possible to use a calculation to "bucket" the rows based on the month,

eg

if ([Your Month item] = <the month you were filtering on>) then ('Chosen month') else ('Other months')

You could then group your report on this item?

Unless you tell us what your real requirement is, it's not easy to give you a solution we know will work for you...

Cheers!

MF.

[Lynn]

It is also possible to include all data but highlight data for the current month. Is that your requirement?

Or maybe you want to output current month information on one page or Excel workbook tab and all other data on a separate page or Excel workbook tab?

[Prakash Bhai]

Lynn,

you are correct, I need to Include all the data in the report and to highlight data related to current month.

Regards,
Abhi

[Lynn]

Lynn,

you are correct, I need to Include all the data in the report and to highlight data related to current month.

Regards,
Abhi

Try creating a conditional style that you can apply to your layout. If the data container is a list you can navigate to "list columns body style" and set a conditional style there so that all columns in the row are highlighted based on your condition.

An advanced conditional style such as the following might be close to what you want:

Code Select Expand


ParamValue('Your Month Parameter') = [Your Query].[Your Month Query Item]


This is all assuming you have a relational source. If it is dimensional or if you have a different type of layout then you'll need to post back with more detail.

[Prakash Bhai]

It is a crosstab report and we use DMR functionality, Lynn

[Lynn]

It is a good idea to provide as much detail as possible in your initial post of a question. There is a forum etiquette post that explains what you can do to get the best answers for your questions.

The process for a crosstab over DMR might be very similar to what I've already described. A lot depends on how you plan to identify the month that needs to be highlighted but you haven't really provided any details on that.

In the attached report spec over the GO Sales (analysis) sample package a conditional format is set on the crosstab intersection and one of the crosstab nodes that displays the month. It uses a prompt to determine which month needs to be highlighted.

Hopefully this is enough information to give you ideas on how to adapt for your specific requirements.