I have two tables I am trying to get into one query, but I can't figure out how to do it.
What I need is a final result with all 4 of the answer fields on the same line as the each one of the question fields.
Table 1 - Answers
Answer_ID Question_ID Answer_Text Correct
1 1...
I have a CR 10 report where I have created two NumberVars and need to add them together and can't figure out the code to do it. Here's what I have so far:
First NumberVar Formula Q1 -
WhilePrintingRecords;
If {GetSurveyReportValues;1.QuestionId} = 970 then
Shared NumberVar SE1 := Sum...
I have two tables that I need to get data from
Objects:
PubID ModuleID Name CreatedDate
123456 620 Briefs 2/21/2007 2/21/2007
123455 620 Briefs 2/20/2007 2/20/2007
123454 620 Briefs 2/19/2007...
I have been struggling with this for a while trying to format the strselect string properly to execute the select command on an access database using a asp.net web application. I can't get it formatted the right way to bind the datagrid. Here is what I started with:
condb = New...
I am stuck. I have some vars being passed to an aspx page though a post method, and I am reading them through the request.form("varname") for each. I need to dump into a db table in multiple rows, how do I do it? I am going into a SQL database using VS.Net 2003. I was hoping to do a bulk insert...
I have a colum in an SQL db that is the total time that it takes someone to complete an online assessment, but it's stored as a string. An example would be 1:45. So it took them one minute forty five seconds to complete the test.
How do I convert that to a number first then to total seconds...
Crystal 10
MS SQL DB
I have a report that has a main report and a sub report, that shows survey responses. I have four db tables I am using. One has questions, one has answers, one has voter information, and the last has voter answers.
The way that I am having to report is the main report has...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.