Hi...

I want to add a new report for Work Logs.  I have a SQL Query that I've created and want to use that.  I've read in forum that I can add under "Other Reports".  However, when I go to Manage Reports, I do not see any options under Other Reports.  When I expand Work Log Reports, I can add another Shortcut but it does not allow me to add my own SQL query.

Any help is appreciated.

Divyesh

Are you connecting through Remote Server?  Currently you can only create/edit reports if you connect directly to SQL, it does not work through Remote Server.

---

Dan Suceava
http://www.axosoft.com

Hi Dan...

 I am not using  Remote Server... When you say I have to directly connect to SQL, what does that mean?

 Divyesh

Divyesh - Are you unchecking the "Automatically filter...." checkbox?  This will enable the fields to enter the SQL 'select' and 'order by'.

Connecting OnTime directly to SQL rather than connecting through Remote Server.  If you're not using Remote then you should be able to add new reports, assuming you have the proper security permissions.

---

Dan Suceava
http://www.axosoft.com

Hi Dan...

I must be missing something.  I am using the web based application to go to Manage Reports.  I have admin permission to the app.  Is there suppose to be a "thick" client as well?

You cannot create reports through Web, only through the Windows client.  You would need the Windows client if you want to create custom reports.

---

Dan Suceava
http://www.axosoft.com

Hi Dan...

I was able to create report using Windows Client and create shortcut.  I can now see it in Web Client... However, when I run it I get following error message...

 Any idea.. It works fine in Windows Client.  Also where do I setup Printer in Report Setup?

Exception Details
Id:	245	Type:	ApplicationException	Source:	ActiveReports.Viewer
Target:	Void -d13(System.String, System.String, Single, Single)	Date:	2/7/2008 11:33 AM
Message:	Failed to open the Default printer is not set. printer, System error number: 1801
Stack Trace:	at DataDynamics.ActiveReports.Document.DDPaperSize.-d13(String printerName, String paperName, Single width, Single height) at DataDynamics.ActiveReports.Document.DDPaperSize..ctor(String printerName, String paperName, Single width, Single height) at DataDynamics.ActiveReports.ActiveReport.-1c3() at DataDynamics.ActiveReports.ActiveReport.-d03(Boolean bDelayedInit) at DataDynamics.ActiveReports.ActiveReport.Run(Boolean syncDocument) at DataDynamics.ActiveReports.ActiveReport.Run() at Axosoft.OnTime.Reports.AxoActiveReport.RunReport() at Axosoft.OnTime.Reports.Designer.ReportViewer.ExportActiveReport(AxoActiveReport report)

There is currently an issue with the reports where if you change the paper size or margins, when running the report ActiveReports tries to look at the default printer to make sure it supports those settings.  This means that if the computer where the report is run does not have a printer installed you'll get that error.  The only workaround is to try to install a printer driver on that machine.  Or not change the settings of the report.

This issue will be fixed in the next release so that a printer won't need to be installed.

---

Dan Suceava
http://www.axosoft.com

Hi Dan.... The computer where the report is run from does have printer installed and a default set.  Also the IIS server has default printer setup.

I'll try with page settings.

 Thanks