7/5/2025 1:30:37 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Custom Report in web not showing same data as lan
Posted: 03 Aug 09 9:51 AM
|
| SLX 7.5.1 - When running the same report in the web vs. the lan with no added filters in either, I am seeing different results - the lan is showing more records. has anyone seen this type of behavior from reports in the slx web? Thanks |
|
|
|
Re: Custom Report in web not showing same data as lan
Posted: 03 Aug 09 9:57 AM
|
Steve:
Are the reports being run by the same user?
If they are, the next step will be to run the SLX Profiler and capture the query being executed to try and determine what is different. If the queries are the same, it could go back to the Crystal Web Server.... |
|
|
|
Re: Custom Report in web not showing same data as lan
Posted: 03 Aug 09 10:17 AM
|
Run by the same user - the profiler shows the same query. The thing that is different is the series of queries that follow..
In the both cases this query is run and returns 28 records in both cases:
SELECT "OPPORTUNITY"."DESCRIPTION", "OPPORTUNITY_EXT"."LOCATION", "OPPORTUNITY"."SALESPOTENTIAL", "OPPORTUNITY_EXT"."ESTIMATE_NUMBER", "OPPORTUNITY"."OPPORTUNITYID", "OPPORTUNITY_EXT"."BID_DATE", "OPPORTUNITY_EXT"."PREBID_DATE", "OPPORTUNITY_EXT"."ESTIMATOR", "OPPORTUNITY"."STATUS", "OPPORTUNITY_EXT"."BID_AMOUNT", "OPPORTUNITY_EXT"."BID_TYPE", "OPPORTUNITY_EXT"."REGION", "ACCOUNT"."ACCOUNT", "OPPORTUNITY_EXT"."DIVISION", "OPPORTUNITY"."NOTES" FROM ("sysdba"."OPPORTUNITY" "OPPORTUNITY" LEFT OUTER JOIN "sysdba"."OPPORTUNITY_EXT" "OPPORTUNITY_EXT" ON "OPPORTUNITY"."OPPORTUNITYID"="OPPORTUNITY_EXT"."OPPORTUNITYID") INNER JOIN "sysdba"."ACCOUNT" "ACCOUNT" ON "OPPORTUNITY"."ACCOUNTID"="ACCOUNT"."ACCOUNTID" WHERE ("OPPORTUNITY"."STATUS"='Bidding' OR "OPPORTUNITY"."STATUS"='Letter of Intent' OR "OPPORTUNITY"."STATUS"='Pending' OR "OPPORTUNITY"."STATUS"='Proposal in Progress' OR "OPPORTUNITY"."STATUS"='Proposal Pending' OR "OPPORTUNITY"."STATUS"='Short List') AND (("OPPORTUNITY_EXT"."ESTIMATOR"='Smith, Chris' OR "OPPORTUNITY_EXT"."ESTIMATOR"='Smith, Tony' OR "OPPORTUNITY_EXT"."ESTIMATOR"='Smith, Jim' OR "OPPORTUNITY_EXT"."ESTIMATOR"='Smith, Joe') OR ("OPPORTUNITY_EXT"."REGION"='Federal Markets' OR "OPPORTUNITY_EXT"."REGION"='Pittsburgh')) AND "OPPORTUNITY_EXT"."DIVISION"<>'Environmental Services'
Then a series of queries are run based on oppID. The web runs 20, the lan runs 28.. The queries are similar to this with the oppid changing for each:
SELECT "OPPORTUNITY_CONTACT"."SALESROLE", "ACCOUNT"."ACCOUNT", "OPPORTUNITY"."OPPORTUNITYID" FROM (("sysdba"."OPPORTUNITY" "OPPORTUNITY" INNER JOIN "sysdba"."OPPORTUNITY_CONTACT" "OPPORTUNITY_CONTACT" ON "OPPORTUNITY"."OPPORTUNITYID"="OPPORTUNITY_CONTACT"."OPPORTUNITYID") INNER JOIN "sysdba"."CONTACT" "CONTACT" ON "OPPORTUNITY_CONTACT"."CONTACTID"="CONTACT"."CONTACTID") INNER JOIN "sysdba"."ACCOUNT" "ACCOUNT" ON "CONTACT"."ACCOUNTID"="ACCOUNT"."ACCOUNTID" WHERE "OPPORTUNITY_CONTACT"."SALESROLE"='JV Partner' AND "OPPORTUNITY"."OPPORTUNITYID"='O6UJ9A000581'
So the lan is returning more records.. odd.. |
|
|
|
Re: Custom Report in web not showing same data as lan
Posted: 03 Aug 09 10:29 AM
|
Are those queries for Subreports?
Or are those queries for Groups (e.g. you have a Group by Opportunity section).
If so, is the report setup to group on the DB Server? Can you change toggle that setting?
Do all these records contain matching data on the Opportunity_Extension table? |
|
|
| |
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|