I have created a query that reads from a table with a pass-through to a Sybase dB. I am trying to generate a report based on this query.
This financial data dealing with portfolio's.
When I set a criteria for portfolio 1234, the report is generated with no problems.
If I do not set a criteria for portfolio to 1234, the report requests a Portfolio Number (which I want to have happen). I type in 1234. The report generates a completely different report then the one I need.
I am trying to create ad-hoc reports for different client portfolios based on portfolio numbers.