Questions tagged [crystal-reports]

For questions regarding Crystal Reports, a business intelligence application by SAP SE.

Filter by
Sorted by
Tagged with
2
votes
1answer
53 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
30 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
71 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
45 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
60 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
999 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
131 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
261 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
888 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
1k 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
858 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
193 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&...