Excluding Records That Exist In Another TableGet selected records in Crystal Reports from SQL TablesConditional Format Detail Row If Record Exists In Another TableHow to use Parameter field in a record selection “like” statement?crystal report: Manage serial number excluding duplicate rowsSpecial field record number in crysal report not show when record does not existCrystal Reports set record number in formulacrystal reports conditional record selection with formulasCrystal Reports LIKE [a-z][0-9][a-z][a-e]SQL query generated by Crystal Reports works in SSMS but pulls no records in Crystalcrystal reports retrieve a value based on another value in same table
How does Asimov's second law deal with contradictory orders from different people?
Should students have access to past exams or an exam bank?
Can I shorten this filter, that finds disk sizes over 100G?
What is the name of this type of figure?
The grades of the students in a class
How can a class have multiple methods without breaking the single responsibility principle
The Enigma Machine (CLI) in Java
How to derive trigonometric Cartesian equation from parametric
Why should I use a big powerstone instead of smaller ones?
Derivative is just speed of change?
Can I say "Gesundheit" if someone is coughing?
Russian pronunciation of /etc (a directory)
Backpacking with incontinence
How do discovery writers hibernate?
Novel - Accidental exploration ship, broadcasts a TV show to let people know what they find
Disease transmitted by postage stamps
Why doesn't this proof show that the operation on a factor group is well-defined?
Is this mechanically safe?
Is it unprofessional to mention your cover letter and resume are best viewed in Chrome?
How do Canadians get a visa to go to Saudi Arabia?
IBM mainframe classic executable file formats
Return last number in sub-sequences in a list of integers
How to structure presentation to avoid getting questions that will be answered later in the presentation?
"DDoouubbllee ssppeeaakk!!"
Excluding Records That Exist In Another Table
Get selected records in Crystal Reports from SQL TablesConditional Format Detail Row If Record Exists In Another TableHow to use Parameter field in a record selection “like” statement?crystal report: Manage serial number excluding duplicate rowsSpecial field record number in crysal report not show when record does not existCrystal Reports set record number in formulacrystal reports conditional record selection with formulasCrystal Reports LIKE [a-z][0-9][a-z][a-e]SQL query generated by Crystal Reports works in SSMS but pulls no records in Crystalcrystal reports retrieve a value based on another value in same table
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I am building a report in Crystal Reports 2013 and would like to exclude all records that exist in an external Excel file. I have connected both my database and excel file to the report. The Key fields are Exceptions_.Employee # and Command.Employee_ID.
The Key fields are Exceptions_.Employee # (excel) and Command.Employee_ID. (SQL DB). I added the this code to Record Selection Formula, and I get no records
Exceptions_.Employee #=Command.Employee_ID
I expect that the results that are displayed do not match the ones in the excel file. I double-checked manually and should get around 200 records.
crystal-reports
asked Mar 26 at 22:53
OmarOmar
11 bronze badge
add a comment |
I am building a report in Crystal Reports 2013 and would like to exclude all records that exist in an external Excel file. I have connected both my database and excel file to the report. The Key fields are Exceptions_.Employee # and Command.Employee_ID.
The Key fields are Exceptions_.Employee # (excel) and Command.Employee_ID. (SQL DB). I added the this code to Record Selection Formula, and I get no records
Exceptions_.Employee #=Command.Employee_ID
I expect that the results that are displayed do not match the ones in the excel file. I double-checked manually and should get around 200 records.
crystal-reports
asked Mar 26 at 22:53
OmarOmar
11 bronze badge
You have to fixed it first i guess in datatable or something..My question what did you do that excel data and sql data put together in crystal report.? are you using DataTable?
– Vijunav Vastivch
Mar 27 at 6:28
add a comment |
I am building a report in Crystal Reports 2013 and would like to exclude all records that exist in an external Excel file. I have connected both my database and excel file to the report. The Key fields are Exceptions_.Employee # and Command.Employee_ID.
The Key fields are Exceptions_.Employee # (excel) and Command.Employee_ID. (SQL DB). I added the this code to Record Selection Formula, and I get no records
Exceptions_.Employee #=Command.Employee_ID
I expect that the results that are displayed do not match the ones in the excel file. I double-checked manually and should get around 200 records.
crystal-reports
asked Mar 26 at 22:53
OmarOmar
11 bronze badge
I am building a report in Crystal Reports 2013 and would like to exclude all records that exist in an external Excel file. I have connected both my database and excel file to the report. The Key fields are Exceptions_.Employee # and Command.Employee_ID.
The Key fields are Exceptions_.Employee # (excel) and Command.Employee_ID. (SQL DB). I added the this code to Record Selection Formula, and I get no records
Exceptions_.Employee #=Command.Employee_ID
I expect that the results that are displayed do not match the ones in the excel file. I double-checked manually and should get around 200 records.
crystal-reports
crystal-reports
asked Mar 26 at 22:53
OmarOmar
11 bronze badge
asked Mar 26 at 22:53
OmarOmar
11 bronze badge
asked Mar 26 at 22:53
OmarOmar
11 bronze badge
asked Mar 26 at 22:53
OmarOmar
11 bronze badge
asked Mar 26 at 22:53
OmarOmar
11 bronze badge
11 bronze badge
You have to fixed it first i guess in datatable or something..My question what did you do that excel data and sql data put together in crystal report.? are you using DataTable?
– Vijunav Vastivch
Mar 27 at 6:28
add a comment |
You have to fixed it first i guess in datatable or something..My question what did you do that excel data and sql data put together in crystal report.? are you using DataTable?
– Vijunav Vastivch
Mar 27 at 6:28
You have to fixed it first i guess in datatable or something..My question what did you do that excel data and sql data put together in crystal report.? are you using DataTable?
– Vijunav Vastivch
Mar 27 at 6:28
You have to fixed it first i guess in datatable or something..My question what did you do that excel data and sql data put together in crystal report.? are you using DataTable?
– Vijunav Vastivch
Mar 27 at 6:28
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
);
);
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%2f55367334%2fexcluding-records-that-exist-in-another-table%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
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
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.
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%2f55367334%2fexcluding-records-that-exist-in-another-table%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
You have to fixed it first i guess in datatable or something..My question what did you do that excel data and sql data put together in crystal report.? are you using DataTable?
– Vijunav Vastivch
Mar 27 at 6:28