Posts by Cassio Milanelo • 791 points
41 posts
-
3
votes1
answer95
viewsQ: Doubt when configuring entities relationship
In a hypothesis, I have an entity to register addresses: public class Endereco { [Key] public int EnderecoId { get; set; } public string TipoLogradouro { get; set; } public string Logradouro { get;…
-
2
votes1
answer895
viewsQ: View passing date to Model in wrong format
I’m using Bootstrap-Datapicker as date field in my form and globalizing with moment-with-locales. The configuration I used is as follows:: $('.datetimepicker').datetimepicker({ locale: 'pt-br',…
-
1
votes2
answers182
viewsQ: Local database (serveless) not modifiable with update
Setting: I’m developing a small app WinForm in C# to distribute to sellers to assemble their quotes more quickly and would like to store simple information such as budget issued and registered…
-
0
votes1
answer122
viewsA: Release with Report does not run on other Pcs
I solved the problem by installing two Nuget Packages: Microsoft Report Viewer Microsoft.Sql.Server.Types I thought it was better than just copying the Dlls. Thanks to @Richard Dias who showed me…
-
0
votes1
answer122
viewsQ: Release with Report does not run on other Pcs
I created a Winform that contains Reports searching for data on an object DataSet (which is programmatically populated using an SQL Server source). The release is stored on the server and can be…
-
1
votes1
answer196
viewsA: Report from Dataset created in a Class
Okay, the answer was simpler than I thought. All that was missing was creating an instance of Dataset as any class. I didn’t think it would be necessary but I learned from Dataset that yes.…
-
1
votes1
answer196
viewsQ: Report from Dataset created in a Class
How do I create a Visual Studio 2013 Report from a Datatable (or Dataset) created in a method? When searching for the Report.rdlc data source I refer to the class where Datatable is created, but it…
-
7
votes2
answers686
viewsQ: Full Join N-N without repeating records
I have two tables with relation N-N: ITEM_ORC ITEM_COMP | OP | Item Orçado | | OP | NF | Item Comprado | +-------+------------------+ +-------+---------+------------------+ | 1 | Lápis | | 1 | 101 |…
-
8
votes1
answer2080
viewsQ: Random() generating repeated numbers
I am developing a small application to perform XML import, which searches the items present in the note and performs the search for them in DB company. When the item is not found, the link is done…
-
0
votes3
answers3047
viewsA: Unfulfilled Nfe XML
I ended up using a for to scan the contents of Item and a Switch to select the correct class (which seemed to me a very bad service, by the way): string porcICMS; string porcIPI; for (int j = 0; j…
-
4
votes1
answer1098
viewsQ: Search in Datagridview populated by typing on it
I own a DataGridView already with recovered data where user selects an item. But, as the items are numerous, I would like to enable the user to type on the Datagrid while the system "goes" to the…
c#asked Cassio Milanelo 791 -
4
votes3
answers3047
viewsQ: Unfulfilled Nfe XML
Well, I’m trying to do the reading for import of XMLs of the Electronic Tax Notes and I’m having a lot of difficulty in disemboweling the ICMS of the blessed. No problems to reach the object ICMS:…
-
0
votes0
answers52
viewsQ: Wordpress changing URL when accessing links
I have a domain www.dominio.com.br that points to my server and is redirected via .htaccess for the sub-folder www.dominio.com.br/novo through the following code: RewriteEngine on RewriteCond…
-
5
votes2
answers2457
viewsQ: 301 redirect outside the domain with htaccess
I own a domain www.dominio1.com.br that points to the root of my site and another domain www.dominio2.com.br configured as redirector to www.dominio1.com.br/novo. However, I would like the user to…
-
1
votes0
answers93
viewsQ: Shared variable in the same section - Crystal Reports
Is there any way to use a Shared Var in the same section of the Main Report where the Sub-Report is?
-
0
votes0
answers321
viewsQ: Division of duplicates into a Subreport - MSSQL/Crystal Reports
I would like to generate a tax forecasting report for PIS and COFINS, which are calculated based on a CFOP code of banknotes issued in a given period, but I would like to separate this information…
-
0
votes2
answers45
viewsA: Multiplications contained in texts
With this new column, things got a lot easier. I did the following: 'Area' = (CONVERT(decimal,SUBSTRING(table.CodItem,2,3))* CASE WHEN SUBSTRING(table.CodItem,8,1) LIKE '[0-9]' THEN…
-
0
votes2
answers45
viewsQ: Multiplications contained in texts
How to make the multiplications contained in a field varchar? (to get the area in case) +------------------------------------------------------+ | DESCRIÇÃO |…
-
3
votes2
answers192
viewsQ: Value based on another field (Crystal Reports)
How do I get the Valor Unit of the last purchase in Crystal Reports in a resulting table as the following? +-------------+---------------+------+------------+---------------+ | CodItem | DataCompra…
-
4
votes1
answer1076
viewsQ: Field SUM of two MSSQL Sub-consultations
I need a field derived from two sub-consultations that gives the sum of values based on a field. Follow example: SQL: SELECT CodCliente ,DataVenda ,Vendedor ,Valor ,DataPagamento ,TotalCliente…
-
1
votes1
answer854
viewsQ: List-based WHERE filter with SQL
Good afternoon! Please, I am making a Fiscias Notes filter based on a series of Cfops with SQL. It works like this: SELECT * FROM NotasFiscais WHERE CFOP = 5101 OR CFOP = 6101 OR CFOP = 5922 OR CFOP…
sqlasked Cassio Milanelo 791 -
1
votes1
answer574
viewsQ: Graphics with Crystal Reports
Good morning! I have a report that shows sales performance per seller compared to periods. I would like to plot this data with a line chart as follows: Eixo vertical (Y): Soma de valor de venda (por…
-
1
votes1
answer613
viewsA: Handheld report headers appear in Crystal Report
After all, the path is the same, but somewhere else. I also needed to activate the same option on: Crystal Reports > Report > Report Options... > Mostrar todos os cabeçalhos em pesquisa…
crystal-reportsanswered Cassio Milanelo 791 -
0
votes1
answer613
viewsQ: Handheld report headers appear in Crystal Report
I enabled the "Show all headers in detailed search" option in my report, but when I open a detailed search, neither headers nor footers appear. Follows the structure of my report: --Cabeçalho do…
crystal-reportsasked Cassio Milanelo 791 -
0
votes1
answer996
viewsQ: Sum by period in Crystal Reports
How do I use the SUM function for a period specified in the parameter? For example: SUM(Relatorio.Faturamento, DATE(2015,01,01) to {?DataFinal})
crystal-reportsasked Cassio Milanelo 791 -
1
votes2
answers2788
viewsA: How to create a report with Crystal Reports parameters?
It is quite simple to use parameters as a filter: Right click on Parameter Field > New... Fill in the required values. For example, for a Start Date filter (basic): "NOME": DataInicial "TIPO":…
-
3
votes4
answers1991
viewsA: Difference between span img and div img
Briefly, <span> is most often used for elements outside the general rule of the grouping element surrounding it (a <div> for example) Take a look at this site, it’s very educational:…
-
2
votes1
answer1156
viewsA: Page header in section details in Crystal Reports
Crystal Reports > Report > Report Options... > Mostrar todos os cabeçalhos na pesquisa detalhada That solves my problem. Tip for those who use Crystal!
-
0
votes1
answer1156
viewsQ: Page header in section details in Crystal Reports
Good morning to all! I created a commission report with Crystal Reports in Visual Studio with a date filter. Each month is sent to the sellers individually their commissions in the period. To open…
-
0
votes1
answer1467
viewsA: Application with Crystal Reports does not find database in client
Well, just to finish the case, I ended up solving it in a very simple way. I made the connection to the database directly through the Crystal Reports Database Fields and on the login line I put only…
-
1
votes1
answer1467
viewsQ: Application with Crystal Reports does not find database in client
I made a small application that uses Crystal Reports to generate reports. I did the . EXE of it with Instalshield LE, installed it on my PC and spun beauty. However, when installed on another…
-
2
votes3
answers516
viewsA: Column outside the SELECT WHERE condition
I made my SELECT like this: SELECT CustosVendaItemPed.CodConta ,CustosVendaItemPed.Descricao ,OrdensProducao.NumOrdem 'OP' ,NotasFiscais.DataEmissao 'Data Emissão' ,NotasFiscais.NumNota 'Nota'…
-
2
votes3
answers516
viewsQ: Column outside the SELECT WHERE condition
I need to make a query that returns a column with the amount of orders that the customer made within the period past in the WHERE and put together another column with the total orders that the…
-
1
votes3
answers563
viewsA: Problems with LEFT JOIN
The table ItemNota has two IDs (Don’t ask me why, I didn’t create the comic) and the ID that connects with the table Notas is the ObjID_Notas. About relationships, I did the following: FROM…
-
3
votes3
answers563
viewsQ: Problems with LEFT JOIN
I’ve been racking my brain for a few days with SQL on something that should be very simple, but I can’t fix it. I want to get all data from the table [Numorder] including those not in the table…
-
1
votes1
answer1710
viewsQ: GROUP BY and SUM at Crystal Report
I need to do something relatively simple with Crystal Report but I’m not getting it. I have a report like this: OP | CLIENTE | PREÇO 1 João 10 1 João 20 1 João 30 2 Marcelo 15 3 Rodrigo 35 3 Rodrigo…
-
1
votes1
answer257
viewsA: Crystal Report with LEFT JOIN and WHERE
I ended up solving my problem by changing the relationship orders of the tables. Before they were like this: [Orçamento]-[OrdemProducao] -> [ItemPedido]-[NotaFiscal] I modified it to:…
-
3
votes2
answers1432
viewsA: Distribute <li> list in 3 columns
One way is to apply the float:left to all <li> and tag <ul> within a <div> of defined size. It would look like this: HTML: <div id="main"> <ul> <li…
-
2
votes1
answer257
viewsQ: Crystal Report with LEFT JOIN and WHERE
I’m having a problem making one LEFT JOIN in Crystal Reports. From what I’ve researched, it’s a classic SQL problem when using criteria WHERE crossing with the LEFT JOIN. I tried to solve every way,…
-
1
votes2
answers665
viewsA: Datagridview with columns of different tables of a Dataset
Finally got. To generate the reports I used Crystal Report and for the login problem I added the following line in my App.Config: <startup useLegacyV2RuntimeActivationPolicy="true"> I’m sorry…
-
1
votes2
answers665
viewsQ: Datagridview with columns of different tables of a Dataset
I imported 16 tables from mine MSSQL in a DataSet and made all the necessary relationships. I need to generate a report on a DataGridView (or other tool) with columns specific to several tables. How…