About satech

satech

I have a table that looks like this.I group the records by category and a few formula fields (calculated based on menu name).I need to generate a report like thisGroup - A (e.g.: gls red)Subgroup of Group A (e.g.: 6 oz)menu_name, storeId1_qty, storeI...

satech

There are eight locations, each operating the same client/server application with identical SQL Server database schemas, including tables and stored procedures.Currently, the same report is run at each location, utilizing the same fields. Locally, ea...

satech

Followed https://userapps.support.sap.com/sap/support/knowledge/en/3049912. CR crashes on step 4 Under the tab "Advanced", define each text files you want to use as a Table by clicking on the button "Define..." Symptom is the TextFile window cl...

satech

Hello world, first post here! Plan to evaluate Crystal Report Server. Before evaluation, want to know if the product works well with multiple DBs with same name and schema. Basically, there is an application installed on multiple sites. As it's t...

satech

Thanks! I decided to use SQL to group, and use SUM to get quanitiy for store_id

satech

Thanks. I ended up writing new SQL and building an intermediary db. The application's SQL was badly written, too many SELECTs that should be consolidated.

satech

Thanks, Don.

satech

Thanks Dell for the information!I cannot create views on existing database, as it will void the service agreement. But I can create a database on the CRS that has views accessing other databases. I will give it a try.The challenge is, among all of th...

User Statistics

User Activity

Running total based on column values

Best practice to connect to multiple databases (Crystal Report)

CR 2020 crash on ODBC TextFile

Crystal Report Server: connect to DBs with same name and schema

Re: Running total based on column values

Re: Best practice to connect to multiple databases (Cryst...

Re: CR 2020 crash on ODBC TextFile

Re: Crystal Report Server: connect to DBs with same name and schema