you have to use sp_executesql
select @query= 'SELECT * FROM OPENQUERY(olap_server, '@Start + [@ItemId]+ ', [Items].[Item Sku] ) }...
select @nquery=cast(@query as nvarchar(400))
EXEC sp_executesql @nquery
Hello I'm looking for expert in Crystal reports 9 making reports on a OLAP cube
How to parameterize the display of row and column?
Example:
three dimension
Products
Country
Turnover and Budget
Banana
Costa Rica 20000 25000
Senegal 15000 15600
Colombia 14000...
Hello I'm looking for expert in Crystal reports 9 making reports on a OLAP cube
How to parameterize the display of row and column?
Example:
three dimension
Products
Country
Turnover and Budget
Banana
Costa Rica 20000 25000
Senegal 15000 15600
Colombia 14000...
Hello, I have a simple report showing details and a summary in a group.
The problem is that when the user click on the summary, it open an other page showing the details of the summary.
How can I make the click disable on a summary?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.