Changing Table Header at runtime

Greetings!
I am new to BIRT and trying to switch form Crystal Reports.
We are using ASP for web development. I have created a report on XML document. The report is fine.
I have Following columns code,name,City01,City02
Now I want that when report is executed or called or run, I should take table headers from a text file and display in report instead of City01 and City02. Lets say London instead of City01 and New York instead of City02.
If it is possible to change them from ASP.Net then please advise the steps that how would I access it from ASP.NET.

As I am new comer so I need your help.
Thanks!
M.MaShaAllah

Find more posts tagged with

Comments

mwilliams

Hi M.MaShaAllah,

So, in your XML dataSet, the cities will be defines as CITY01 and CITY02? Then, you'll also have access to a text file dataSet with the actual city names you want to use? Is this correct? Let me know.

toeen1

Dear William
Greetings!
Thank you very much for your reply and concern for the issue.
You are right. But the text file Dataset would also have the same column names as the xml data set I mean City01,City02 etc. It would only have one data row which will contain the Actual City Names here is the sample text file.

Code,Name,Unit,City01,City02
STRING,STRING,STRING,DECIMAL,DECIMAL
"1234","Names","M","London","Paris"

Now I want to display the data values as table header.
I tried this but we are to use joined dataset.
In the end I came to conclusion that I would have to use report scripting,Report Object Model (ROM), to access the report and change table header. And I can not do this from ASP.NET. Moreover One can not deploy a BIRT report on IIS as it does not cater servlets. Therefore, it seems more difficult to use BIRT along with ASP.NET.
If anybody have an advise Please do.
Thanks!
M.MaShaAllah

mwilliams

Hi M.MaShaAllah,<br />
<br />
This devShare post shows how to use Actuate BIRT and its JSAPI to call BIRT reports from ASP.NET. This isn't OS BIRT, but it is possible with commercial BIRT at least. If I find out more, I'll let you know.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/896-call-jsapi-from-asp-net-pages/#description'>Call JSAPI from ASP.NET pages - Designs & Code - BIRT Exchange</a>

toeen1

Dear Willaim
Greetings and thank you very much for your reply.
Though I am able to display column headers from flat file data set. Just Place a Grid above table and show the data row in the grid.

I am moving to BIRT as it is open source and does not apply heavy license fee. It seems to me superior to Crystal Reports also.

Now it seems to me that I should have to completely shift to Java technologies.

Thanks!
M.MaShaAllah

mwilliams

M.MaShaAllah,

Always glad to attempt to help!

Let us know whenever you have questions.