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!
|
|
Tab data load issue
Posted: 05 Nov 07 11:04 AM
|
I have created a tab inside more tabs on opportunities, when i click on it though, no data diaplays, just the grid. If i run the query against the DB there is data that should be returning but its not. I have selected what fields to return, and it has a SQL statement in the properties, am i missing something else that Is hould be doing to get it to call the function to return the data?
Thanks |
|
|
|
Re: Tab data load issue
Posted: 05 Nov 07 12:11 PM
|
I am assuming you need show values for the tab that are only related to current opportunity. So then do the following:
You will need to set the bindid property to display the data for the current opportunity and straighten up your sql property to look into bindID also. |
|
|
|
Re: Tab data load issue
Posted: 05 Nov 07 12:43 PM
|
| Try throwing in a DataGrid1.Refresh on the WhenShow of the form. |
|
|
| |
|
Re: Tab data load issue
Posted: 05 Nov 07 12:57 PM
|
| is the problem that i am trying to look at it from the opportunities more tabs? instead of from the list view? and if so, how would I add the data form to the opportunities list view? |
|
|
| |
|
Re: Tab data load issue
Posted: 05 Nov 07 1:47 PM
|
SELECT A1.OPPORTUNITYID, A2.USERNAME A2_USERNAME, A1.TYPE, A1.DESCRIPTION, A1.CREATEDATE, A1.ESTIMATEDCLOSE, A1.SALESPOTENTIAL, A1.CLOSEPROBABILITY, A1.STAGE, A1.STATUS, A1.SECCODEID FROM OPPORTUNITY A1 INNER JOIN USERINFO A2 ON (A1.ACCOUNTMANAGERID=A2.USERID) WHERE ((A1.STATUS='Closed - Won') OR (A1.STATUS='Open')) AND (A1.TYPE='Managed Print Solution') ORDER BY A1.DESCRIPTION ASC, A1.CLOSEPROBABILITY DESC
ive tried it with different bindid's doesnt work any way i try to manipulate it. |
|
|
|
Re: Tab data load issue
Posted: 05 Nov 07 1:54 PM
|
Try this. Place a button on that screen that will message box the DataGrid1.SQL property. I suspect that the SQL it is actually running is not what you expect. The opportunity table has the SECCODEID field. Security might be applied so that the user you are running as will not see the result.
This would explain why it works against the database and not as a user. |
|
|
| |
|
Re: Tab data load issue
Posted: 05 Nov 07 3:30 PM
|
| I want to say no. But I would try running the SQL statement you got from the message box and examine the result. To easily copy and paste the SQL try this. Add a memo control and change the button code. Instead of using a message box. Set the Text property of the memo control to the DataGrid1.SQL. that way you can copy and paste the actually SQL. |
|
|
|
Re: Tab data load issue
Posted: 05 Nov 07 4:01 PM
|
| How would I make this data form into a List View tab for opportunities? |
|
|
|
Re: Tab data load issue
Posted: 05 Nov 07 4:22 PM
|
There is a way to create the table without having security applied to it. The way I believe this works is that, if the base table has the field SECCODEID in it security is applied at run time. To get around this you need to set the base table as some other table that is a one to one with the opportunity table. For Example Opportunity_ext. You might have to create this table. The only catch here is you will have to make sure in all cases the opportunity_ext table has a record for all opportunities.
This will not work on remotes unless you sync all opportunities. |
|
|
|
Re: Tab data load issue
Posted: 13 Dec 07 1:27 PM
|
I'm having a very similar problem. I'm trying to add a tab to the Sales Dashboard that displays a datagrid with some data (unrelated to the SalesDashboard table). My SQL is correct. A test button returns the correct SQL (Datagrid1.SQL). The Datagrid1.Recordset.RecordCount returns the correct count of records.
The datagrid is just blank, however. The column headings aren't even appearing.
Anyone seen anything like this?
Edit: Heh, nevermind, the datagrid boundaries somehow went outside the form. Silly mistake.  |
|
|
|