ASP.NET

Re: Unable To Export Sub-report Data In Excel Format????

14-Mar-10 20:25

Use ExcelRecord instead in Excel.
i.e. ExportFormatType.ExcelRecord

for eg:
ReportDocument.ExportToHttpResponse(ExportFormatType.ExcelRecord, Response, true, "Report");

Sandeep Mewara14-Mar-10 20:41

Re: Unable To Export Sub-report Data In Excel Format????

14-Mar-10 20:41

Till SSRS 2005: This is a known limitation in the excel rendering. The problem occurs when subreports and/or any data regions are nested in table/matrix. Microsoft I mean SSRS doesn’t support exporting these to Excel format.

Other way to get it done is:
Embed the sub report within a rectangle rather than within a table. It will export ok.

P.S.: SSRS 2008 (shipped as part of SQL Server 2008) provides a full solution to this, since it has a new engine and rendering extensions. Excel rendering will now always render subreports contents.

Rameez Raja14-Mar-10 23:39

Rameez Raja

14-Mar-10 23:39

Thanks for reply,

ok iam placing the sub report into list control instead of Table then it works am i right?

but in sub report Data is populating inside Matrix control then is it ok ?????/?

Regards

Re: Unable To Export Sub-report Data In Excel Format????

Sandeep Mewara15-Mar-10 9:04

Crystal Report Starked Bar Chart - Setting of Color

15-Mar-10 9:04

Yes it should work.
In SSRS 2005, subreports embedded in tables does not export properly in excel.

HatakeKaKaShi14-Mar-10 15:59

HatakeKaKaShi

14-Mar-10 15:59

Hey guys need advice

Currently i am using CR chart for my report however i need to set the color of the stacked bar, I can only set the color when using color by group. However i need to use color by series as i am using stacked bar.....

any ideas or solution. Please advise!

Thanks Bros

KaKaShi HaTaKe

how to perform delete and update the images in gridview control using asp.net with c# with sqlserver 2005

developerit14-Mar-10 3:50

Re: how to perform delete and update the images in gridview control using asp.net with c# with sqlserver 2005

14-Mar-10 3:50

iam having many fields in table which includes images fiels also.

how to update and delete the images from database using asp.net with c#

can you give me a simple example which helps me.

Sandeep Mewara14-Mar-10 3:56

Re: how to perform delete and update the images in gridview control using asp.net with c# with sqlserver 2005

14-Mar-10 3:56

Here is the link that will help you out:
Inserting and Retrieving images from SQL Server Database using C#[^]
Just change the query to insert/update/delete based on your need.

CP is~~We are~~ building this repository of asking Q&A in CodeProject. Asking questions here[^] would help you in tracking you and other people who face something similar. Try it. You can also mark answers as accepted if it resolves your issue.

modified on Sunday, March 14, 2010 12:30 PM

Not Active14-Mar-10 6:00

Not Active

14-Mar-10 6:00

Sandeep Mewara wrote:
We are building this repository

We? I don't seen you as a member of the CP staff or even much of a contributor.

I know the language. I've read a book. - _Madmatt

Re: how to perform delete and update the images in gridview control using asp.net with c# with sqlserver 2005

Sandeep Mewara14-Mar-10 6:32

Re: how to perform delete and update the images in gridview control using asp.net with c# with sqlserver 2005

14-Mar-10 6:32

Updated! that didn't mean the way you took... yet!

BTW: I thought every member of CP is a contributor and very much a part of CP...

modified on Sunday, March 14, 2010 1:00 PM

developerit14-Mar-10 19:30

Re: how to perform delete and update the images in gridview control using asp.net with c# with sqlserver 2005

14-Mar-10 19:30

i want the same solution in asp.net with c# in web application not in windows application

dan!sh 14-Mar-10 3:57

dan!sh

14-Mar-10 3:57

It would be same as you would delete any other record from the database. A quick google search should reveal it.

how to search from database when user enter any table value in textbox control

developerit14-Mar-10 3:46

