[Unsolved]How to get column names from CSV file in tabular sql

[mrcool]

Hi frnds,

Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  can any1 help me in getting column names from CSV file in tabular SQL.Waiting for ur reply.



Thanks,
S

[mrcool]

HI frnds waiting 4 ur reply...

[Draoued]

if you are in reportnet , I suppose you first need to add the CSV file to Framework manager.

Then you can rename the column in Framework manager, and in tabular sql , you can access the columns like a normal package field.

If you are not defining the csv in a framework package , I think you have at least to add a data source reference into Connection , to know where the file is.

[sir_jeroen]

Mrcool...
One important note:

replies like

HI frnds waiting 4 ur reply...

are not appreciated.
Don't start pushing people to answer your question, because all is done on a free basis. If you want your problems to be solved quickly... call one of the following numbers:

United States
   Ph: 800-426-4667
          781-229-6600
   Fx: 781-229-9844           
Canada
  Ph: 613-738-1440
  Fx: 613-738-0002

   
Europe
   Ph: +44 1344 486668
   Fx: +44 1344 485124           

Asia/Pacific
   Ph: 02-9430-2200
   Fx: 02-9438-1641
  Freecall: 1 800 264 667 


Otherwise wait for some one to reply.

And btw read the board rules

[mrcool]

thnx,we will call u...

the report is created in tabular sql .when i choose a language in run option according the defined language the report should display column names in that language. this is working for when the report is in tabular model.but if the report is in tabular sql the column names are not displaying in the defined language.what is the solution for this..


Thnx,
S

[BIsrik]

try using a tabular model over the tabular sql...

srik

[sir_jeroen]

MrCool...
Sorry but maybe I'm understanding you wrong, but it seems to me that you don't take any notice of my reply? Am I wrong? Do you think that we are here especially for you???

[mrcool]

we need to generate the report only in tabular SQL not in tabular model...

[MFGF]

If you use a tabular model for your report, you can take advantage of all the work done in Framework Manager to resolve multilingual data, usually implemented by adding macros into the SQL of data query subjects.
If you use tabular SQL, you're bypassing all of this and therefore losing all this functionality in your report.  I'm afraid if you must use Tabular SQL, you're going to have to do a lot of hard work to implement multilingual column headings.  It's probably going to be easiest to use a language variable and conditional values for each of your column headings.

Probably not what you wanted to hear, but that's one of the penalties of using Tabular SQL...

Regards,

MF.

[kalyan_sekhar1]

Hi MRCOOL,

ReportNet ADDICT is rite, as every body helping each other and inturn to make the forum more intresting. I can understand u r urgency. Dont push too hard.

But this is general tendency to be eager when some one is not replying, as u can see the ReportNetAddict got kicked off when no one appreciated his hard work for tutorials.

Hope u can understand

bye

[mrcool]

Hi frnds,

Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  can any1 help me in getting column names from CSV file in tabular SQL.Waiting for ur reply.



Thanks,
S

[MFGF]

Hi Mrcool,

Did you try defining a language variable in your report and using conditional values for each of your column headings as I suggested earlier?Ã,  Although it's some effort to set up, it should work...

Just a little confused as to why you have closed the topic unsolved???

Regards,

MF.

[mrcool]

Thnx MFGF....I know this sol...but i need another aproach which the heading come from CSV file..for that reason I kept Unsolved..



Thanks,
S