CDATA ADO Connection with Crystal Reports not showing data
0
I have VS2015 solution with Crystal Reports and CData Ado.net connection for the dataset. I have followed the instructions but my crystal report has three tables with two linked tables. The report fires and works with just the primary table but when i add the additional two tables the report does not work any more. I have tried inner join and left outer join on the crystal reports.
My code looks like this:
{
SmartsheetDataAdapter dataAdapter = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_TempOrders", connection);
DataSet set = new DataSet("_set");
DataTable table = set.Tables.Add("_table");
dataAdapter.Fill(table);
report.SetDataSource(table);
SmartsheetDataAdapter dataAdapter1 = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_Suppliers", connection);
DataSet set1 = new DataSet("_set1");
DataTable table1 = set1.Tables.Add("_table1");
dataAdapter.Fill(table1);
report.SetDataSource(table1);
SmartsheetDataAdapter dataAdapter2 = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_Project", connection);
DataSet set2 = new DataSet("_set2");
DataTable table2 = set2.Tables.Add("_table2");
dataAdapter.Fill(table2);
report.SetDataSource(table2);
}
TempOrders is the primary table. Any ideas on this?
c# crystal-reports ado.net cdata smartsheet-api
asked Nov 23 '18 at 22:58
Andrew LittleAndrew Little
64
add a comment |
0
I have VS2015 solution with Crystal Reports and CData Ado.net connection for the dataset. I have followed the instructions but my crystal report has three tables with two linked tables. The report fires and works with just the primary table but when i add the additional two tables the report does not work any more. I have tried inner join and left outer join on the crystal reports.
My code looks like this:
{
SmartsheetDataAdapter dataAdapter = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_TempOrders", connection);
DataSet set = new DataSet("_set");
DataTable table = set.Tables.Add("_table");
dataAdapter.Fill(table);
report.SetDataSource(table);
SmartsheetDataAdapter dataAdapter1 = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_Suppliers", connection);
DataSet set1 = new DataSet("_set1");
DataTable table1 = set1.Tables.Add("_table1");
dataAdapter.Fill(table1);
report.SetDataSource(table1);
SmartsheetDataAdapter dataAdapter2 = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_Project", connection);
DataSet set2 = new DataSet("_set2");
DataTable table2 = set2.Tables.Add("_table2");
dataAdapter.Fill(table2);
report.SetDataSource(table2);
}
TempOrders is the primary table. Any ideas on this?
c# crystal-reports ado.net cdata smartsheet-api
asked Nov 23 '18 at 22:58
Andrew LittleAndrew Little
64
Is the repeateddataAdapter.Fill(...)a typo? It should bedataAdapter1.Fill(..)anddataAdapter2.Fill(...)for the 2nd and 3rd calls. Can you explain what you mean when you say "the report does not work any more"? Are you seeing an error message? If so, can you let us know what the error message is?
– Jerod Johnson
Nov 26 '18 at 16:41
I tried both dataadapter and what you did too. The Crystal reports just displays a blank report with no data. I wonder if the report.SetDataSource is not the issue. I tried setting the 3 tables into one line but it creates an overload on SetDataSource
– Andrew Little
Nov 27 '18 at 12:56
i found a reference topic that recommended this code: report.Database.Tables[0].SetDataSource(table); report.Database.Tables[1].SetDataSource(table1); report.Database.Tables[2].SetDataSource(table2); When i did this i got an error on the group function, once i deleted the group some of the data worked but it appears to have losted the linking between the tables as table1 is loading first in the report not table. Not sure how to solve that one problem
– Andrew Little
Nov 27 '18 at 13:30
Can you edit your question to add the new code and share the exact error message you're seeing?
– Jerod Johnson
Nov 27 '18 at 15:00
Hi Jerod, thanks for your help, your support team has reached out to me and working with them on this currently.
– Andrew Little
Nov 27 '18 at 21:14
add a comment |
0
0
0
I have VS2015 solution with Crystal Reports and CData Ado.net connection for the dataset. I have followed the instructions but my crystal report has three tables with two linked tables. The report fires and works with just the primary table but when i add the additional two tables the report does not work any more. I have tried inner join and left outer join on the crystal reports.
My code looks like this:
{
SmartsheetDataAdapter dataAdapter = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_TempOrders", connection);
DataSet set = new DataSet("_set");
DataTable table = set.Tables.Add("_table");
dataAdapter.Fill(table);
report.SetDataSource(table);
SmartsheetDataAdapter dataAdapter1 = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_Suppliers", connection);
DataSet set1 = new DataSet("_set1");
DataTable table1 = set1.Tables.Add("_table1");
dataAdapter.Fill(table1);
report.SetDataSource(table1);
SmartsheetDataAdapter dataAdapter2 = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_Project", connection);
DataSet set2 = new DataSet("_set2");
DataTable table2 = set2.Tables.Add("_table2");
dataAdapter.Fill(table2);
report.SetDataSource(table2);
}
TempOrders is the primary table. Any ideas on this?
c# crystal-reports ado.net cdata smartsheet-api
asked Nov 23 '18 at 22:58
Andrew LittleAndrew Little
64
I have VS2015 solution with Crystal Reports and CData Ado.net connection for the dataset. I have followed the instructions but my crystal report has three tables with two linked tables. The report fires and works with just the primary table but when i add the additional two tables the report does not work any more. I have tried inner join and left outer join on the crystal reports.
My code looks like this:
{
SmartsheetDataAdapter dataAdapter = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_TempOrders", connection);
DataSet set = new DataSet("_set");
DataTable table = set.Tables.Add("_table");
dataAdapter.Fill(table);
report.SetDataSource(table);
SmartsheetDataAdapter dataAdapter1 = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_Suppliers", connection);
DataSet set1 = new DataSet("_set1");
DataTable table1 = set1.Tables.Add("_table1");
dataAdapter.Fill(table1);
report.SetDataSource(table1);
SmartsheetDataAdapter dataAdapter2 = new SmartsheetDataAdapter(
"SELECT * FROM Sheet_Project", connection);
DataSet set2 = new DataSet("_set2");
DataTable table2 = set2.Tables.Add("_table2");
dataAdapter.Fill(table2);
report.SetDataSource(table2);
}
TempOrders is the primary table. Any ideas on this?
c# crystal-reports ado.net cdata smartsheet-api
c# crystal-reports ado.net cdata smartsheet-api
asked Nov 23 '18 at 22:58
Andrew LittleAndrew Little
64
asked Nov 23 '18 at 22:58
Andrew LittleAndrew Little
64
asked Nov 23 '18 at 22:58
Andrew LittleAndrew Little
64
asked Nov 23 '18 at 22:58
Andrew LittleAndrew Little
64
asked Nov 23 '18 at 22:58
Andrew LittleAndrew Little
64
64
Is the repeateddataAdapter.Fill(...)a typo? It should bedataAdapter1.Fill(..)anddataAdapter2.Fill(...)for the 2nd and 3rd calls. Can you explain what you mean when you say "the report does not work any more"? Are you seeing an error message? If so, can you let us know what the error message is?
– Jerod Johnson
Nov 26 '18 at 16:41
I tried both dataadapter and what you did too. The Crystal reports just displays a blank report with no data. I wonder if the report.SetDataSource is not the issue. I tried setting the 3 tables into one line but it creates an overload on SetDataSource
– Andrew Little
Nov 27 '18 at 12:56
i found a reference topic that recommended this code: report.Database.Tables[0].SetDataSource(table); report.Database.Tables[1].SetDataSource(table1); report.Database.Tables[2].SetDataSource(table2); When i did this i got an error on the group function, once i deleted the group some of the data worked but it appears to have losted the linking between the tables as table1 is loading first in the report not table. Not sure how to solve that one problem
– Andrew Little
Nov 27 '18 at 13:30
Can you edit your question to add the new code and share the exact error message you're seeing?
– Jerod Johnson
Nov 27 '18 at 15:00
Hi Jerod, thanks for your help, your support team has reached out to me and working with them on this currently.
– Andrew Little
Nov 27 '18 at 21:14
add a comment |
Is the repeateddataAdapter.Fill(...)a typo? It should bedataAdapter1.Fill(..)anddataAdapter2.Fill(...)for the 2nd and 3rd calls. Can you explain what you mean when you say "the report does not work any more"? Are you seeing an error message? If so, can you let us know what the error message is?
– Jerod Johnson
Nov 26 '18 at 16:41
I tried both dataadapter and what you did too. The Crystal reports just displays a blank report with no data. I wonder if the report.SetDataSource is not the issue. I tried setting the 3 tables into one line but it creates an overload on SetDataSource
– Andrew Little
Nov 27 '18 at 12:56
i found a reference topic that recommended this code: report.Database.Tables[0].SetDataSource(table); report.Database.Tables[1].SetDataSource(table1); report.Database.Tables[2].SetDataSource(table2); When i did this i got an error on the group function, once i deleted the group some of the data worked but it appears to have losted the linking between the tables as table1 is loading first in the report not table. Not sure how to solve that one problem
– Andrew Little
Nov 27 '18 at 13:30
Can you edit your question to add the new code and share the exact error message you're seeing?
– Jerod Johnson
Nov 27 '18 at 15:00
Hi Jerod, thanks for your help, your support team has reached out to me and working with them on this currently.
– Andrew Little
Nov 27 '18 at 21:14
Is the repeated
dataAdapter.Fill(...) a typo? It should be dataAdapter1.Fill(..) and dataAdapter2.Fill(...) for the 2nd and 3rd calls. Can you explain what you mean when you say "the report does not work any more"? Are you seeing an error message? If so, can you let us know what the error message is?– Jerod Johnson
Nov 26 '18 at 16:41
Is the repeated
dataAdapter.Fill(...) a typo? It should be dataAdapter1.Fill(..) and dataAdapter2.Fill(...) for the 2nd and 3rd calls. Can you explain what you mean when you say "the report does not work any more"? Are you seeing an error message? If so, can you let us know what the error message is?– Jerod Johnson
Nov 26 '18 at 16:41
I tried both dataadapter and what you did too. The Crystal reports just displays a blank report with no data. I wonder if the report.SetDataSource is not the issue. I tried setting the 3 tables into one line but it creates an overload on SetDataSource
– Andrew Little
Nov 27 '18 at 12:56
I tried both dataadapter and what you did too. The Crystal reports just displays a blank report with no data. I wonder if the report.SetDataSource is not the issue. I tried setting the 3 tables into one line but it creates an overload on SetDataSource
– Andrew Little
Nov 27 '18 at 12:56
i found a reference topic that recommended this code: report.Database.Tables[0].SetDataSource(table); report.Database.Tables[1].SetDataSource(table1); report.Database.Tables[2].SetDataSource(table2); When i did this i got an error on the group function, once i deleted the group some of the data worked but it appears to have losted the linking between the tables as table1 is loading first in the report not table. Not sure how to solve that one problem
– Andrew Little
Nov 27 '18 at 13:30
i found a reference topic that recommended this code: report.Database.Tables[0].SetDataSource(table); report.Database.Tables[1].SetDataSource(table1); report.Database.Tables[2].SetDataSource(table2); When i did this i got an error on the group function, once i deleted the group some of the data worked but it appears to have losted the linking between the tables as table1 is loading first in the report not table. Not sure how to solve that one problem
– Andrew Little
Nov 27 '18 at 13:30
Can you edit your question to add the new code and share the exact error message you're seeing?
– Jerod Johnson
Nov 27 '18 at 15:00
Can you edit your question to add the new code and share the exact error message you're seeing?
– Jerod Johnson
Nov 27 '18 at 15:00
Hi Jerod, thanks for your help, your support team has reached out to me and working with them on this currently.
– Andrew Little
Nov 27 '18 at 21:14
Hi Jerod, thanks for your help, your support team has reached out to me and working with them on this currently.
– Andrew Little
Nov 27 '18 at 21:14
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53453691%2fcdata-ado-connection-with-crystal-reports-not-showing-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53453691%2fcdata-ado-connection-with-crystal-reports-not-showing-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Is the repeated
dataAdapter.Fill(...)a typo? It should bedataAdapter1.Fill(..)anddataAdapter2.Fill(...)for the 2nd and 3rd calls. Can you explain what you mean when you say "the report does not work any more"? Are you seeing an error message? If so, can you let us know what the error message is?– Jerod Johnson
Nov 26 '18 at 16:41
I tried both dataadapter and what you did too. The Crystal reports just displays a blank report with no data. I wonder if the report.SetDataSource is not the issue. I tried setting the 3 tables into one line but it creates an overload on SetDataSource
– Andrew Little
Nov 27 '18 at 12:56
i found a reference topic that recommended this code: report.Database.Tables[0].SetDataSource(table); report.Database.Tables[1].SetDataSource(table1); report.Database.Tables[2].SetDataSource(table2); When i did this i got an error on the group function, once i deleted the group some of the data worked but it appears to have losted the linking between the tables as table1 is loading first in the report not table. Not sure how to solve that one problem
– Andrew Little
Nov 27 '18 at 13:30
Can you edit your question to add the new code and share the exact error message you're seeing?
– Jerod Johnson
Nov 27 '18 at 15:00
Hi Jerod, thanks for your help, your support team has reached out to me and working with them on this currently.
– Andrew Little
Nov 27 '18 at 21:14