From a Cognos newbie: I am displaying multiple charts per page and the charts are appearing in different sizes - heights are ok but the widths are varying in size based on values displayed on y-axis, where smaller y-values causes the chart width to increase relative to others. I tried applying...
I need to pass a string parameter to crystal reports from reportname.rpt "myparm'. How can I do that?
how can I export crystal report to an excel file
Recently, I installed Crystal Reports (I believe version 8.5) on my Windows 7 PC. But when I tried to launch it, I got the following error: Crystal Reports Execution Denied. Solomon IV Registration check failure - Soloman IV not running (SWIMAPI.DLL is not found). What should I do here?
I have a rather large stored procedure to develop. The procedure is going to be used in a large crystal report. I was wondering if you can design a stored procedure using a with clause. I used CTE on SQL Server but that doesn't seem to be an option.
Failed to Retrieve data from the database. Details: ADO Error Code: 0x80040e14 Source: Microsoft OLE DB Provider for Oracle Description: ORA-06550: Line 1, Column 7: PLS-00201: identifier 'WHSP_USER.SP_RPT_DAILY_LANE_EXCEPTION' must be declared ORA-06550: Line 1, Column 7: PL/SQL: Statement ignored...
I have a SQL view that links my contact table to my address table. In the view there is a field signifying "address_type". It could be mailing, location, business, home etc. When I run the query I get three records for this contact because they have mailing, location and business addresses. Is...
How can I access database and retrieve the image in Crystal Report?
hi i wanna to save crystal reports as excel form so can anyone help me
When I export my Crystal report to "Excel 97-200 - Data only", some row fields in the spreadsheet contain different data than the report shows. The wrong exported data is from other records in the group. When exported as a PDF the data is as it appears in the report. Why is the data incorrect in...
Hi everyone, For Crystal Reports, can I retrieve the record count of my subreport? It's within my main report. Thanks so much.
Hello, Before I ask my question, I just want to let you know that this is for Crystal Reports. I recently added a new field to my stored procedure. How do I get that available in CR? I don't want to reset the data source. Thanks!
I keep getting error 0x80040e07 conversion failed when converting date and / or time from character string - how to resolve this error? - Please help!
I need some help here - I'm using Crystal Reports. And with the editor, can I align my text to the center (of the text box)? I don't want it at the top. Thanks for the help.
I noticed that in my Crystal Report, it keeps generating a blank last page. The only thing on it is the page footer (shows current page). I noticed that it's only happening when all my information completely fills up the second to last page. Why is this happening?
In Crystal Reports, would I be able to convert a number to a word (basically it's written equivalent)? Is there a function I can use?
I'm currently using Crystal Reports 11. I have fields being pulled from my table but I noticed that it has special characters in it. Is there a way for me to remove those characters? Thanks.
Does anyone know how to change the orientation in Crystal Reports? I want to change it to the Landscape orientation. It's currently in portrait orientation.
I have created a Crystal Report and when I'm adding fields into the database, it keeps outputting a blank report. Is there a way for me to debug my report? Even possibly an error log so I can see what's going on. Thanks!
Hello, Would I be able to reset the page group (per group) in Crystal Reports? Usually - one group has roughly 10 pages of data. Thanks so much.