[Solved] A probs in Conditinal Blocks..

[BIsrik]

Hi,

I have report with custom grouping (i mean the user will select the type of grouping they want). I have used conditional blocks for this..I have another two prompts for the report apart from the grouping criteria. I have set these two prompts as optional.

Now when i enter some values in these two prompts i get the output..but when i don't enter any values in these prompts and only select the type of grouping the report executes for a longer time and gives error as " cannot find the primary key" or "Server too busy"..

I took the two queries( two queries are created based on the grouping) independly in a new report and executed with no filters in them and i got the result.. But when i put them in conditional blocks and executed with no filters it continues and sometimes gives the error as said before.

Can anyone tell me why is this happening...Is it a problem with conditional blocks...

Srik

[sir_jeroen]

Can you post your code that you use for the conditional formatting and the code for the query item?

[BIsrik]

i have a boolean variable set for conditional formatting..

conditional_variable = Paramdisplayvalue("Group_Parameter") = 'Q1'

For yes i have a list report on Q1 and and for NO i have another list report on Q2.

For the other two prompts:

Prompt1..

  [ColumnA] starts with ?ColumnAText?

and Prompt2

[ColumnB] starts with ?ColumnBText?

Both these filters are set as optional and both these are in both the queries( Q1 and Q2)

Srik

[sir_jeroen]

Can you create a sample on the Go Sales.. then I'll have a look into it tonight...

[BIsrik]

thats the problem...i don't have the access to gosales package....

Srik

[sir_jeroen]

Ouch... then it's difficult to do... But you can try to convince your admin to publish it because if you contact Cognos they will ask you to do it Go Sales too....

[BIsrik]

yeah have raised it...still no response for that...

Srik

[sir_jeroen]

Let's kick some #ss then :D

[BIsrik]

got it done...the problem was with using for report in aggregation funtion. It was working fine when a limited set of records are read but it failed when a large amount of data was fed. Replaced it with a dataitem 1 and then set the data item and fact item aggregation to total.

It worked fine...

Srik