http://www.sqlpower.ca/forum/forums/show/227.page JForum - http://www.jforum.net
a) Is it possible to export reports to excel?

b) Is it possible to master-detail reporting (interactive reporting)?]]> http://www.sqlpower.ca/forum/posts/preList/2804/6352.page http://www.sqlpower.ca/forum/posts/preList/2804/6352.page GMT
]]> http://www.sqlpower.ca/forum/posts/preList/2773/6292.page http://www.sqlpower.ca/forum/posts/preList/2773/6292.page GMT http://www.sqlpower.ca/forum/posts/preList/2772/6289.page http://www.sqlpower.ca/forum/posts/preList/2772/6289.page GMT
I am very new to Wabit BI, so please bare with me :-)

I need to create query using multiple criteria selected by user at time the report is requested, i.e NAME and DATE RANGE. I have watched the tutorials, but cannot completely determine whether this is possible.

Also, I then need to add these reports/graphs to an existing website i designed.

Looking forward to you assistance.

Friedl]]> http://www.sqlpower.ca/forum/posts/preList/2766/6279.page http://www.sqlpower.ca/forum/posts/preList/2766/6279.page GMT
I installed Wabbit for the first time and every thing went perfect till the first click on wabbit whet my win7 64bit with latest Java eviorement returned this
[quote]Could not create the Java virtual machine[/quote] error.

Anyone has any idea from where to start?

Thank for your help,

Roland

--update--
Just to mention that the other SQL Power solution like "SQL Power Architect " work without hikups]]> http://www.sqlpower.ca/forum/posts/preList/2762/6271.page http://www.sqlpower.ca/forum/posts/preList/2762/6271.page GMT Have made progress and able to do all as narrated in the guide. Able to connect to datasource,cube, xml/a (pentaho). Able to create new workspace and also create new queries (relational and olap).When i try to view through http://localhost:8080/wabit-enterprise/static/thin-client/index.html I am unable to view any contents. Am i missing something here? Appreciate your help.
Regards ]]> http://www.sqlpower.ca/forum/posts/preList/2698/6072.page http://www.sqlpower.ca/forum/posts/preList/2698/6072.page GMT Is SQL power Wabit usable on Mobile? If so, could you point me to the appropriate resource / guide?
Appreciate your time.
Regards
]]> http://www.sqlpower.ca/forum/posts/preList/2682/6033.page http://www.sqlpower.ca/forum/posts/preList/2682/6033.page GMT Hello I am pretty new to Wabit. Just downloaded the Enterprise version and started the server but when I log in with browser, it just hangs.
The lag says Looking at JCR workspace.

any clue....]]> http://www.sqlpower.ca/forum/posts/preList/2662/5983.page http://www.sqlpower.ca/forum/posts/preList/2662/5983.page GMT
regards,
kreso

Using Wabit 0.9.9.]]> http://www.sqlpower.ca/forum/posts/preList/2563/5738.page http://www.sqlpower.ca/forum/posts/preList/2563/5738.page GMT
I think it would be nice if you could link reports somehow in Wabit. So if I have 5 reports created, the 'master' report could somehow have hyperlinks to the other subreports. Right now, Wabit can really only customize columns, but this feature would require a properties panel for individual records.

Keep up the good work!
Steve]]> http://www.sqlpower.ca/forum/posts/preList/2551/5701.page http://www.sqlpower.ca/forum/posts/preList/2551/5701.page GMT
java.lang.NullPointerException
at com.microsoft.sqlserver.jdbc.SQLServerStatement.clearColumnsValues(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.cancelUpdates(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(Unknown Source)
at ca.sqlpower.sqlobject.SQLTable.fetchTablesForTableContainer(SQLTable.java:1570)
at ca.sqlpower.sqlobject.SQLCatalog.populateImpl(SQLCatalog.java:171)
at ca.sqlpower.sqlobject.SQLObject.populate(SQLObject.java:249)
at ca.sqlpower.sqlobject.SQLObject.getChildCount(SQLObject.java:319)
at ca.sqlpower.wabit.swingui.tree.WorkspaceTreeModel.getChildCount(WorkspaceTreeModel.java:190)
at javax.swing.tree.VariableHeightLayoutCache$TreeStateNode.expand(Unknown Source)
at javax.swing.tree.VariableHeightLayoutCache$TreeStateNode.expand(Unknown Source)
at javax.swing.tree.VariableHeightLayoutCache.ensurePathIsExpanded(Unknown Source)
at javax.swing.tree.VariableHeightLayoutCache.setExpandedState(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI.updateExpandedDescendants(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI$Handler.treeExpanded(Unknown Source)
at javax.swing.JTree.fireTreeExpanded(Unknown Source)
at javax.swing.JTree.setExpandedState(Unknown Source)
at javax.swing.JTree.expandPath(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI.toggleExpandState(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI.handleExpandControlClick(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI.checkForClickInExpandControl(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI$Handler.handleSelection(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI$Handler.mousePressed(Unknown Source)
at javax.swing.plaf.basic.BasicTreeUI$MouseHandler.mousePressed(Unknown Source)
at ca.sqlpower.swingui.MultiDragTreeUI$MouseHandler.mousePressed(MultiDragTreeUI.java:52)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Any help would be appreciated. As I mentioned I am just learning SQL and Wabit so I am probably missing something simple. Thanks.]]> http://www.sqlpower.ca/forum/posts/preList/2536/5670.page http://www.sqlpower.ca/forum/posts/preList/2536/5670.page GMT
I hope this suggestion useful for you.

Click the link to see the examples:

http://rapidshare.com/files/296192927/Pic1.JPG.html

http://rapidshare.com/files/296193458/Pic2.JPG.html

http://rapidshare.com/files/296193628/Pic3.JPG.html


]]> http://www.sqlpower.ca/forum/posts/preList/2525/5651.page http://www.sqlpower.ca/forum/posts/preList/2525/5651.page GMT
I'm making reports in Wabit, and I noticed that when you drag in an OLAP results table, and then increase the font size of the header, the titles will start to 'spill' out of the blue shaded area and into the white area of the results. Is there any way to easily change the blue area column size?

As well, I was wondering if it's possible to change the colour of the header column of olap results tables to anything other than blue? I like the colour choice, but it may not totally fit with my report (the same thing goes for charts).

Thanks,
Steve]]> http://www.sqlpower.ca/forum/posts/preList/2503/5583.page http://www.sqlpower.ca/forum/posts/preList/2503/5583.page GMT
I'm working with latest Wabit, and am trying to produce a simple time series category line chart using an OLAP data source with a year and half of data.

Right now, it groups similarly named months together, making a spike in the first six months of data (where there are two records). But what I'd like to see is 18 months of categories that are somehow labelled to indicate the month and year (without the year repeating for every month, but being labelled only once for the group of months). Is this possible, somehow?

Thanks,
Steve]]> http://www.sqlpower.ca/forum/posts/preList/2501/5580.page http://www.sqlpower.ca/forum/posts/preList/2501/5580.page GMT I'm using Wabit 0.9.9 on Windows and I have the problem that in the properties of a label I can't use the left and right arrows on my keyboard and I can't use Ctrl-A, Ctrl-X, double click or any of the features I'm used to text areas in other programs (like this forum, address bar in a browser,...) It would make my work a lot easier if I could use them.

Thanks,
Benjamin]]> http://www.sqlpower.ca/forum/posts/preList/2485/5545.page http://www.sqlpower.ca/forum/posts/preList/2485/5545.page GMT