Data Extension - Parameters ?

Hi,
I've just created a custom data extension for Reporting Services, which
works fine. Now, I want to support parameters. I correctly implemented
IDbParameter and IDbParameterCollection but they don't seem to be
called at anytime...
Any sample about implementing parameter support ?
Thanks in advance.
Best regards,
JulienNote that in order to support using parameters in your data extension (in
the report designer), you must also implement the IDbCommandAnalysis
interface, which parses the command text and returns the list of parameters
contained in the query.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1117728338.575235.15190@.g49g2000cwa.googlegroups.com...
> Hi,
> I've just created a custom data extension for Reporting Services, which
> works fine. Now, I want to support parameters. I correctly implemented
> IDbParameter and IDbParameterCollection but they don't seem to be
> called at anytime...
> Any sample about implementing parameter support ?
> Thanks in advance.
> Best regards,
> Julien
>|||Thanks, now I implemented IDbCommandAnalysis, parameters are now
correctly passed to my data extension. I thought IDbCommandAnalysis
wasn't mandatory, since it is called by the Reporting Services designer
to know which params are to be asked to the user.
Thanks,
Julien

Data #ERROR in Report Manager but not Designer

Hi,

I'm running a report using MDX. In preview, the report displays correctly, but after deploying to Report Manager, where there were once numbers there is now '#Error'. The string fields display correctly, its just the numeric ones that are not working.

Any help is much appreciated.

Cheers,

Ali

Is anything coming back from the cube? Are dimension values being retrieved correctly?

It sounds as if the connectivity may not be working between the server and the cube.

|||Yes, a list of zones are coming back from the cube. It's their associated measures that are displaying the error.|||

Is there any security on the cube?

Also, is it a matrix or tabular layout?

|||

There's not really too much security. There is one user who has access to everything and this is the credentials used in the data source.

The report uses a table and it has previously worked on a 2000 server but has recently migrated to 2005 (referencing a 2000 cube with a 2005 dll). Other similar reports using the same dll have migrated fine, except for one which keeps asking for a user name and password.

I've copied the code from the dll and added into the dataset and am still getting the same errors.. so the problem isn't with the dlls..|||

Well, that exhausted my short list of possibilities.

Are numeric cells using any type of formula? Aggregate can be a bit flaky.

|||

I know.. its confusing ey!!

and get this.. when i try it on our production 2005 server .. it works! Something funky is going on.