Questions tagged [crystal-reports]
For questions regarding Crystal Reports, a business intelligence application by SAP SE.
13
questions
1
vote
0answers
26 views
Crystal reports executing system procedure
I have many reports executing from Crystal reports 10 using ODBC connection on SQL Server 2008R2 database which are consuming memory.
As per the SQL Profiler I can see when a crystal reports session ...
2
votes
1answer
96 views
Log report 'bad password', but still grants access
Original symptom: User sa locked out, too many bad attempts.
Problem was sudden (no issues before), and pervasive (couple of fails in one day).
As this was a new roll out of SQL backend to Sage300, ...
0
votes
1answer
89 views
What's called 'Universe Data Source' in Crystal Reports?
There are several options to choose which data source we want to connect in Crystal Reports including SAP BEx, Relational Connection, and Universe. I have difficulties in understanding what exactly do ...
0
votes
1answer
253 views
Read only replica part of always on availability group for Reporting
As a DBA I would like to include a read only replica into the always on availability group. XSLT / Crystal Reports will only be used.
Please see below
1) Primary Replica (Same Data center) ...
2
votes
1answer
48 views
Report transition from Access to Crystal (multiple queries)
I have just started a new job where I am responsible for building and improving reports.
There is one report I am trying to move from Access to Crystal. The data is stored in an application called ...
1
vote
1answer
70 views
Safe Cast in Crystal Reports Comparison
Using Crystal Reports version 14.0.3.613RTM
With SQL Server 2012 onward, if a field has both number and string data, I can use try_convert to compare, i.e.
TRY_CONVERT(int, resource_code) > ...
1
vote
1answer
1k views
SSRS, Limit Fixed number of Columns in Matrix within a Tablix - issue in sorting matrix data
I am converting a crystal report to ssrs report, i am trying to implement "Format With Multiple Columns" feature of crystal report to ssrs.
I have a Main tablix that has two Two Groups
1st Group - ...
1
vote
1answer
140 views
How to retrieve subtotal for order lines (rollup does not exist in sql 2000)
Currently in a crystal report I have each order grouped together where the user is displayed the order lines in the orders group. I have made a running total field for a subtotal for all of the order ...
1
vote
1answer
672 views
Converting a Crystal Report Formula to a CASE expression
With attempting to convert a crystal report formula into a SQL CASE expression, I seem to be having trouble understanding the concept of "total_pallet_weight" and "order_no" utilizing the "AND" in the ...
0
votes
1answer
2k views
SQL - Passing a Stored Procedure Variable as a Parameter in a crystal report for end users to select
OK I know there are hundreds of posts out there that state how to pass a parameter from a stored procedure to a crystal report. But unfortunately with some research I haven't come across a specific ...
3
votes
3answers
2k views
I am getting a failed login message in the SQL Server error logs however, nothing actually failed?
I have a server which runs third party software (called Visualcut) to email Crystal Reports to our users.
When I log onto the Visualcut Server, I can open the software and then preview a report. This ...
2
votes
3answers
875 views
Monthly backup of SQL server DB to PostgreSQL?
The company I'm working for has a SQL Server with read-only access. They use Crystal Reports hooked up to PostgreSQL for reporting. Is there any way to make it so I can move all the data from the ...
2
votes
0answers
225 views
Can't add field that begins with an underscore in Crystal Reports
There's a field in a FoxPro table that I'm trying to pull in a Crystal Report (v10), and it begins with an _ and it doesn't appear in Field Explorer->Fields->Database Fields-><table-name&...