[Sibeesh VenuParticipant]

Hi Peter,
Thanks a lot for the reply. That’s sad. And in the toolbar demo the search is applicable for only the particular column. I want the search option to be focused on all columns with only one search box. Is there any way I can do that? Please reply me.
Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Hi Dimitar,

Thanks a lot for the reply . Please follow the link for the js fiddle . You may find the code looks not good. I need some suggestion to improve that too. Looking for war to hear from you. Please be noted that the output I need is like the image below.

http://jsfiddle.net/Sibeesh/nyj7rcLs/3/

Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

HI I am asking about what should be the format for columns: [{}] for the below mentioned table.

Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Hi Peter,
Thanks a lot for the info You have given me a light . Thank you. I will find it and work on it.
Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Hi Peter,
Sorry for the mistake. And thanks a lot for the info Do you have any demo for the same in Dot Net? Can you please say me the steps to do the same and which are all the files I may need to add? Waiting for the reply. Thanks in advance
Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Hi Dimitar,
I have got the license for JQWidgets under the mail id rajesh@customeranalytics.com. And we are developing this product for a client, I have talked with them regarding to host those export files in their server. They said they don’t have any server which supports PHP, we are using dot net as our platform, it supports dot net pages alone. My client is not ready to install PHP as well. Is there any fix you can provide me for this problem? I have already contacted Mr.Peter from your team,I am waiting for the reply for the past 3 days.Please reply me asap. Thank you.

Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Hi Dimitar,
can’t we call export like this?
`$(“#jqxgrid”).jqxGrid(‘exportdata’, ‘xls’, title, true, null, true, ‘http://localhost:58020/save-file.php’);
I have already got the licensed version , and placed in the root directory.

Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Hi Dimitar,
When I try export as Excel , I am getting this error “The server closed the connection without sending any data.” .Is there any limitation of data that we can export as excel in JQX Grid? I am having around 8k records in that particular grid. Can you please help me with this? Thanks in advance .

Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Hi Dimitar,
I have found out what is the problem, in the image you can see a column called “Product Margin – Excluding Outliers (%) “ , actually my data set has it like Product Margin – Excluding Outliers (%).So (–) is being converted to the – while exporting.

Kindest Regrads
Sibeesh

[Sibeesh VenuParticipant]

Hi Dimitar,

I have already solved it. Thanks a lot for the reply. I am facing an another issue. Now i have given my cell format as “d”. And the grid is formulated. But there is no 1000 formatting for the column values which are all contains $ with it. And also when i export as excel , those columns which has $ values is showing blank. Any idea to solve this. Any help is appreciated.
Best Regards,
Sibeesh

[Sibeesh VenuParticipant]

Hi ,
I have populated a grid, actually the data source has only one data,but still grid loads with additional empty rows. Even though it is not visible, it created some empty space in my UI area. Please note the below image.

I am saying about these empty divs. Is there any way i can remove these?

Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Dear Dimitar,

Thanks a lot for the reply. The solution you have given was ok. But the thing is in that i need to set quantity as string. So the default filtering options are loaded for the string type. Anyway i have solved the issue. Thanks a lot.
And While printing some of the columns are getting cut. Any solution for that?
Thanks And Regards
Sibeesh

[Sibeesh VenuParticipant]

Dear Dimitar,

Thanks a lot for the reply. Why i am getting an output like this even i gave the cell formatting as D while excel export. Can you please help me with that?

Backoffice Systems Database & BI
Availability $3,407,606.00 $3,407,606.00

NB: I have tried with d,d0,d1 also
Thanks And Regards
Sibeesh

[Sibeesh VenuParticipant]

Dear Dimitar,

Thanks a lot for the reply. Is it possible to disable that option, since my data source already have a numbers with thousands separators, i don’t want that to happen again in client side. So i would like to disable that property. In which js i need to comment those lines.

Thanks And Regards
Sibeesh

[Sibeesh VenuParticipant]

Dear Dimitar,

Thanks a lot for the reply. Yeah i helped me a lot. But now i am facing an another issue, that JQX grid is taking only the first number from a number as data. Eg: it is taking 3 only from 3,407,413. I think comma is the problem. Is there anything i need to do separately for this. Please reply.

Thanks And Regards
Sibeesh

[Author]

Posts