Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [crystal-reports]

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

2
votes
1answer
50 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
20 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
46 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
31 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
57 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
899 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
128 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
232 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
812 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
990 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
846 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
191 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&...