Cross tab Datawindow erro

We migrated PB 9 to PB 12. After migration when we are
running report we are getting --> "Please refresh your
crosstab definition"
We are running against MS SQL Server 2000.

Thanks for your help.

Hi Raj;

1) Are you using PB 12.1?
2) Are you using the same DB connectivity option?
3) If you open and run (preview) the DWO in the DW Painter - does it give 
you the same error?

Regards ... Chris
President: OSUG / STD Inc.
Blog: http://chrispollach.blogspot.com
PBDJ: http://chrispollach.sys-con.com
SourceForge: http://sourceforge.net/projects/stdfndclass

"Raj" wrote in message news:[email protected]...

We migrated PB 9 to PB 12. After migration when we are
running report we are getting --> "Please refresh your
crosstab definition"
We are running against MS SQL Server 2000.

Thanks for your help. 

Thanks for your response.
Answer (1) I am using PB 12.0
       (2) What do you mean by that?
       (3) I can not preview in DW painter because I am
creating temp table at run time.

> Hi Raj;
>
> 1) Are you using PB 12.1?
> 2) Are you using the same DB connectivity option?
> 3) If you open and run (preview) the DWO in the DW Painter
> - does it give  you the same error?
>
> Regards ... Chris
> President: OSUG / STD Inc.
> Blog: http://chrispollach.blogspot.com
> PBDJ: http://chrispollach.sys-con.com
> SourceForge: http://sourceforge.net/projects/stdfndclass
>
> "Raj" wrote in message
> news:[email protected]...
>
> We migrated PB 9 to PB 12. After migration when we are
> running report we are getting --> "Please refresh your
> crosstab definition"
> We are running against MS SQL Server 2000.
>
> Thanks for your help.
>

Answer (1) I am using PB 12.0
=> I would highly recommend applying the 12.1 MR release.

       (2) What do you mean by that?
=> Is the SQLCA.DBMS parameter value the same in your PB 12 version of the 
application?

       (3) I can not preview in DW painter because I am
creating temp table at run time.
=> Are you creating a dynamic DataWindow or just changing the DWO's SQL at 
runtime to point to the TEMP table?

BTW: Are you using PB 12 Classic or .NET?




> Hi Raj;
>
> 1) Are you using PB 12.1?
> 2) Are you using the same DB connectivity option?
> 3) If you open and run (preview) the DWO in the DW Painter
> - does it give  you the same error?
>
> Regards ... Chris
> President: OSUG / STD Inc.
> Blog: http://chrispollach.blogspot.com
> PBDJ: http://chrispollach.sys-con.com
> SourceForge: http://sourceforge.net/projects/stdfndclass
>
> "Raj" wrote in message
> news:[email protected]...
>
> We migrated PB 9 to PB 12. After migration when we are
> running report we are getting --> "Please refresh your
> crosstab definition"
> We are running against MS SQL Server 2000.
>
> Thanks for your help.
>