Prologika Forums

Hi..

I have setup the data processing extension. When I try to attach a filter to a report using report builder filter screen, I get the subject methioned warning for all filters.

The query that is executed gets three rows from the database but report builder is not able to hold the values.

I dont know why this is happening. Can you please help me out?

Thanks,

I don't understand how you were able to use a custom data processing extension with Report Builder which can report only from SQL Server, Oracle, and SSAS. Can you explain?

My custom dataprocessing extension is nothing but a connection to my application database (SQL Server, Oracle). I use DPE so that I can filter the data sent back to the client. I have some methods in my framework which would do the filtering part and send the data back to report server.

Fine, but how you connect the CDPE to the Report Builder?

I create reports in report builder based on the Models which use my CDPE  as datasource. So whenever report builder tries to connect to the datasource it lands up in CDPE.

Perhaps, I am a bit slow today but I still don't undestand. When you create a data source in a Report Model project, it lets you choose between SQL Server and Oracle providers only. How did you plug in your CDPE?

Hi...

Perhaps, I am bit slow.. I did not understand the question. But now I got it.

When we create a datasource in report model project we just hook it up with a sample database and once it is deployed to the report server we change the datasource to CDPE..

I hope this will set aside the confusion.

Yea I know thats a pure hack... but couldnt find a way out... so had to go for it...

I know what the query looks like.. and its perfect (as i want it to be)... and it sends back the data as well... but the report builder is not able to hold the values..

may be it knows its hacked

Have you tried something more civilized, such as using a stored procedure (regular or CLR) for DSV tables?