Tabular References in ReportNet

[stacybost]

Has anyone used tabular references in ReportNet? I don't intuitively see how to use these, and there's no instruction in the documentation. How does one use this object?

Thanks,
Stacy

 

[lincon]

you can set its property [Query] as existing query.
Now you can use it like a tabular.Add the query item in above level

 

[stacybost]

Thanks lincon.

I couldn't figure out how to add dimensions and facts to the query from the Tabular Reference. Finally noticed today that the query items are available to drag into the Query from the Insertable Objects pane.

However, I've been trying to add a filter in the Query, and it doesn't appear to work. Have you had any luck with that? I'm using a stored procedure as the data source.

 

[lincon]

You can see SQL Statement of Query,whethere the genarated sql have your filter or not