Search results for query: *

Did you try to print something from Word, Excel or any other program using this user credentials ? www.R-Tag.com Viewer, scheduler and report manager for Crystal reports and SSRS. Send your report everywhere.

You can resolve the problem by instructing the SQLEngine to use a specific collation. For example: select ... from Table1 t1 inner join Table2 t2 on (t1.ID= t2.ID COLLATE SQL_Latin1_General_CP1_CI_AS) You can replace SQL_Latin1_General_CP1_CI_AS with the right collation or use the database...

As far as I know this is not possible with the regular cross-tab. You can create a manual cross-tab or use an OLAP grid. I don't know if this will be a solution for your scenario, but you can also use an Ad-hoc query with a pivot table similar to Excel pivot table. It supports details natively...

If you are replacing the exported file you are accepting the risk to provide old information (if the replacement fails) and also you cannot provide historical data. One solution is each time to create an unique file name for example using date and time as part of the name. However this will...

ridhirao22, some 3rd party viewers/schedulers (including our software) support bursting. However, BO provides this option too. You can use single pass or multi pass bursting. As far as I understand your report has a parameter to select a country. You can either remove it, modify the report to...

I can see 2 possible reasons: you are not using LEFT JOIN or you are not handling correctly the null values on Crystal Reports side What is vWorkstation_Program_Details - table or view ? If it is a view can you post the SQL ? What is the SQL for the report ? www.R-Tag.com Viewer...

You need to use bursting: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8077811e-7637-2e10-7c9f-dcb81d630b5c?QuickLink=index&overridelayout=true www.R-Tag.com Viewer, scheduler and report manager for Crystal reports and SSRS. Send your report everywhere.

You can avoid using view by using a subquery and a command . www.R-Tag.com Viewer, scheduler and report manager for Crystal reports and SSRS. Send your report everywhere.

You can do this inside crystal reports using arrays , but database is much better for queries than Crystal reports. I would create a view like this : SELECT CASE WHEN condition = 'OPEN' THEN instr_date ELSE close_date END as RecordDate, <other columns here ...> FROM tablename This view will...

I guess the easiest way to install the application is to create a VB6 setup project. It will install and register all the dependencies. This document might be helpful: http://resources.businessobjects.com/support/communityCS/TechnicalPapers/rdcXI_deployment.pdf www.R-Tag.com Viewer...

If you already have the report working and it is developed using the database expert you will need to rewrite it to use a command. If you cannot rewrite it you can check this video for another way to handle the case: http://www.r-tag.com/Pages/Preview_Demo.aspx (from the menu in left select...

Crystal reports will try to convert a simple record selection formula to a WHERE clause and send it to the database. However if you are using specific crystal reports functions in the record selection formula it will be very likely that Crystal will send a flat SQL without a WHERE clause to the...

As Ian proposed, create a command and use it as a datasource for your dynamic parameter. You will see 2 parameter dialogs: the first dialog will ask for a text value , which will be used in the command to retrieve the list of values for the dynamic parameter. Once the LOV is prepared crystal...

If you don't have subreports you can create a report with a multivalue parameter , add your current report as a subreport and pass the multivalue parameter from the main report to the subreport using a formula, which will join the values - for example Join({?Account},','). The value send to the...

Are you with Win 7? I don't know if the problem is related to JavaScript but you can dig in this direction. Check this article: http://www.ehow.com/how_8132036_enable-javascript-windows-7.html www.R-Tag.com Viewer, scheduler and report manager for Crystal reports and SSRS. Send your report...

Do you have issues on a developer machine or you need just to run the reports ? If you need just to run the reports we have a free viewer, which is not using Crystal report parameters dialog. You can use it until you resolve your issues. www.R-Tag.com Viewer, scheduler and report manager for...

You can use a system restore point to restore your system to the point before Firefox installation. If this is not possible I would try to install Chrome or upgrade IE. www.R-Tag.com Viewer, scheduler and report manager for Crystal reports and SSRS. Send your report everywhere.

Parameters dialog is shown using the default browser. Did you change it soon? If you have multiple browsers installed try to temporary change the default one and see if this will resolve the issue. If yes you will need to fix the browser not Crystal. www.R-Tag.com Viewer, scheduler and report...

You can find detailed comparison for some crystal reports viewers here: http://kenhamady.com/viewerfeaturematrix.pdf Some of the products are designed to be used in a network and support roles and permissions , which will allow you to manage the reports available to each of your users. Also...

You can use Crystal Viewer 2011 to refresh reports if you have a license for CR Server. Otherwise this application is just a viewer in a way similar to Adobe Reader - you can use it to view static report files created by other applications. There are some free and paid viewers on the market...