Search results for query: *

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?

Hello!!! I am using Crystal Reports 2008, Business Objects Enterprise XI R3 with Oracle 10g I have developed a business view (BV) that feeds a dynamic cascading prompt. This issue is tied to the top level prompt in the cascade. The BV data foundation has a couple formula fields. 1)...

That would be a huge design change to the report. I looked at using a subreport as well but that won't work either. I think I'm going to see if the end user will accept a different grouping (one level less). That will have to do. I've spent too much time on this already. Thx LB

If I understand your question, you can use a filter against a field in the LEFT OUTER JOINed tables but have to check for NULLS first. i.e. WHERE (ISNULL(FIELD-a) OR FIELD-a = PARAMETER-a)

OK LB, this worked great !! However, I need to limit the select in the {%maxdt} SQL expression to FROM DATE and TO DATE parameters used for the overall report. How do I do that? Thanks!!

Hi LB. I fiddled around with your suggestion a bit today and think I can make it work but got tied up with something else today. I really appreciate your help whenever I post. Thanks to fisheromacse too !! Cheers!! :o)