Recent content by dellguy

Hello all - we are running an older version of Crystal Reports Server v11.5 and I was hoping there is a way to not have to update each report in the repository due to a database connection name change defined in each report (400+ of them) So is there a configuration setting on the server side...

Hello all. CRYSTAL REPORTS 2016 Support Pack 7 Patch 5 v 14.2.7.3248 Just ran into something very strange. I have a dynamic parameter that is populated from the command file query for the report. The parameter is a multi-select list of employees. There are a couple employees that are in...

Any creative ideas or ways to accomplish something similar to a subreport calling a subreport? I know drilling down to a lower group level works well but my client wants to: #1. start with a consolidated financial income statement #2. drill down an income or expense line to the divisional...

I already made a manual crosstab in case no solution was available. I'll give your crosstab workaround a try and let you know. I prefer a crosstab so it handles additional limits going forward. Thanks LB, I can always count on you to reply and offer a solution. Regards, LME

Hello all I've been trying to create something like this. It is basically a crosstab of departments & approvers versus the spend limits. I want to show the names of the staff that fall under each dollar value within department. Each summary could be multiple staff names. My current...

Oracle 11g R1 - which I see doesn't support LISTAGG. I still need help to figure this out please.... [bigsmile]

still got the same error SELECT Arinvt.Itemno , LISTAGG ( Master_Spec.Code, '; ') WITHIN GROUP (ORDER BY Arinvt.Itemno) Item FROM Iqms.Ord_Detail Ord_Detail LEFT OUTER JOIN Iqms.Arinvt Arinvt ON Ord_Detail.Arinvt_Id = Arinvt.Id LEFT OUTER JOIN Iqms.Orders Orders...

We use Oracle 11g. This is what happens with LISTAGG. Can you see something wrong?? SELECT "ARINVT"."ITEMNO", LISTAGG( "MASTER_SPEC"."CODE", '; ') WITHIN GROUP (ORDER BY "ARINVT"."ITEMNO") "ITEM" FROM ((("IQMS"."ORD_DETAIL" "ORD_DETAIL" LEFT OUTER JOIN...

Hello all. I am trying to figure out how to write SQL to group data by common values together after they've been identified and assembled together. Using the following sample data, DATA ORDERS TABLE ID 100 ORDER DETAIL TABLE ID 200 Orders_ ID 100 Part_ID 500 PART...

I do not want to have to manually re-import 100+ reports anytime I make a change to the common subreport.

kray4660 - have you used the "Re-import when opening" feature of a subreport before?

Crystal Reports XI I created a subreport that will be the common header for several reports. This subreport contains Date/Time, a logo and a field from a parameter containing the report name. Then from the main report, I insert the subreport and make it "Re-import when opening". All that...

@LB: Tried your code and now I get the same error on "HIST_ARINVT_ELEMENTS"."STD_COST". So I changed it to A."STD_COST" and then it complained about C."ARINVT_ID" (same error). ???

This is the actual SQL Expression that is not working. I get a ORA-00904 "ARINVOICE"."INVOICE_DATE": Invalid identifier ( SELECT "HIST_ARINVT_ELEMENTS"."STD_COST" FROM "HIST_ARINVT_ELEMENTS" WHERE "HIST_ARINVT_ELEMENTS"."ID" = ( (SELECT...

I'm using CR XI on Oracle 10g. I can not get a SQL Expression to work. Are subqueies (select within a select) allowed in SQL Expressions?