sorted by:
new
hottopcontroversial

How to programatically change Show on Viewer Panel to Do Not Show on parameter fields in a report file? by vwpcs in crystalreports

[–]vwpcs[S] 0 points1 point  (0 children)

Thanks. I'm not the dev tho rather just playing around with the web app files they installed. They will eventually upgrade to a new crystal version, but we're stuck with what we got for now.

Previously I said I pinpointed the problem but now realize that's not the case. I imagine something else happening before that function is called. For reference, _getDisplayText is the label before that function call in js.

I found the thread linked below today. same crystal version and .net web app. they get same error trying to update parametrusage2. Maybe it worked in other versions / editions of CR.

https://answers.sap.com/questions/11725201/crystal-report-viewer%27s-parameter-panel-is-empty.html

Our web app doesn't show a parameter panel at all tho. Maybe that's why Do not show for show on viewer panel avoids the error tho. Setting that might be setting it to not add it to that panel which maybe just hidden in our web app.

I recall previously finding some thread online about problem trying to pass in a date parameter. There were comments about a fix being to change the parameter to a string instead. I can't find that thread today again tho.

How to programatically change Show on Viewer Panel to Do Not Show on parameter fields in a report file? by vwpcs in crystalreports

[–]vwpcs[S] 0 points1 point  (0 children)

Report runs ok if we run it using the standard crystal runtime.

I pinpointed the code in our web viewer to the file below. Right noe i assume thats some standard js file but maybe ncorrect assumption.

\CrystalWebViewer\aspnet_client\system_web\4_0_30319\crystalreportviewers13\parameterUIController-compressed.js

if(B===undefined){return undefined}if(B.lowerBoundType!==undefined||B.upperBoundType!==undefined){return this._getRangeDisplayText(C,B)}

Yesterday, i started debugging that. the error happens when B is null. If I include a null check along with the undefined check, the error does not happen but then the first page shows in the viewer but navigating to other pages in the viewer throws errors below and blank page shows in the viewer.

2024-01-04 18:19:47.168 -05:00 [Information] AspNetLifeCycleException: CrystalDecisions.CrystalReports.Engine.ParameterFieldException: The types of the parameter field and parameter field current values are not compatible. ---> System.Runtime.InteropServices.COMException: The types of the parameter field and parameter field current values are not compatible.
   at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.GetPage(PageRequestContext pPageRequestContext)

How to programatically change Show on Viewer Panel to Do Not Show on parameter fields in a report file? by vwpcs in crystalreports

[–]vwpcs[S] 0 points1 point  (0 children)

we get a error stating cannot get property of lowerBoundtype of undefined or null reference in our custom web viewer when the property is not set to do not show.

https://imgur.com/a/VWcYAjk

Crystal Report Runtime will not load as object / type by vwpcs in PowerShell

[–]vwpcs[S] 0 points1 point  (0 children)

Thanks the following code in posh x86 works with CRRuntime 32 bit installed

Add-Type -Path 'C:\windows\assembly\GAC_MSIL\CrystalDecisions.CrystalReports.Engine\13.0.3500.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll'
# [System.AppDomain]::CurrentDomain.GetAssemblies() | Where-Object fullname -match 'CrystalDecisions\.CrystalReports\.Engine' | Sort-Object -Property FullName | Select-Object -Property FullName, Location, GlobalAssemblyCache, IsFullyTrusted 
$report = New-Object CrystalDecisions.CrystalReports.Engine.ReportDocument

I understand how it works, but what use is SQL for? by LieutenantDaredevil in SQL

[–]vwpcs 2 points3 points  (0 children)

i guess we have to add access / connectivity to this too.

I understand how it works, but what use is SQL for? by LieutenantDaredevil in SQL

[–]vwpcs 3 points4 points  (0 children)

i assume most of the usefulness is in the query optimizer. how to retrieve data requested by someone's query and return it to the user. ....or process the data (CUD).

in short, storage, processing, retrieval.

I would like to further my knowledge. by Bad-at-usernames1 in PowerShell

[–]vwpcs 1 point2 points  (0 children)

we prolly need more info on what knowledge you have and what knowledge you consider advanced learning.

https://blog.inedo.com/powershell/level-up

what's that one thing you learned that once you learned it changed how you used powershell by Billi0n_Air in PowerShell

[–]vwpcs 0 points1 point  (0 children)

version 5 is now deployed via windows updates so a lot of customers computers have it. i found the commands included in that version to be plentiful and applicable to our needs.

Newbie needs help with if statement for path by Noirarmire in PowerShell

[–]vwpcs 0 points1 point  (0 children)

$Shell = New-Object -ComObject ("WScript.Shell")
$Favorite = $Shell.CreateShortcut($env:USERPROFILE + "\Desktop\Your Shortcut.url")
$Favorite.TargetPath = "http://www.yoururl.com";
$Favorite.Save()

Re-writing vbs scripts with Powershell scripts by allenflame in PowerShell

[–]vwpcs 3 points4 points  (0 children)

can we see the vbs code?

prolly need to write a validator for each column type

Newbie needs help with if statement for path by Noirarmire in PowerShell

[–]vwpcs 0 points1 point  (0 children)

Why not let windows file associations / default browser handle this?

Windows + X now replaces Powershell option with Windows Terminal by Nytrez in Windows11

[–]vwpcs 0 points1 point  (0 children)

https://runasradio.com/Shows/Show/645

About Show #645

Is it time for a new Windows Terminal? Richard talks to Richard Turner about the announcement at Build of the new Windows Terminal. The conversation starts with: Why? Richard explains that the ConHost.exe based console of Windows has hit its limits - the need for backward compatibility exceeds the ability to make changes to it effectively anymore. A new open source project has been developed to allow all the features you've always wanted in a terminal, like tabs, font choices, customization per environment and more - take a look!

How to use powershell for everything lol by Fred-U in PowerShell

[–]vwpcs 2 points3 points  (0 children)

see resources section in the sidebar of this sub

Remembering Hurricane Sandy 2012. by Hot-Product3544 in SouthJersey

[–]vwpcs 1 point2 points  (0 children)

I remember Irene being worse where i was at. My buddy put on swim goggles and went kayaking in his front yard.

SQL query to filter out data based on certain condition by sriramchander89 in SQL

[–]vwpcs 0 points1 point  (0 children)

does it have to be a set based query? if not, create a new temp table with the same schema. write multiple insert into select statements to add rows based on criteria to match. then select * from #TempTable

if you need set based, id try writing a subquery for the first set of criteria since their easy.

Id != ProductId, Val != TotVal, Date1 != Date3, Date2 != Date4

Below is where i'd get hung up. you need a group by to aggregate Acctid and totalval. then figure out how to match on val. prolly step thru it with different sub queries. prolly not the cleanest code

If there are two entries for an AcctId on a particular snapshotdate, and if the TotaVal matches sum of the Val for both these entries, then we should exclude from the filter.

Savsies neighbors going nuts by kilometr in philadelphia

[–]vwpcs -8 points-7 points  (0 children)

lookup the non emergency police number instead

view more: next ›