maeklong Posted March 3, 2011 Share Posted March 3, 2011 Please help me...It didn't work. Link to comment Share on other sites More sharing options...
pwd Posted March 3, 2011 Share Posted March 3, 2011 The report query needs to return something in order for the report to have pages. Link to comment Share on other sites More sharing options...
maeklong Posted March 3, 2011 Author Share Posted March 3, 2011 Can I send string message to show on the report directly, without any database query? Link to comment Share on other sites More sharing options...
cbarlow3 Posted March 4, 2011 Share Posted March 4, 2011 You don't have to actually display the results of your query, but if your report truly doesn't have any data in it from any query, I'm not sure iReport is the best tool. Neverthelesss, here are two tips:1. If you're not going to display anything in the detail band, make sure you click on the root element of your report at the top of the tree in the Report Inspector pane. Then go to the Properties pane, find the property "When No Data", and select "All Sections, No Detail" from the dropdown. I think the default is "No Pages".2. Secondly, I think you might still need a query, even if it practically does nothing. If you have a table that you know only has a single row (like a table of environment parameters--current date, etc.), you might try selecting a single field from that table:SELECT ENV.POSTING_DATE FROM CORE.ENV AS ENV in my database.Or, if you really want to do practically nothing and your SQL dialect supports Common Table Expressions (CTE's), you might try this as your query: WITH fakeTable (fakeField) AS (values 0) SELECT fakeField FROM fakeTableHope that helps! Carl Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now