I am trying to get my final output as pdf. I connected to oracle sql and queried the data and that data i am trying to export to pdf. for say i have 10 columns in my table when i try to export all those columns to pdf only 3 columns are being exported .
below is my code:
library(RODBC) library(tidyverse) library(knitr) options(tinytex.verbose = TRUE) con <- odbcConnect("******")
dth <- sqlQuery(con, paste("select a,b,c,d,e,f,g,h from *******")) kable(dth)
i am able to get all the records in pdf output but not the columns. only 3 columns data i am getting. can somebody help me on this.