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.
For the past several hours, I've been trying to open my report in Crystal Report 11 but it keeps hanging / freezing. It's not loading my report at all. I used my friend's machine and it still didn't work. Can anyone help?
I need some advice / help here. Does anyone know how to create a bullet list in Crystal Reports? I can't find any way to do it. Is there a code for this? Thank you.
Hello, I have Visual Studio 2012 installed. I have to create a report so I also installed Crystal Report. But it's not showing up anywhere. It's not in my toolbox. What should I do? Thank you.
I'm trying to create a pivot table in Crystal Reports. I'm currently using a ODBC connection but I'm not sure the right way to do it. Can anyone help? What's the process?