I am able to resolve this. the method is dont write a function to convert to currency. specify in properties of the cell (properties->format->format code:C) just to C.
Let me know if it is helpful
Thanks,
Nanditha
nandithadevaraj
Last Activity: Dec 16 '09, 09:28 AM
Joined: Feb 13 '08
Location: Karnataka, India
-
Exporting SSRS report to Excel - Number stored as Text error
When exporting a report to excel, is it possible to keep the properties around numeric values? More specifically - when exporting a report into excel, all of the numbers in a currency column are stored as text once placed into excel. Is there a way to keep them as a currency value?
Regards,
Nanditha -
Matrix Control in SSRS
HAi All,
I am currently working Sql server Reporting service in web application I am using matrix in one of my
report i am able to populate data but the thing is i need the sum of the data, Average
as a separate like
NAme1 NAme2
12/2/02 1 1
12/3/02 2 1
Total 3 2
AvgofTotal 1.5 1
its should... -
SELECT tblShiftRecords .intRecordId, tblShiftRecords .intHeadingId, tblShiftRecords .AdvanceDate, tblShiftRecords .intShiftId, tblGroundSuppor ts.intSupGenera lType, tblGroundSuppor ts.intTypeId, DLookUp("[strSupportDescr iption]","tblGroundSup portTypes","[intGeneralSupId]=" & [intSupGeneralTy pe] & " and [intTypeId]=" & [tblGroundSuppor ts].[intTypeId]) AS SupDescription, tblGroundSuppor ts.intStnHeadSt artId,...Leave a comment:
-
In need to use DLOOKUP function with in a select statement at that time how to do that ?? i tried by using sub query it returns single row but i need multiple rows...Leave a comment:
-
DLOOKUP function
Hi,
I am working on oracle, frankly speaking till nw i have nt worked in oracle i need help
please help me out in this
actually i have written query using DLOOKUP function as DLOOKUP function is not supported in oracle how can i change that to other function. is there any function to convert????
i wil include the dllokup function also
DLookUp("[strStationHeadi ngName]","tblStationHe adings","[intStationHeadi ngId]="... -
No i am not using any third party chart....Leave a comment:
-
Scattered and Line in a Single Chart
Hi,
I am doing Reports in windows application. I need to know that can i have both clusters and Line in a single chart. Is it possible to do?? Please any one help me out on this
ThanksLeave a comment:
-
Scattered and Line in a Single Chart
Hai All,
Currently i am working on reports in windows application. In reports i need to use scattered type chart in that x-axis value should come from Data source how to do that ??? Please any one help me on this. where i have to drop the data??? -
Queries on Assemblies
Hai All,
I am studying Assemblies so can i know some of the questions like
where exactly this dll files wil be present in the Console Application??
what is the necessity of using key file?
After creating key file how to Add an assembly to GAC?
plz help me.. -
No NO.. I got it.. its working now.. ya i was doing same mistake what u told
Once again Thank u..Leave a comment:
-
I am not getting any error but the data is not updated thats all...Leave a comment:
-
I tried by using following Code but its taking only direct values but its not updating whatever the content Present in textboxes.. plz tell me how to Update the content of textbox
string sql = "Update UserGroups SET grpDescription= @grpDescription , grpActive=@grpA ctive, grpToDate=@grpT oDate where(grpID =@grpID)";
SqlCommand cm = new SqlCommand(sql, myConnection);
//cm.CommandText...Leave a comment:
-
Updating the Data into Database from the Textboxes
Hai All,
Please help me on this
How to Update the Data which is present in the textboxes, the data is retrived from the database to textboxes, Just i want to modify and to update in the Database i am trying this in C# language please help me out
Thank u -
Thank u.. ya i have done by using ASP.. but i need it in HTML itselfLeave a comment:
-
No activity results to display
Leave a comment: