Regarding the format of the report ...........

general discussion
1

I need to develop cross tab Skills report which is fetching the data from skills data base and cross tab is with skill names field ,Query fetches data like name of the skills,skill category,Count of the associates in each skill like .Here my query is in my report in need to show all the skills in report format eventhough there is no data has retreived for some skills or even no data has feteched by the query is it possible ???

if so please help me how can i do the same

raju_souju1 (BOB member since 2008-09-23)

2

create a query, query 1, that returns all the skill dimensions as a seperate dataprovider.

Merge the common dimensions with those of the other query, query 2, fetching the measures.

Use the dimensions from query 1, use the measures from query 2 in your crosstab.

Mak 1 :uk: (BOB member since 2005-01-06)

3

You would have to create a table that appeared to be a crosstab, manually type each “skill” name in a row or a column and then create formulas to counts each - so for example, =If(skill = ‘A’;count;0).

malevy :us: (BOB member since 2006-08-15)