DB/Reporting :: How To Create Report
Apr 27, 2009I have developed a windows database application in vb.net 2008 express and sql express 2008. Is there a way to create reports in the application?
View 7 Replies
ADVERTISEMENT
DB/Reporting :: Create A Parameter That Is Already Part Of Report?
Jan 2, 2009I am using the following code to set a parameter in my report.
Code:
However, if I create the parameter at design time, it seems like I should be able to do something much simpler like
Code:
Since the parameter is already created. However, I can't get anything like that to work.
Asp.net - Add A Pdf To A Reporting Services Report After Rendering Report As Pdf?
Apr 30, 2009We are using Reporting Services to generate a purchase order, which is rendered as pdf before displaying on the screen. The report works well, as is, except that now we have to add a Terms & Conditions page to every PO. I've tried placing it in the footer, setting it to display only on the last page--this didn't work. I've also tried adding it to the body, setting the "Page Break Before" property to "true". This works, except that it looks like there is still space reserved for the header (i.e. the header's "show on last page" property is set to false). I can't get the Terms & conditions to fill the page. how I could attach or bind the pdf generated by reporting services with a pdf version of the Terms & Conditions sheet?
Note: We are using ASP & VB.NET 2.0, Visual Studio 2005, & SQL Server 2005.
DB/Reporting :: Difference Between Microsoft Report Viewer And Crystal Report Viewer
Dec 28, 2008These things look about the same to me. Is there any reason I should use one over the other?
View 5 RepliesCreate A Report In .net 2005 Through Report Viewer Control?
Apr 11, 2010I want to know how to create a report in vb.net 2005 through report viewer control
View 3 RepliesCreate A Report In 2008 Using Microsoft Report Viewer?
Feb 18, 2010how to create a report in VB .net 2008 using microsoft report viewer?
View 2 RepliesCreate Report Like Tree View InCrystal Report?
May 14, 2009I have a self referencial table Which contains fields Like ID, Name, Parent ID. By Using this table I wish to show records in crystal report Like a tree view format Like
View 1 RepliesDB/Reporting :: Use Parameters In Report?
Jun 22, 2008Finally I can create a report using the crystal report viewer.How can I add a parameter or base a report on a query.
View 3 RepliesDB/Reporting :: #Error With Microsoft Report?
Jan 1, 2009I added a parameter to the rdlc called paramTitleThen I tried this as a demo
Code:
Dim params(0) As Microsoft.Reporting.WinForms.ReportParameter
[code]....
DB/Reporting :: Crystal Report And MySQL
Jan 22, 2009This is my current code.
Code:
Set rs = cn.Execute("SELECT * FROM customer WHERE VsVslNo LIKE 'V16'")
Dim crystal As CRAXDRT.Application
Dim report As CRAXDRT.report
[CODE]...
DB/Reporting :: Login For Crystal Report?
Dec 20, 2011I have an applciation in VB.NET but when I try to produce the reports a popup message appears requiring login information.
I have attache the print screen of the popup message.
DB/Reporting :: Report Viewer 10 Issues
Nov 28, 2011Hello,
I have a web app and I have a report viewer in my app and it works fine in VS 2010. Once I publish and move it to my server I have issues. The report viewer is grayed out (please see the screen shot report_error.png). I am using Windows Server 2008 R2 and IIS 7.5. I am running it on integrated managed pipeline and the 4.0 framework. I have been digging for several hours on Handler Mappings and Config Files. I have added the Handle Mappings. According to all other forums this is the way to fix it, but it still doesn't work. Any suggestions?
Here is my Config File:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<appSettings>
<add key="ChartImageHandler" value="storage=file;timeout=20;dir=c:TempImageFiles;" />
</appSettings>
<connectionStrings>
<add name="ApplicationServices" connectionString="data source=ALBTECH-ELEARNSQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
<add name="userInfo" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:inetpubwwwrootstaffDevelopmentDatadata.accdb"" providerName="System.Data.OleDb" />
</connectionStrings>
<system.web>
<httpHandlers>
<add path="ChartImg.axd" verb="GET,HEAD,POST" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false" />
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false" />
</httpHandlers>
<pages>
<controls>
<add tagPrefix="asp" namespace="System.Web.UI.DataVisualization.Charting" assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</controls>
</pages>
<compilation debug="true" strict="false" explicit="true" targetFramework="4.0">
<assemblies>
<add assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
<add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
<add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
<add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
<add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
</assemblies>
<buildProviders>
<add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</buildProviders>
</compilation>
<authentication mode="Forms">
<forms loginUrl="~/Account/Login.aspx" timeout="2880" defaultUrl="Default.aspx" />
</authentication>
<membership>
<providers>
<clear />
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/" />
</providers>
</membership>
<profile>
<providers>
<clear />
<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/" />
</providers>
</profile>
<roleManager enabled="true">
<providers>
<clear />
<add connectionStringName="ApplicationServices" applicationName="/" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" />
<add applicationName="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" />
</providers>
</roleManager>
</system.web>
<system.webServer>
<modules runAllManagedModulesForAllRequests="true" />
<handlers>
<remove name="ChartImageHandler" />
<add name="ChartImageHandler" preCondition="integratedMode" verb="GET,HEAD,POST" path="ChartImg.axd" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
<add name="Reserved-ReportViewerWebControl-axd" path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler" resourceType="Unspecified" />
</handlers>
<validation validateIntegratedModeConfiguration="false" />
</system.webServer>
</configuration>
Any suggestions will be helpful!
Happy Programming,
Cody Wright
DB/Reporting :: Report With Data From Outside The Database?
Dec 24, 2008I have an Access database with a table called Events.I created a new VB.net 2008 project and created a MicrosoftReportViewer control. I also added a "Report" component (which created a .rdlc file).I am easily able to drag things from my Access database I added to the data sources onto the report. However, one part of the report I would like to add data to a Matrix that I calculated with VB (ie it is not in the database). The database has a list of names and a bunch of times associated with each name. and then I calculate some fancy stuff based on those times. I would like the matrix to be a list of names (from the database) on the rows, a list of dates (which I specify in the code) on the columns, and the data of the matrix I also calculate.
View 3 RepliesDB/Reporting :: Seagate Crystal Report?
Nov 27, 2008I have installed Seagate Crystal Report 8 to design reports for a database in Microsoft Access 2003. I have linked that database to Visual Basic 6.0 interfaces through ADODC coding.
View 3 RepliesDB/Reporting :: Sub Section In The Crystal Report?
Dec 6, 2010My stored procedure return 2 set of data.Select * from customersSelect * from productsnow on the report, I can see all the fields of table customers and products in the "Field xplorer".How can I display all the data in the table customers first, then display the products right after?
View 2 RepliesDB/Reporting :: Use SQL Statement In Crystal Report?
Feb 11, 2008i would like to ask if how can i call this SQL statement in my crystal report. im using Crystal Report 10.
Code:SELECT IF(out_balnce < 0, CONCAT(""("", FORMAT(ABS(out_balnce),2) ,"")""), FORMAT(out_balnce,2)) AS OutBalance, IF(acct_side < 1, CONCAT(""("", FORMAT(tran_amnt,2) ,"")""), FORMAT(tran_amnt,2)) AS TransAmount, user_code FROM LedgerHistory WHERE srvc_nmbr = '12345678' ORDER BY srce_date desc how can i place TransAmount and OutBalance in crystal report?
Asp.net - SSRS Reporting Loads Slowly The 1st Report
Apr 30, 2012I have a website(asp.net) which displays ssrs reports. Howevery everytime that I try to run the report from the website it takes about 2 min to load, but if I click on the report again , it will load up in seconds. I have tried to run a query that is used by the report and I get the results in second as well.
Is there any configuaration that I need to change or any tsql code that I need to add?
I have gone through to solutions provided here on stackoverflow but still had no luck.
DB / Reporting - How To Place Static Information On The Report
Apr 27, 2009We are making a report (2005) of a certain time duration, for example one month. In the stored procedure we made, two parameters are given; start-date and end-date. In the report we want to place these two dates, but we can only put database fields in the report. Does someone has any idea how to put these static information into the report?
View 3 RepliesDB/Reporting :: Calculated Field In Report Table?
Dec 3, 2008I have a RDLC report with a list that contains a table. I require a calculated column whose value depends on values from previous rows. Outside of a report I accomplish the same thing using code in a DataGridView's DataBindingComplete method.
From within a report how do I refer to specific cell values from previous rows? embedded code, but I have not had luck (#Error).
DB/Reporting :: Changing The Report Displayed In ReportViewer?
Apr 23, 2010I have a report viewer that i would like to display different data in depending on the report button that the user clicks. The data is stored in access databases. I am able to retreive the data and display the initial report but i have not been able to change the report/data that is being displayed.
View 1 RepliesDB/Reporting :: Creating Crystal Report From Two Tables?
Dec 20, 2011I am trying to load a crystal report from two tables but it seems that is not working.Here is the code to load the crystal report:
Code:
Private Sub InvoiceLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]......
DB/Reporting :: Creating Reports Without Crystal Report?
Mar 2, 2010I am using VS 2008 standard edition to develop my first windows form application and it does not come with crystal components. I nedd to design few reports but I can't find any help on the net. In my vba application I create one form which accepts all parameters and based on parameter I build SQL statement and pass it to report data source. I would like to similar in vb.net, but all I see is cryatal. Can I create reports without Crystal?
View 1 RepliesDB/Reporting :: Crystal Report Shows NO Data?
May 20, 2008I made a simple CR using the wizard.I display it with the CR viewer.I can see the report and the labels but no data.
View 14 RepliesDB/Reporting :: Filtering Date Ranges In A Report?
Aug 9, 2008This is my first program and have absolutely no training in programming Visual Basic Studio 2008 so forgive me if I have missed something obvious.Form3 contains a StartDate(Date Time Picker1)and EndDate(Date Time Picker2) with a button1 which launches a Form4 containing a report( Microsoft Report Veiwer)
I have been able to generate a report but it gives me everything in the database instead of date range selected.I have tried generating queries,stored procedures and writing additional code but nothing seems to work.( Though I may of but them in the wrong place)
DB/Reporting :: Listing SQL Statement In Crystal Report
Feb 20, 2008How do I list the SQL statement in my crystal report. I have the report loaded etc using
Dim DA As New SqlDataAdapter
Dim DS1 As New DataSet
DA.SelectCommand = New SqlCommand(gSQL, SQLConn)
DA.Fill(DS1, "JobID")
Dim CR1 As New ShowFiles
cr1.Load(gActiveReport)
cr1.SetDataSource(DS1.Tables("JobID"))
CRV1.ReportSource = cr1
This shows my report But how do I reference the SQL Statement, I can see in in report design but cant find it in the loaded report
DB/Reporting :: Print In Crystal Report Viewer?
Feb 16, 2004may i use shortcut key like Ctrl+P to print the report in Crystal Report Viewer?
View 2 RepliesLooking For Any Reporting Services, Ie, Microsoft Report Viewer?
Apr 1, 2010Does Visual Basic 2010 have any reporting services, ie, Microsoft Report viewer?
View 6 RepliesCreate Report With Report Viewer
Oct 2, 2010in my app, I want to use reports. It's a long time ago, when I created my first report and that was in vb6. Now, I would like to use the report viewer control and the reports, created in vb.net. I use postgresql database with an ado.net connector (also I have dataadapters, datasets, datareaders, etc). I created a form and placed a report viewer on it and I added to my project the first empty report too.
[Code]...
DB / Reporting - Duplex Crystal Report, Portrait And Landscape
Feb 22, 2011Using VB2008 Crystal reports. We are busy to create a duplex crystal report, size A4. The front of the CR is a portrait view and the backside must a landscape view. In our project we have made two CRs, one portrait and one landscape. Till now two pieces of paper are printed. Can someone give us more information how to configure CR?
View 5 RepliesDB/Reporting :: Crystal Report That Fails On A Formula Field?
Apr 14, 2008I have a crystal report that fails on a formula field but I cannot see why.
Here is my code:
Code:
Public Function CreateReportPDF(ByVal dsReport As DataSet, ByVal CrystalReportPath As String, _
ByVal reportSize As String, ByVal landScape As Boolean, _
ByVal dsParameters As DataSet, ByVal filePath As String, _
ByVal fileName As String) As Boolean
[Code]...