http://www.crystalreportsbook.com/forum This is an XML content feed of; Crystal Reports Forum : Writing Code : Last 10 Posts Fri, 11 Sep 2026 07:25:00 +0000 Fri, 27 Aug 2021 05:03:11 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 8.04 30 www.crystalreportsbook.com/forum/RSS_topic_feed.asp?FID=13 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22950&PID=75156#75156 Author: lockwelle
Subject: Pguri - Crystal Report ParameterField, how to get
Posted: 27 Aug 2021 at 5:03am

I would look at the SQL behind the Dataset - CompanyName. That would give you clue of where it is in the database.

HTH]]> Fri, 27 Aug 2021 05:03:11 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22950&PID=75156#75156 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22950&PID=75155#75155 Author: death25
Subject: Pguri - Crystal Report ParameterField, how to get
Posted: 27 Aug 2021 at 4:25am

hi everyone,
A dynamic cascading ParameterField has following 2 Attributes:

IsDCP = True PGURI = crobj://{A7E6ABA3-D039-45AB-94CB-CD54C4A392B3}

The parameterfield has the value CompanyName for example




][2]
][1]

In code i can get the field by



but i have only the PGURI and now informations about the used database field..thanks for help..]]> Fri, 27 Aug 2021 04:25:40 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22950&PID=75155#75155 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22904&PID=74980#74980 Author: lockwelle
Subject: Visual Studio 2017 Crystal reports issue
Posted: 05 Oct 2020 at 11:47am

First thing that comes to mind is, is the connection string for the report the same? Perhaps you need to set the connection string for the report in code.

Of course the other thought is, does the report work in the crystal designer? That might help in troubeshooting.

HTH]]> Mon, 05 Oct 2020 11:47:14 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22904&PID=74980#74980 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22904&PID=74978#74978 Author: Tvalone
Subject: Visual Studio 2017 Crystal reports issue
Posted: 05 Oct 2020 at 7:53am

I have a .net app written in c#. My desktop was upgraded to a laptop (yay....) The references were copied over and VS was installed on the laptop. I installed crystal on the laptop and added the references back to get the app to build without error. However when I test the app in VS I get this error.

The type initializer for 'CrystalDecisions.CrystalReports.Engine.CRPE' threw an exception

I cannot for the life of me figure out what the issue is.]]> Mon, 05 Oct 2020 07:53:03 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22904&PID=74978#74978 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22892&PID=74970#74970 Author: lockwelle
Subject: filter report to show record on form
Posted: 21 Sep 2020 at 11:48am

Depends on how the report is getting data. If it is calling a stored proc, you would need to pass the record displayed on your form to the proc and have it filter the data. If you are pushing the dataset to the report, you could use linq or a loop to filter the dataset to only have the data for the record that is displayed.

For pushing the data, you can have the app call the stored proc, then filter out the records that are not needed and finally set the reports.DataSource to the filtered dataset (or it can be a datatable).

HTH]]> Mon, 21 Sep 2020 11:48:00 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22892&PID=74970#74970 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22892&PID=74952#74952 Author: bigmacagain
Subject: filter report to show record on form
Posted: 05 Sep 2020 at 8:13am

hello can you help a newbie please, i am using visual studio 2019 , i have a form(frm1) and this has shows 1 record from my database, i want the user to click a button and show a report filtered to the record shown on frm1, i have a button that opens the report but shows all records, how can i filter it in VB to on load just show the record on the form please?    ]]> Sat, 05 Sep 2020 08:13:46 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22892&PID=74952#74952 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22274&PID=72817#72817 Author: hilfy
Subject: Crystal Report Formula to Identify export files
Posted: 05 Apr 2017 at 6:24am

I don't understand your question. How are you running the report to export?

-Dell]]> Wed, 05 Apr 2017 06:24:24 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22274&PID=72817#72817 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22274&PID=72759#72759 Author: podiman
Subject: Crystal Report Formula to Identify export files
Posted: 26 Mar 2017 at 6:57pm

A symbol or something has to print on the crystal report layout to identify the crystal report layout which is exported one.

Please help me to build the logic ]]> Sun, 26 Mar 2017 18:57:18 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22274&PID=72759#72759 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22158&PID=72287#72287 Author: nix1016
Subject: Filter list of parameter fields being prompted
Posted: 28 Nov 2016 at 6:45pm

With all of our reports we have a list of parameters being passed from our program and then a list that is entered by the user during runtime. With the user prompted parameters, their names all start with 'Prompt'. This is fine when we preview the reports since any parameters set using SetParameterValue(paramname,paramvalue) do not show up.

However, when the report is directly printed or exported, then we need to call up Crystal Report Viewer to prompt the user for the User-selected prompts. Currently the code to do this is:

crReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
crReport.Load(filename);
crReport.Refresh();
crReport.SetParameterValue(parameterName, parameterValue);
CrystalReportViewer1 = NEW CrystalDecisions.Windows.Forms.CrystalReportViewer();
CRViewer1.ReportSource = crReport.
CRViewer1.EnableRefresh = true.
CRViewer1.RefreshReport().

which works fine but it displays all parameters in the prompt, even the ones that have already been set using the SetParameterValue method.

Is there anyway that I can hide those? As mentioned, they all start with 'Prompt'.
Also, I found this
article which explains that I'm not meant to use the RefreshReport() method, however I cannot for the life of me find a way to bring up the prompt without using that method. I've tried CRViewer1.Refresh(), CRViewer1.Visible = TRUE, CRViewer1.Show() all to no avail.

Any advice? Thanks!

Edited by nix1016 - 28 Nov 2016 at 6:46pm]]> Mon, 28 Nov 2016 18:45:22 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22158&PID=72287#72287 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22155&PID=72282#72282 Author: nix1016
Subject: CR viewer no longer allowing background
Posted: 27 Nov 2016 at 11:38am

Hi All,

We recently upgrade our database platform which meant that we had to stop using Crystal Runtime XI and adopt CR for VS 13.0.18. There is an issue in that when we bring up the crystal reports viewer and the report is generating, we cannot no longer use our software in the background. However, once the report is generated and displayed in the CRViewer, we are able to use our software without any issues. The .Net form containing the CR report is non-modal and it seems that we can still click on buttons and menus in our software in the background whilst the report is generating but nothing happens.

It used to be fine with CR runtime XI so if it's just a property or something I'm not setting in the new version.

Any ideas is appreciated as it often takes minutes to generate a single report and we can't do anything now but wait.

Thanks!]]> Sun, 27 Nov 2016 11:38:46 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22155&PID=72282#72282