Re: how to search from database when user enter any table value in textbox control

14-Mar-10 3:46

hi, iam using asp.net 2.0 with c# with ajax and database is sql server.

so when iam using a textbox control when user enter the any part of column or any filed in the text box it should come like popup in the textbox from database . can you give me a simple example which helps me.

Sandeep Mewara14-Mar-10 3:51

Re: how to search from database when user enter any table value in textbox control

14-Mar-10 3:51

developerit wrote:
when iam using a textbox control when user enter the any part of column or any filed in the text box it should come like popup in the textbox from database

Can you clearer? It's really difficult to understand what you are trying to ask right now.
like: Where from column came into question when talking of textbox? What do you mean by, field in textbox should come like popup in textbox from database?
Elaborate a little and tell where DB comes into picture and what exactly needs to be displayed in the popup?

developerit14-Mar-10 19:18

Re: how to search from database when user enter any table value in textbox control

14-Mar-10 19:18

iam having table fields in sql server

branchname nvarchar
address nvarchar
emailid nvarchar
phoneno nvarchar
mobileno nvarchar

iam having textbox in asp.net when user enter any value either branchname oraddress or emailid or phone no or mobileno the solution should comes like autocomplete extender . popup should come in textbox text

using asp.net with c#. give me a example which helps me.

Not Active14-Mar-10 5:57

Not Active

14-Mar-10 5:57

I believe what you are asking for is an autocomplete textbox, http://www.asp.net/ajax/ajaxcontroltoolkit/Samples/AutoComplete/AutoComplete.aspx[^]

I know the language. I've read a book. - _Madmatt

Stored Procedure OUTPUT Parameter not working.

sharad Pyakurel13-Mar-10 18:14

13-Mar-10 18:14

My method adds parameters to stored procedure as:
public void AddParameter(string StrName, SqlDbType objType, ParameterDirection objDirection)
{
SqlParameter l_Param = new SqlParameter();
l_Param.ParameterName = StrName;
l_Param.SqlDbType = objType;
l_Param.Direction = objDirection;
Command.Parameters.Add(l_Param);
}

public void AddParameter(string strName, SqlDbType objType, ParameterDirection objDirection, object objValue)
{
AddParameter(strName, objType, objDirection);
}

I have send parameters to stored procedure using above method and used ExecuteScaler and ExecuteReader both. But it displays error while executing stored procedure.

dan!sh 13-Mar-10 19:06

dan!sh

13-Mar-10 19:06

What is the error message?

Pranay Rana13-Mar-10 20:22

Pranay Rana

13-Mar-10 20:22

what is error message ?

Sandeep Mewara13-Mar-10 20:29

13-Mar-10 20:29

sharad Pyakurel wrote:
SqlParameter l_Param = new SqlParameter();
l_Param.ParameterName = StrName;
l_Param.SqlDbType = objType;
l_Param.Direction = objDirection;
Command.Parameters.Add(l_Param);

Looks like you forgot to add:l_Param.Value

Add:
l_Param.Value = objValue;

You shouldn't be needing the other AddParameter method. All can be done in one.

sharad Pyakurel14-Mar-10 20:13

14-Mar-10 20:13

For Parameter type Input it works perfectly. But with OUTPUT Parameter Type It Displays following Error in place of ExecuteScaler Method:

String[1]: the Size property has an invalid size of 0.

(Actually I have a Stored Procedure which takes @Amount as input and converts the input in word, here @word in output Parameter. It should convert input amount in word.

Stored Procedure is right. but something wrong with executing from application.

What should i do.

Arindam Tewary14-Mar-10 20:57

Arindam Tewary

14-Mar-10 20:57

As per your error message , you should mention the size of outout value (irrespective of in or string whatever your output type). please give a try and let me know.

As an example: if you are exptecting to get "cheers" as a word that appears from @output valiable, then mention "6" as the size of the output parameter along with itoutput parameters type.

Thanks,
Arindam D Tewary

sharad Pyakurel17-Mar-10 1:03