Hi,
Is there a way i can add a symbol like a bullet a (wingding font) to my report in addition to other text in a text box.
any help will be appreciated.
Regards,
Karen
Assume that if i have a product called Jacket that has the following descriptions, which written in bullet form
• 600 Denier Carbolex® coated 1000mm Polyurethane
• Anatomically fitted for the riding position
• Ballistic nylon in protective areas
• FS Rainguard® 100% waterproof/breathable jet-liner
• Polyester mesh non-allergenic liner
• Removable CE armour equipped in the hips and knees
• Padding at knees, shin, hips and kidney area
• Removable zip-out satin quilted liner
• Reflective Phoslite®
• Stretch in the knees
• Gusseted with Velcro front zip closure
• Velcro adjustable waist
• 2 front pockets
• Storm flap system
How am i going to store in the Products table ? But not all products have these descriptions, other products may have no description at all.... If I store them in a text/memo DESCRIPTION field, then , I do not know how to format them into bullet form...
I would appreciate anyone knows the solution for me... Thanks in advance !
I'm using a bullet chart in a SSRS report and I want to set the Maximum value in the Linear Scale properties to highest value of the following 4 fields. Is there any way to do this?? This will make all charts line up properly.
NC_LAST_YEAR
NC_LINKED
NC_CURRENT
NC_PLAN
Hi All,I am trying to insert symbols in a field of a table. I am using the datatype nvarchar for the field.However when i tried to insert a statement with the symbol pi, it comes out as following:(A) 100? cm2 (B) 140? cm2 (C) 200? cm2All the pi symbol are converted to ?.Can ne 1 tell me how i can store such strings in the field.Thanks
View 1 Replies View RelatedI am creating a Project schedule using a stored procedure. The character is currently set to '>'. I would like to replace this with the 'black square', character code '25A0'. Is this possible?
Here's part of my code:
QBar = CASE WHEN EstStartDate >= @ZFromDate AND EstDeliveryDate <= @ZToDate
THEN Replicate(' ',Datediff(day,@ZFromDate,EstStartDate)) + Replicate('>',Datediff(day,EstStartDate,EstDeliveryDate) + 1)
(Running Access 2002 frontend)
Hi all,
I was told recently that doing the following:
SELECT ProductName ||' , '|| Category FROM PRODUCTS
would add parentheses around the ProductName field data. However, after trying it out for myself I found it did no such thing.
Does this look familiar to anyone? Is it syntax I have wrong or something?
Butterfly82
Hi All,
I am trying to insert symbols in a field of a table.
I am using the datatype nvarchar for the field.
However when i tried to insert a statement with the symbol pi, it comes out as following:
(A) 100? cm2 (B) 140? cm2 (C) 200? cm2
All the pi symbol are converted to ?.
Can ne 1 tell me how i can store such strings in the field.
Thanks
Here's the output when I type .reload in windbg (minus warning messages):
20:266> .reload
DBGHELP: C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500armv4isqlceqp30.dll - OK
DBGENG: C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500armv4isqlceqp30.dll - Mapped image memory
SYMSRV: C:SDKsMS_SymbolFilessqlceqp30.pdb79F8C010CB11435E99474335288548601sqlceqp30.pdb not found
SYMSRV: C:SDKsMS_SymbolFilessqlceqp30.pdb79F8C010CB11435E99474335288548601sqlceqp30.pdb not found
SYMSRV: http://msdl.microsoft.com/download/symbols/sqlceqp30.pdb/79F8C010CB11435E99474335288548601/sqlceqp30.pdb not found
DBGHELP: sqlceqp30.pdb - file not found
*** ERROR: Symbol file could not be found. Defaulted to export symbols for sqlceqp30.dll -
DBGHELP: sqlceqp30 - export symbols
Why can't it find the .pdb file on the symbol server and where else should I look?
I started to working on a project. I dont have a lot experiences except basic information. I just want to ask can I use symbols in primary key column like 2015/1234 etc. for file numbers. These are file numbers and must be unique so i decided to make them primary keys but im not sure that i can use symbols.
View 2 Replies View RelatedI am attempting to insert a trademark symbol„¢ into a database field but it is not working. Does anyone have any ideas on how to do this properly?
Any help would be very appreciated.
I am new to SSC . I have a table that has NO.OF WORKING HOURS for 30 days. I am trying to convert all the values into INT as MINS to generate a SSRS report.
Note: There are some records with negative value (-4h15m)
Sample
NAME D1 D2 D3 ....D31
X1 9H 30M NULL 10M
X2 0M 1H 30M -4H45M
X3 20M -1H NULL
I am importing csv files into sql 2000 using odbcbcp and am getting the '' symbols when there are null values. Has anyone ever seen this? Or know how I can prevent this from happening? I am required to use odbcbcp to import this data.
View 5 Replies View RelatedPlease can anyone help me - I am trying to establish whether there are any reserved symbols in SQL passwords
eg % £ " $ ( / < * etc
The SQL BOL has a list of reserved words but I cannot find a list of reserved symbols.
We have a problem where by for example if the main part of the password is "test" and my user wants to add a punctuation mark into this we get "You are attempting to use an invalid character message"
Specifically
"test$" is accepted "$test" is not accepted
None of "te+st" "+test" "test+" are accepted.
Has anyone else come across this and found a list of the logic that produces these results so I can point my users in the right direction?
Cheers
Hello...
I am going crazy trying to figure out how to do this. I have a flat file which I am massaging the data and loading into a table here is an example of a line out of the flat file:
"ABC NUTRITIONAL PRODUCTS","550","","","N","FAIR OAKS","","","COLORADO SPRINGS","C0","","","","","","","","A","","",""
My problem is that I have one field which is this address in a concatinated form. The fields that do not apply to this entry are suite#, floor# and other columns which are designated by the "" characters. The final concatinated addres field looks like this:
"550""""N""FAIR OAKS"""
I would like to remove the "" characters in the concatinated string. I just don't know the best way to do this? I was told DTS had a way of removing the "" from the flat file source. Since I have not used DTS extensively I am not sure if this is true. I was wondering how in SSIS I could go about removing the "" marks without removing the "" say if someone is quoted eg. John said "This is only a test". Removing the quotation marks in this instance would be changing the data. I am not sure how to do this and any help or advice is greatly appreciated!
Thank you...
Is there a way to make full text search which supports search terms for words with symbols, like C#, C++ etc.?
I see that even this forum, if I try search for C++, it returns everything where letter c exists. So, it's not possible I guess?
Hi,
I am developing a native C++ application using SQLCE (.NET is not a current option). Am having a problem while using multiple accessors for multiple blobs in a table. After I read the data for the first blob & try to read the data for the second one, I get an error in one of the dlls (something about using heap data that was freed). Where can I get symbol data so that I can use something like Windbg to resolve my problem.
Hi All..
my requirement is.. Main report will have some data displayed with 3 columns.. and need to display a sub report side to main report table.. which shows some data based on selection by any row value displayed in main report data..
for ex..
Main report displays country details data..
Country Name, Capital
*************************
USA, Washington
Canada, Ottawa
Mexico, Mexico City
if user clicks on USA sub report need to display dynamically following data
Sate , Capital
****************
Delawere, Dover
New Jersey, Trenton
Georgia, Atlanta
I could able to find info till adding a sub report. but no proper info in MSDN regarding passing values for parameters in navigation of column in main report which has navigation link to subreport
Seniors pls throw some light on this..
Hi All,
Iam Using sql server report ..how to declare"Report document" class in windows application ..
its any syntax is their..I mentioned below.for example crystal report "Report document" class..
that same class how to declare in sql server report "Report document" in windows application
Syntax:
------------
ReportDocument rpt1 = new ReportDocument();
When I am giving http://localhost/ReportServer/ in internet explorer the following error is coming please help us. We already installed the report server
Server Error in '/ReportServer' Application.
The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFramework64v2.0.50727Temporary ASP.NET Files'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFramework64v2.0.50727Temporary ASP.NET Files'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[HttpException (0x80004005): The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFramework64v2.0.50727Temporary ASP.NET Files'.]
System.Web.HttpRuntime.SetUpCodegenDirectory(CompilationSection compilationSection) +1036
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +409
[HttpException (0x80004005): The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFramework64v2.0.50727Temporary ASP.NET Files'.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +709
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +317
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +595
Hi All,
I have to set Amount field properties to "Currency"
i got the answer like this:
$123
$234324.498
$-34343.55
$-33.00
how to change negative sign like this.., any properties is there
-$34343.55
-$33.00
Hi,
I created sql server Main & sub reports ...But i didnt get supreport in window application
Its Shows only Main report.
The Error Shown: Could Not Be Shown Subreport
How to call subreport in windows application...any coding is their.. its working backend (Main & Subreport reports)but its not working windows application. its shows only main report . I Mentioned my coding part below:
public partial class Form1 : Form
{
private string str = @"Uid=sa;pwd=systems;Data Source=Spring;Initial Catalog=VPMS";
private SqlConnection con;
private DataSet ds = new DataSet();
private SqlDataAdapter da;
private DataTable orderDetailsData = null;
private DataTable LoadOrdersData()
{
this.con = new SqlConnection(this.str);
this.ds = new DataSet();
this.da = new SqlDataAdapter("exec STP_RP_AR_ENCOUNTER", this.con);
this.da.Fill(ds, "OrderData");
return ds.Tables[0];
}
private DataTable LoadOrderDetailsData()
{
this.con = new SqlConnection(this.str);
this.ds = new DataSet();
this.da = new SqlDataAdapter("select * from VW_RP_SHR_Superbill where 1=1", this.con);
this.da.Fill(ds, "OrderDetailsData");
return ds.Tables[0];
}
private void SubreportProcessingEventHandler(Object sender, SubreportProcessingEventArgs e)
{
if (orderDetailsData == null)
orderDetailsData = LoadOrderDetailsData();
e.DataSources.Add(new ReportDataSource("Ds1", orderDetailsData));
}
public Form1()
{
try
{
this.Text = "Report Control Demo";
this.ClientSize = new System.Drawing.Size(700, 600);
ReportViewer reportViewer = new ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.LocalReport.ReportPath = "RP_SHR_SuperBillPrint.rdl";
reportViewer.LocalReport.SubreportProcessing +=
new SubreportProcessingEventHandler(SubreportProcessingEventHandler);
reportViewer.LocalReport.DataSources.Add(
new ReportDataSource("Ds1", LoadOrdersData()));
reportViewer.Dock = DockStyle.Fill;
this.Controls.Add(reportViewer);
reportViewer.RefreshReport();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.reportViewer1.RefreshReport();
this.con = new SqlConnection(this.str);
this.ds = new DataSet();
}
}
}
Please Help me Very Urgent:
Does anyone have any suggestions? Thanks.
Hi All,
Iam working sql server report ...i want column of row increment automatically..how to set row increment in sql server report..for example i mentioned below
for example:
Name Id Description
1 john 1000 HOU
2 hawkins 2000 weferwe
3 rrrrrrrr 4444 444444
i mentioned that row increment 1,2,3 how to set automatically this field ..
if i written query or any properties is their...
its query means pls tele that query
Hi All,
I have several textbox in my report and I would like to shrink "Amount" textbox field and move it to the above line if i get blank line before it.
For Example: ----> Iam Using Textboxs Only
Account : 12312
Payment Date: 12/4/07
Paytype: credit
card # : 43475834774
Amount : $233.00 ------> i got report result like this....
when i will get "Paytype" field to "Cash" I will suppress "card #" field totally
i got blank line in between ( Paytype and Amount) this is the logic.
Account : 12312
Payment Date: 12/4/07
Paytype: Cash
----> i Suppressed the field like this
Amount : $233.00
How to Amount textbox field to shrink if i get blank line....
I would like to display the result mention below:
Account : 12312
Payment Date: 12/4/07
Paytype: Cash
Amount : $233.00 ------> how to shrink the Amount field ( I tried to set the "can shrink" property to true? and iam not using table ,i know it is possible using table, but iam using textbox only,any possibility is there by using textbox alone)
Do anybody know how to accomplish this in Reporting Services.
Thanks,
Ashok
Hi all,
iam working sql server report,i got dynamic image in report view..
i set the path in sql server report " Value " properties = " :File://D:BrandSureRunImagesBS-logo.jpg "
i got all the images dynamically in our report view...
But i put same project .exe file another system..its shown error in images
how to set dynamic path in sql server report "Value" properties
I used dynamic path like this: File://..//Images/BS-logo.jpg
but its not working how to set dynamic path in sql server report pls help me
Hi all,
iam working sql server report,i got dynamic image in report view..
i set the path in sql server report " Value " properties = " :File://D:BrandSureRunImagesBS-logo.jpg "
i got all the images dynamically in our report view...
But i put same project .exe another system..its shown error in images in report view..
but in .exe inside image folder is their and all the images are their .in iamge folder
how to set dynamic path in sql server report "Value" properties
I used dynamic path like this: File://..//Images/BS-logo.jpg
but its not working how to set dynamic path in sql server report pls help me
I have an urgent need to solve this issue.
I have a report that has two sets of six sub reports. Here is what I have:
Main Report
Subreport1A
Subreport2A
Subreport3A
Subreport4A
Subreport5A
Subreport6A
Subreport1B
Subreport2B
Subreport3B
Subreport4B
Subreport5B
Subreport6B
I want to have a page break between the first set and the second set. The last subreport of the first set, Subreport6A, has a pagebreak at end = true, so it should break. The problem is that when I export to Excel I am getting one sheet for the 12 subreports.
I am not able to open reports through URL.
<A HREF="http://localhost/Reports?NTIEE Reports/NTSID_LookUp">View Report</A>
When i click on this link it opens report manager and the NTIEE Reports folder.But i want to open direclty the report.Name of the report is NTSID_LookUp which is depoyed inside NTIEE Reports folder.Pls let me know how i can open a report through my web application.
Hi All,
I have created a report in SQL Server Business Intelligence Development Studio 2005. I need to add a report title above the parameters area. Is that possible?. please help me
The output should be like
_____________________________________________________________________
Report Title
_____________________________________________________________________
Report Parameters Section View Report button
_____________________________________________________________________
Report Body part.
_____________________________________________________________________
Hi all.
I want to display the data from this table (data provided below in my report)
PlanId, ParticipantId, FundId, FundNames, Loans,PortfolioId, Act1, TotAct1, Act2, Totact2 etc.. Until act20, totAct20
18752 1041 Columbia Funds Trust VI: Columbia Small Cap Value Fund I; Class A Shares NULL NULL NULL BB 425.32 CT 0.00 DV 0.00 GL 17.40 TF 0.00 WD 0.00 OT 0.00 EB 442.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
18752 6204 Columbia Funds Series Trust: Columbia Small Cap Index Fund; Class A
Shares NULL NULL NULL BB 120.09 CT 0.00 DV 4.04 GL 2.10 TF 0.00 WD 0.00 OT 0.00 EB 126.23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
18752 10302 Columbia Funds Series Trust: Columbia Marsico 21st Century Fund; Class A Shares NULL NULL NULL BB 119.59 CT 0.00 DV 1.69 GL 10.41 TF 0.00 WD 0.00 OT 0.00 EB 131.69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
18752 11010 Columbia Acorn Trust: Columbia Acorn International Select; Class A Shares NULL NULL NULL BB 125.06 CT 0.00 DV 0.33 GL 8.83 TF 0.00 WD 0.00 OT 0.00 EB 134.22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
18752 11024 Columbia Acorn Trust: Columbia Acorn International; Class A Shares NULL NULL NULL BB 126.85 CT 0.00 DV 0.77 GL 10.07 TF 0.00 WD 0.00 OT 0.00 EB 137.69 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
I will have around 10 -15 records depending on how many funds the user has... and i want my report to look like this
InvestmentName Act1 (BB) Act2(CT) Act3(DV) Act4(TF) ..Act20
FundNames TotAct1 TotAct2 TotAct3 TotAct4 .. Totact5 so the data will be displayed for each fund in different rows..
I am storing the value acroynms and what they stand for a different table and i know there are 20 acroynms and i need to the description of that acronymn to show in the heading... How can i do it...
I am trying to right a sproc for it...
Any help will be greatly appreciated... if you need more information.. pls feel free to ask
Regards
Karen
Hi All,
I have created a report in SQL Server Business Intelligence Development Studio 2005. I need to add a report title above the parameters area. Is that possible?. please help me
The output should be like
______________________________________________________________________
Report Title
______________________________________________________________________
Report Parameters Section View Report button
_____________________________________________________________________
Report Body part.
_____________________________________________________________________
Hi Everyone,
I have used the StoredProcedure as shown below:
Begin
Select a.Field1,b.Field from table a, table b where a.patientid=@patID
if(@select=1)
select a.Field1, a.Field2 from table a
else if(@select=2)
select b.Field1, b.Field2 from table b
end
When I bind this storedprocedure with Dataset, all the Fields Corresponding to table a and table b are displayed in the Dataset.Finally, when i bind this Dataset with my chart, the fields corresponding to table b are not displayed in the Chart.
The reason for that may be because Report Server cannot bind with multiple Datasets? Please Clarify.
If the Report Server cannot bind with multiple datasets, then how to call different StoredProcedures (according to Criteria) in a Single Report in Report Server project?
Thanks
Navdeep
I have Query output like below
C1 P1 B1 A1
C1 P1 B1 A2
C1 P1 B1 A3
C1 P2 B1 A1
C1 P2 B1 A2
C1 P2 B1 A3
C1 P3 B1 A1
C1 P3 B1 A2
C1 P3 B1 A3
C1 P4 B1 A1
C1 P4 B1 A2
C1 P4 B1 A3
i need to show my report output like this.
C1 P1 B1 A1
P2 A2
P3 A3
P4
can any one help me. i used table control but i could able to get my kind of output.
Please add sample code if possible.