Advanced reporting
and data visualization components for .NET
LIVE CHAT
LOG IN
|
SIGN UP
Welcome, guest
Products
Reporting
SharpShooter Reports.Win
SharpShooter Reports.Web
SharpShooter Reports.Silverlight
SharpShooter Reports.WPF
SharpShooter Reports.WinRT
SharpShooter OLAP
Data Visualization
Perfect Widgets for HTML5
Perfect Widgets for Windows 8
SharpShooter Dashboards
SharpShooter Gauges
Instrumentation Widgets
Instrumentation Widgets for PDA
Viewers for Reporting Services
Silverlight Viewer for Reporting Services
WPF Viewer for Reporting Services
WinRT Viewer for Reporting Services
PerpetuumSoft Viewers for SSRS
SharpShooter Collection
UI Controls for Windows 8
Downloads
Purchase
On-Line Store
Renewals
Resellers
Company
About
Contact Us
Our Partners
Community Relations
Our Customers
Case Studies
Help Center
Blog
SUPPORTED TECHNOLOGIES
Live Chat with sales team
Click to get live assistance on purchasing and licensing
Technical Support
Get high quality support
View FAQ
Where can I find information on how to setup a crossband in report sharp-shooter Designer?
How to print text over the image in the report?
How to write script for total or sum so that I can show them in my report?
How can I change my DataSet from my code to another DataSet?
How to use the sub report?
How to create new elements dynamically in RSS?
How to set document zoom in the ReportViewer component?
How can I combine two reports and display them in parallel so that the left part of a page displays one report and the right one displays the other report?
I need to format all currency values in our system as a user definable format string. This will look like ###,###,###,##0.00 or ###,###,###,##0 .
Is there a way to pass this to the report generator and use it as the format string for specific currency fields?
How to insert an image into a report?
I wanted to create a grouped report, showing Companies and related contact persons. Unfortunately, the database contains several Companies with the same name, but with different departments, sites, etc.
Starting from your 'simple' example report, I changed the group to contain everything that makes a company record unique (name, city, department, site). I do get the correct report, but I am not able to navigate by means of the bookmarks.
I now have a working alternative, using "Company Name (ID)" in both bookmark and group title, and site/department/city in the header region. But it doesn't look that pretty. Are there other (and nicer) solutions to have company names in the bookmark and still be able to show the right information?
I have a .NET web app which uses Crystal Reports to render the reports. It is my understanding that there is a 5 concurrent user limit which poses a big problem as we may have more than 5 users at a time trying to render a report. Is there a concurrent user limitation with Report Sharp Shooter?
Can a single report have several sub-reports?
I would like to request a file or something like this that have all internal functions that we can use in the reports. I'm having problems doing simple things, like show the date and the time in separate fields (extracted from built in function "Now").
I have problem when I add the .Net ModelKit Suite components onto the ToolBox manually with Borland Developer Studio 2006. Is it compatible with .Net ModelKit Suite? How to solve it?
I have the need to print static text for the reverse side of every page. And pagination should be applied only for main pages but not for reverse ones.
I finally bought the Sharp Shooter v3.0 Lite. I uninstalled the free one, and reinstalled the new one.
It’s giving be the following error: 'Reporting' is not a member of 'PerpetuumSoft'.
And because of this everything else having to do with the Reporting object is broken. Does it have to do with the fact that the license I downloaded (even the Lite) shows Express version when using Licensing Manager? How can I fix this?
Can the end user add/change data sources in the Designer that is presented to him? Also, can the end user define a new report from scratch - adding data sources, formatting, etc?
How do I dynamically change Textbox's size and location?
Is there an easy possibility to put 'check marks' on the report according to database true/false values;
What should be the correct syntax to use null values;
I tried to use this Iif(len(GetData("Contacten.EmailAdres"))>0,"J","N") to simulate a check mark Yes/No, but, unfortunately, the database contains both empty strings and dbnull values.
During rendering the report I get several errors.
I use the ternary operator, i.e.
databand1[“name”] != System.DBNull.Value ? “is not null” : “is null”;
But what if I use the classical construct of if / else.
If(databand1[“name”] == System.DBNull.Value)
“is null”
else
“is not null”
The strings fly around, I guess I need to reference the Value field in some way.
I haven't been able to use charting. I don't know what I am doing wrong; I always get only the data that is placed in during the design of the report, never the data from the database. Could you place a simple sample report with an XML database datasource on the net?
I have a report that displayed data with the help of DataBand and everything was all right. But after I added the Header element, the report is not displayed correctly. The Header element is displayed on the first page; the rest of the page is empty. And only a new page displays data from the DataBand.
I installed my license with the LicenseManager, but I still get a warning "Report Sharp Shooter Web Viewer – Unregistered” in my web application.
I need to display data from a table, but not all record should be included in the report. Is there any ability to filter source data during report creation?
How can I get real coordinates of the textbox element on the page? If I use textbox.PageLocation, I get static vector, i.e. X and Y from a template… I need coordinates from the pages of final documents.
I display my data in report with the use of DataBand; displayed fields take small part of the page in width, but there are a lot of records. How can I display them in more compact manner, for example, to display them in several columns?
Is it possible to change the default properties of the components? The thing is that the TextBox component has a "center" alignment, and in 99.9% of the cases, I need the text to be left justified. That means that I have to change the property on ALL textboxes. I can do that, but it would be easier if I could just change the default value...
I need to display data in a report in several columns and each column should contain the defined number of rows. Or, for example, rows are divided into the required number of columns so that each all columns contain equal amount of rows.
We are interested in finding a replacement for Crystal Reports that has an easier way to create reports automatically. Ideally writing to an XML file that holds the report definition. Does your product do so? What are the main advantages of your tool against Crystal Reports?
How to print a report without displaying the report viewer component? I do in the following way at the moment:
PerpetuumSoft.Reporting.Components.ReportPrintDocument pr = new
PerpetuumSoft.Reporting.Components.ReportPrintDocument();
pr.Source = inlineReportSlot1;
inlineReportSlot1.RenderDocument();
pr.Print();
But the RenderCompleted event is raised, but I don’t need it.
Is it correct that I should only unsubscribe from this event?
When I build my project, ALL PerpetuumSoft dll's are copied to the output folder - even the ones that are not referenced in the project (such as chart and instrumentation - seeing that I haven't got a license for them, and don't need them either). I simply cannot understand it.
In the 'standard' set-up, after rendering the ReportViewer is started to show fullscreen with the report at 126% zoom. Is it possible to have the report shown automatically at 'fit for page height'?
My report displays data about customers; data is grouped by a customer. But I need data on each customer displayed on a separate page.
I would like to be able to design the report, switch to my code to check code and values and then go back to the report designer WITHOUT having to save the document, close the designer, do whatever and then open the designer again. Preferably, I would like the designer as a tab in the Visual Studio document window like the forms designers, code windows etc.
How does exactly Web Forms version of Report Sharp-Shooter work?? I want to do this: put all the report's on an IIS server and call the reports inside of a Win Forms application (maybe from Web Forms too). Is that possible? Which version of Sharp-Shooter I need to buy to do this? Win + Web or just Web version?
How are subreport names populated in the TemplateName property?
Is it possible to change templates for code snippets in the script editor?
Why do you want to remove other products from .NET ModelKit Suite? Report Sharp-Shooter is a part of the .NET ModelKit Suite. You can not download or install Report Sharp-Shooter without the other products.
If a textBox's CanGrow and CanShrink properties are set to False and if the height of the textBox is set in order to fit more than 2 lines, the text is automatically folded when the text is longer than the textBox's width. Are there any ways to control the folding?
What is the order of the report elements rendering?
When exporting a report to Excel, the formatting for each cell becomes String. Are there any ways to make it General or Numeric?
I need to use company logo as an image at the page. So I use Image component and set some source path to the logo image. But indeed I can’t export this logo image to .html (there is no source). Is it possible to use kind of html image with reference to some web image? something like
?
Does Report Sharp-Shooter allow printing reports on dot-matrix printers in the text mode? What should I do to make this work?
If the string is bigger than the width of a textBox, by using the CanGrow property, the string is fully displayed by more than 1 line.
For example, if the string is "123456789", but the width of the textBox is set as "123" is shown, it is displayed as follows:
[123]
[456]
[789]
Are there any ways to display it as [123456789]? Or is it necessary to design the size of the textBox to fit the string?
How to compare two documents and know that they are completely equal? Variant to workaround the document tree and compare objects properties is difficult to realize.
We need to be able to save reports to PDF, both manually and programmatically. I’ve tried to perform this task manually by using the Export feature however the File Type drop-down does not display the option of *.pdf.
How can I send and receive RST (template) and RSD (Rendered Document) using Web Services?
Is it possible to extend the report viewer so that end user can send the report as PDF file within an email?
Is there some way to do different coloring of alternating rows (odd and even) in detail band?
I need to create a report having data grouped by the definite field. It is necessary to calculate sum by each group and by all data. Besides that report should contain data for a definite period of time and this period should be set in parameters. I am novice in working with Report Sharp-Shooter and I don’t know what to start from.
Is it possible, when printing report, to go to new page if condition is true?
For example, If (a == b) then ‘go to new page’
I don’t know how to create a datasource or add some functions. I'm inside the report designer, I selected the right tab and even if I open an existing report I don’t see datasources, bands, etc. If I double click on a field inside the report and empty text editor arises. Is this a limitation for trial version?
How can I get not only the current record from a data source but also revoius and following ones?
How can I calculate line totals (amount x unit cost)?
When I change the width of the document to a value greater than 21 cm, the value rolls back to 21 cm. How can I change the length?
I have several reports that work fine in my development environments, but when I publish the website, the webviewer will randomly display blank. I can refresh the page several times and sometimes the report will show up. It's random as sometimes it shows up immediately, other times it takes several refreshes. It runs 100% of the time on my development environment. What could be causing this?
Is there a way to hide a new document button in the toolbar?
I use a custom designer and all work except the controls insert. I can’t find the method to insert a control in the ReportDesigner (to insert a TextBox, AdvancedText, Picture...). I searched in the ReportDesigner and DesignerToolBox, but I didn't find.
I have a report with about 15 sections and I don't get to see them all when I scroll down at design time. Is there a way around it?
I would like to specify page size on my report which I create dynamically. So I use PaperKind.Custom property but how can I specify page size? I used CustomSize.Add method, but no results: p.CustomSize.Add(new PerpetuumSoft.Framework.Drawing.Vector(50f, 250f));
Is Report Sharp-Shooter written in really 100% managed code?
How to use expressions to set property values? How to use expressions for the NawPageAfter property?
Right now I have several options like .gif, .jpg, and .png in my save dialog. However, .html and .pdf are not options in the save dialog. How can I add them?
I am trying to set the report title
via code and can’t get it to work properly. What is the proper way to do this? I have tried:
inlineReportSlot1.Document.Pages.Document.Title = m_ReportName;
What is the use of GetDataScript in dataBand and when it will be fired?
Is it possible to access the variables defined in the Report at the time of rendering?
Is it possible to get an event while rendering for every record that is being processed in the datasource?
I use Windows Form ReportViewer control to view my reports. I set Source Property and call RefreshReport(). Is there a way to cancel rendering of the report after calling RefreshReport()?
Is it possible to design a 2 column report that is multi lingual, the left column is English and the right column is Arabic (right to left)?
I tried to import crystal reports. At the beginning of importing I got the following error: CrystalDecision.Shared was not found. It seems that this assembly was missed.
I've created a custom toolbar and added my own buttons, I see there are several standard actions( such as print, save etc) but how do I create a custom action that will fire when one of my own buttons is clicked.
How can I disable the progress messagebox "Printing page nr. of document
" shown while printing ReportPrintDocument.Print()? In SharpShooter it is not shown. How can I use this information in a status bar?
When a user prints an invoice, I need to update the records in database. So, is it possible to know if an invoice has been treated or not?
What are the functional differences between: The professional version of Report Sharp-Shooter and the free version?
Suppose you have n Ado.Net tables, can you print them on the same report page assuming no relationships between them?
I tried to use Bold, Italics for my Font size 10 text, but I can't see this on my PDF display. What is wrong?
What’s the property to get the Total No of Pages of a report? I gave the following script on the report footer - "Page# " + PageNumber.ToString() + " of " + PageCount.ToString(), which showed the current page number in the place of the Total number of pages too. Can anybody help on this?
I have a group header and I want each group to start on a new page. If I set the new page before to true which works but I get a blank page at the start. If I set it to new page after I get the header but then the details are on the next page. What is the correct way of doing this?
How can I access the reports control from my form code? For e.g., how can I set the value property of textbox in inlineReportSlot1 from my code?
I'm trying to import a report from Crystal Reports 11, .NET 2.0 and I get "File or assembly name CrystalDecisions.Shared, or one of its dependencies, was not found". I first looked in the GAC and CrystalDecisions.Shared is in there so I don't know what else it could be.
I have a text box displaying a boolean field from my datasource using the value code GetData("deejay.PIA"). I want to change this so I can display "Yes" if the value is true and "No" if it is false. How is this done?
How to resize the barcode (width and height) programmatically (in GenerateScript)?
How to print my report directly to the default printer, without the Printer Dialog Box?
The output of report is 15 pages. The output contains information of 5 Customers. Each customer is having 3 pages. I want to mention the page numbers for each customer i.e., for each customer, the staring page should contain the page number 1. How can I solve this problem?
When I export a report to excel it loses the formatting in excel sheet (some fields are visible and some are not visible in excel). How to solve this issue?
Can I store the XML definition in database and populate the DocumentStream property of the ReportSlot object from the database?
What is the difference between the Report Template and Report Document? Which of these can be presented to the end user for customization?
Is it possible to order rows in a band? For example: I have 10 company rows inside the databand and now I want to order the companies by Name.
I have created a custom control in my report. I have to add a feature to the control that it should be dropped only on page footer. It shouldn't be dropped anywhere else. For example, a "Detail" control can be dropped only on data band. Similarly I have to drop my custom control only on page footer.
In my custom designer, I try to check the Undo and Redo items in my menu, I use the following code but it doesn't work :
Code:
this.btnMenuEditUndo.Checked = this.reportDesigner1.Actions["Undo"].Checked;
this.btnMenuEditRedo.Checked = this.reportDesigner1.Actions["Redo"].Checked;
Can I use previewForm.ReportViewer.ExportReport() but without showing the export dialog?
I need to create an unbound report with only textboxes in it which values are updated when a 'print' button is clicked. The values will come from a textbox on a winform. So, at which event do I insert the code - buttonclick or elsewhere? How can I change the values of the textboxes on the report at runtime?
I want remove top and bottom border lines of a TextBox at run time:
BorderLine bl = new BorderLine(LineStyle.None, Color.Black, 0);
textBox1.Border.BottomLine = bl;
textBox1.Border.TopLine = bl;
The code caused this error:
Can't modify immutable object
How can I do it?
Is it possible to put a multiline string into a textbox? Trying to concatenate a string with "#10", "\n" throws an exception.
I created a report designer using your components and curious to know if there is any type of flag I can use to determine if a user has actually made a change to the report?
I inserted a picture box on report and I need to add code to "GenerateScript" function to dynamically assign the location of the picture file, but getting errors.
How to clone a report?
I would like to set the font color of a text box based on value.
I am trying to use a generatescript like:
if dbSumm("CAHSEEMath") = "PASSED" THEN txtMathPass.textfill.color = color.green
I have a dataset in memory that is being used to design reports. When I create a databand and use this data set as the data source, how can I further filter records in the dataset (in design mode of the report)?
If I pass null data into a ReportSlot with the ExceptionMode set to Ignore, it ignores the error as expected. If I set the ExceptionMode set to Warning, I see a Null Exception error and then the program drops out. I thought that I would see the error and then the program would continue.
Is it possible to make the report save without showing save dialogue when the designer is being closed?
What should be passed to the GroupBand.Group property in order to perform grouping. I display a non-grouped table in the DataBand section. Inside this section I placed the GroupBand section, but I can’t specify a column by which grouping should performed.
When the SetNewZoom function fires no changes are visible. What should be done in order to set custom zoom and when it should be set programmatically?
I need to be able to prohibit breaks between some sections in case they can be placed on a single page. For example, I have a group report. I need to prohibit breaking group contents. If it is possible to place its contents on the current page leave it there, otherwise place it on the next page. If it can’t be placed completely on the next page, it should be broken. This functionality can be used for Detail and Subdetail sections and in Master-Detail – Subdetail reports.
I need to insert a report created in one application to other report created in the other application. It seems that it possible to save the first report to a file and insert a sub-report referring to this file in the other report. But this variant won’t work as the first report is already formed and this means that it contains not databands, but textboxes. And correspondingly they are not displayed in the sub-report. What should I do in this situation?
Our Customers>>
Reporting
SharpShooter Reports.Win
SharpShooter Reports.WPF
SharpShooter Reports.Web
SharpShooter Reports.Silverlight
SharpShooter Reports.WinRT
Silverlight Viewer for Reporting Services
WPF Viewer for Reporting Services
WinRT Viewer for Reporting Services
SharpShooter OLAP
SharpShooter Collection
Data Visualization & UI
Perfect Widgets
Perfect Widgets for Windows 8
SharpShooter Gauges
SharpShooter Dashboards
Purchase
Buy Now
Renewals
Resellers
Contact Sales
Support
Support Options
FAQ
Forum
Documentation and Resources
Demos
Company
About
Contact Us
Partners
Community Relations
Customers
Case Studies